, December 22, 2011 3:45 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ List all Excel Workbooks
Hi
There are plenty of solutions for listing open excel files.
I would like to list all excel workbooks on my C: and F: drives. They
are all over the place. My bad housekeeping
OK. Respond to this and let me know.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Cab Boose
Sent: Friday, December 23, 2011 3:58 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ List all Excel Workbooks
Hi Don
That would be great. I am on 2000 at the moment
Hi
There are plenty of solutions for listing open excel files.
I would like to list all excel workbooks on my C: and F: drives. They
are all over the place. My bad housekeeping!
How do I get the complete address for each workbook ? either with a
hyperlink or not. But do need to print out
Hi Charlie,
Please check and try this code, if it helps...
'---standard Module-
Sub *GenerateList*()
' sitiVi / jakarta 23 Dec 2011
' in answering:
' http://groups.google.com/group/ _
' excel-macros/browse_thread/thread/9dbda650f1d09d65#
Hi
After about 3 minutes (30Gig on hardrives) it came up with:
Run-time error '-2144010224 (803500 10)':
Method 'Execute' of object 'FileSearch' failed
Your comments would be appreciated.
Thanks
Charlie Harris
On Fri, Dec 23, 2011 at 5:28 PM, siti Vi setiyowati.d...@gmail.com
