opening newest file in a directory within a macro

[steven162]

Hi all,

Thanks again for your help with the getting numbers from a column issue I had earlier.

Now the next problem(s)

I want to run a macro that opens the newest file in a directory, extract some data from it and save this in a new file with a name that will include some data within the file (probaly the time)

I think this will be my first experience with Visual Basic but I would like some pointers as to where to start.

thanks again

Steve

 

[DanStro]

You can use the "Scripting.FileSystemObject" look through files in a folder and get the date the file was created or modified.

HTH
dan