LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 454
Default Extract Info From All Files in a Directory Q

Is it possible to extract the following details from All Excel files in
a particular folder (say C:\My Documents\Extract Folder)

1) Author
2) date of Creation
3) Date of extraction i.e. the time and date I run the code (usually
will run every day)

I was hoping to run a piece of code that would extract out the above in
a simple sheet, possibly without even opening the files with 1) above
listed in Column A and 2) above listed in Column B and 3) above in
column C. All files in this folder will be Excel


Thanks

 
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
Extract Info from Multiple files DP7 Excel Worksheet Functions 1 May 15th 07 04:38 PM
Extract all CN='Name' from a Active Directory data-dumped-cell mateo561 Excel Programming 7 December 7th 06 08:32 AM
Extract Data From Active Directory Adrian Excel Programming 1 August 23rd 06 11:44 PM
reporting directory info into a spreadsheet Tim[_39_] Excel Programming 3 August 6th 04 11:47 AM
Check if directory empty OR no of files in directory. Michael Beckinsale Excel Programming 2 December 4th 03 10:12 PM


All times are GMT +1. The time now is 10:48 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"