Create a loop to open all specific XLS in one folder

[davemorse]

Hi,

What I'd like to do is open up all excel documents in the same folder as the xls in which the macro is running from. So say i have a folder in c:\test\macro.xls, i want all xls files here to open and a prerecorded macro to run on all these files and save them all.

Ive created variables such as mypath and myname, how do I loop the macro to run.

Thanks

 

[Krishnakumar]

Hi,

See: http://www.mrexcel.com/board2/viewtopic.php?t=235229&highlight=

HTH