All,
I have 200+ files located in a folder, which have random file names.
I need to open each file, run a script which reformats the file and then save the file as 1...200 i.e. save the first file as 1., the second one as 2. etc. in another particular folder.
Is there a way I can do this in VBA?
Thanks!
Bookmarks