Copying file name

[kane2979]

Hello everyone,

Is it possible to create a mcro in excel to copy file names from a folder and have it in spread sheet for a particualr date modified.

I am spending too much of time in copying these file names from a folder. I know we can do it from DOS, but i needed to have it using excel macro

[stevekirk]

hi,

are you saying you have lots of excel files in a folder and you want the file names in one worksheet?

please explain "for a particualr date modified."

steve

[davesexcel]

First go to Vba editor
Alt F11
Goto tools=>references
scroll down and check
Microsoft scripting runtime and click OK
next go to insert=>module and paste this code there

Please Login or Register  to view this content.

Change the folder destination in the code example:
Set objFol = objFSO.GetFolder("C:\Excel")
this will extract the files from c:\Excel folder
now run the code,

[kane2979]

Thanks for the reply Dave,

This macro gives me all the file names from a given folder with date modified column. I want to have only the given date modified files. It should ask for the modified date and should diplay only the those date modified files.

I would like to add one more criteria for this. It should diplay only the file name which contains the word "xyz".

[kane2979]

Could anyone please let me know if it is possible