Finding Newest File

[Guest]

I'm writing a macro to output an automated sheet to the folder that contains
the latest dates information. I'm not sure on how to sort through or access
the file names in order to find the newest date. After this I want to place
the outputted file into the lastest dates folder.
Another issue is that this macro should only run on tues,thurs, and fridays
at 3 pm.
If someone could help me find a way to put the outputted file into the
newest date's file and automate its runtime I would be very thankful. ps.
I'm very new to visual basic.

Thanks, Dan

 

[Jim Cone]

Two different methods to find the latest file are shown in this post...
http://tinyurl.com/yqmz7x
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel add-ins)



"DanMsoeEE" <[email protected]>
wrote in message
I'm writing a macro to output an automated sheet to the folder that contains
the latest dates information. I'm not sure on how to sort through or access
the file names in order to find the newest date. After this I want to place
the outputted file into the lastest dates folder.
Another issue is that this macro should only run on tues,thurs, and fridays
at 3 pm.
If someone could help me find a way to put the outputted file into the
newest date's file and automate its runtime I would be very thankful. ps.
I'm very new to visual basic.

Thanks, Dan