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!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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