View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Open All Workbooks

Hi jim

See this example page
http://www.rondebruin.nl/fso.htm
You can change the copy code to your code


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jim Jackson" wrote in message ...
I seem to remember seeing code for finding all workbooks in each folder and
subfolder, opening and then closing each one after importing modules where
they exist. I have searched through the this group's messages but cannot
find the ones I need.

Could someone point me in the right direction?
--
Best wishes,

Jim