View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Theresa Theresa is offline
external usenet poster
 
Posts: 55
Default Use Macro to Select All Files Within A Folder

Hi:

I am trying to create a macro that will select all files within a folder to
open them. The folder name will change as will the number of files within
each folder. I need to open 800+ files then run another macro once they are
open.

Any suggestions on how I can select the folder I want (it's ok if I have to
manually change folder names), then have the macro continue and select all
files within the folder to open them?

Thanks,