View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default opening each file in a folder

Look in Excel VBA help at the DIR function. The sample code provided there
should get you started.

--

Regards,
Tom Ogilvy

"JT" wrote in message
...
I'm having trouble getting started on a macro. I want to go to a specific
folder and open each file with an ".XLS" extension in that folder. Can

that
be done?

If so, I would appreciate any help in getting started with this code.

Thanks
for the help.
--
JT