VBA to open files in Word

Lu_Argentina · #1 07-25-2011, 01:50 PM

Hi! I have many html files that I want to open and copy its content in another document. The files are consecutive so I would like to write a macro that loops through them, open copy and close.

I have saved a macro and the code is:

Code:

Documents.Open FileName:="page_4.html", ConfirmConversions:=False, _
  ReadOnly:=False, AddToRecentFiles:=False, PasswordDocument:="", _
  PasswordTemplate:="", Revert:=False, WritePasswordDocument:="", _
  WritePasswordTemplate:="", Format:=wdOpenFormatAuto, XMLTransform:=""
Selection.MoveDown Unit:=wdLine, Count:=1
Selection.MoveRight Unit:=wdCharacter, Count:=47, Extend:=wdExtend
Selection.Copy
Windows("Documento2").Activate
Windows("page_4").Activate
ActiveWindow.Close

the file that increases consecutively is page_4.html so I guess I need some for... and a way to name the file.
Thanks!!!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Files don't open correctly	jcgtc	Office	0	05-09-2010 05:56 AM
cant open .htm files from inbox	jamesukm	Outlook	0	02-01-2010 05:27 AM
saving all open files	reverter	Word	5	01-28-2010 03:02 PM
unable to open *.tif files	HARIS	Misc	1	12-01-2009 05:47 AM
Can't open .pst legacy files	RetiredEngineer	Outlook	1	11-14-2009 01:06 PM