View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Craig[_24_] Craig[_24_] is offline
external usenet poster
 
Posts: 39
Default Excel macro to open files within a folder

I'm trying to create a macro to open all of the files within a certain
folder. For example, it would open all of the .xls files in
C:\Timesheets. I'm lost on how to do this. I'm able to get a single
file open if I have the file name, but the file names are going to
vary. Also is it possible to only open certain files within a specific
folder based on parameters of the filename (like all files starting
with 07*****.xls)?