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: 49
Default Getting file name and Modified date

Hi,
I need to get the file names and modified date for file using 'PDA*.PDF' and
searching all subdirectories
What I have tried

Dir() will only give me the file name

Application.FileSearch to so long to do just one directory

Scripting.FileSystemObject I can't get it to use wild cards for the file name

I think the Scripting.FileSystemObject will do what I want but I need some
help to get it to use wild cards and to search the sub directories

Thanks MarkS

 
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
Date Modified File Organization Roadsignologist Excel Discussion (Misc queries) 3 December 18th 08 04:34 PM
Formula for file modified date Pastel Hughes Excel Discussion (Misc queries) 3 April 4th 08 06:23 PM
insert the date the file was last modified Ted M H Excel Discussion (Misc queries) 5 September 2nd 07 03:28 PM
date file modified Matthew Excel Discussion (Misc queries) 2 October 11th 06 06:52 PM
Get the date a file was modified JustinP Excel Programming 2 September 5th 06 04:54 AM


All times are GMT +1. The time now is 02:56 AM.

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

About Us

"It's about Microsoft Excel"