Re: $$Excel-Macros$$ List all Excel Workbooks

2011-12-23 Thread dguillett1
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

Re: $$Excel-Macros$$ List all Excel Workbooks

2011-12-23 Thread Cab Boose
om:* Cab Boose > *Sent:* Thursday, 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 o

Re: $$Excel-Macros$$ List all Excel Workbooks

2011-12-23 Thread dguillett1
uillett SalesAid Software dguille...@gmail.com From: Cab Boose Sent: Thursday, 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:

Re: $$Excel-Macros$$ List all Excel Workbooks

2011-12-22 Thread Cab Boose
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 wrote: > Hi Charlie, > Plea

Re: $$Excel-Macros$$ List all Excel Workbooks

2011-12-22 Thread siti Vi
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# '

$$Excel-Macros$$ List all Excel Workbooks

2011-12-22 Thread Cab Boose
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 t