List Most Recent File Creation Date

[bdb1974]

Hi all I put together some code which at the end of it I am wanting to show in cell D1 the creation date for the most recently created file found.

Please Login or Register  to view this content.

The code runs but, I'm not getting it to return the date value.
Any help is appreciated.

Thanks,

BDB

[Richard Buttrey]

Hi,

What happens if you comment out the On Error Resume Next?
Does the macro still run to the end or does it halt with a Debug?

Rgds

[Leith Ross]

Hello BDB,

If Sfile does not include the directory path, the working directory will be used. If the file is not found an error will occur "File Not Found". You have On Error Resume Next statements in the code. This is probably preventing you from seeing the error that file wasn't found. Comment out the On Error statements so yo can see the error.

[bdb1974]

I commented out everything in the code except for what should bring in the file date.

I also found a typo in the sheet name which I corrected

Please Login or Register  to view this content.

it's "JobNum" in sheet name. Not "JobNob".

When I run, I get will now get a type mismatch for:

Please Login or Register  to view this content.

[Leith Ross]

Hello bdb1974,

You row and column references are reversed.

Please Login or Register  to view this content.

[bdb1974]

Once again... Thanks Leith.

That fixed it.

BDB