Open All Workbooks
 

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

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

Open All Workbooks
 

Thanks, Ron. This is exactly what I was looking for. I have added it to my
Bookmarks so as not to lose it again.
--
Best wishes,

Jim


"Ron de Bruin" wrote:

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