Thread: Use Macro to Select All Files Within A Folder
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JakeyC JakeyC is offline
external usenet poster
  
Posts: 107
Default Use Macro to Select All Files Within A Folder
OK! I just tried opening 800 blank workbooks on my not-so-high-spec
machine and got stuck at 313!

If your folders and files are named sequentially or in a pattern, use a
loop to cycle through them

eg.
ThisFolder1\MyFile1

ThisFolder1\MyFile2

ThisFolder2\MyFile1

ThisFolder2\MyFile2 etc.

Else you'll literally have to say 'Open the file with name blahblahblah
then dostuffwithit' for each individual file.

That is as far as I know.

If any clever people know code for 'open the first file in a folder,
then the next' I'd be impressed to see it.

Reply With QuoteReply With Quote