Charlie, what is your excel version. I have one for xl2003 not updated for
xl2007>, that searches all of my c drive and makes a list of 4000+ files
quickly. You could change to F:\ and it will search that one with sub folders
files
name Date Size Full file Name
CabooseAddressVBA1 12/18/2011 06:39 145920
C:\emails\CabooseAddressVBA1.xls
You may also
DOUBLE CLICK ON ROW 4 TO SORT BY THAT COLUMN
DOUBLE CLICK ON Filename ROW in ANY COLUMN to OPEN that file
Select Filename Row in Any Column & click Kill button to delete file and
row
Don Guillett
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: 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 the list.
Using Excel 2000 at the moment but soon hopefully to upgrade to 2003
Thanks & Merry Christmas to all
regards
Charlie
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
