Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 476
Default document information from folder

I have about 200 workbooks in a folder. I want a macro to create a sheet (or
add information to a worksheet I have open) that lists the filenames in the
folder, as well as the date created, last date modified, the value in cell
"A1" and the number of times the value in column A begins with "2" and the
number of times it begins with "6". I know how to do some of those things
but not all of them. Any help is appreciated.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking folder information with Excel 2007 Brandon190 Excel Discussion (Misc queries) 0 February 11th 09 02:16 PM
Folder information md Excel Discussion (Misc queries) 2 December 15th 06 02:40 PM
Hyperlink from an Excel/Word document to an Outlook folder ChrisLouie Excel Discussion (Misc queries) 1 September 7th 06 10:22 PM
how do i display a preview of an excel file in a document folder? medici Excel Discussion (Misc queries) 1 May 11th 06 12:00 AM
linking an excel document to my task folder in outlook hallbb1 Excel Discussion (Misc queries) 0 January 10th 05 04:07 AM


All times are GMT +1. The time now is 12:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"