Using macros to open newest file in a directory

[jake]

Hi,

I was wondering how to go about using a VB macro in Powerpoint 2003 to open
the newest file in a directory? I have been using the followhyperlink method,
but only to the parent folder, then the user must find the newest date and
open it themselves. Is there a way to automate this using VB code? The file I
desire to be opened is the daily date.

 

[jake]

To clarify: The files to be opened are saved into different folders depending
on the current month. i.e. >Folder2009

January
Today'sDate.file
February
In The Future.file

So the file path changes subfolders depending on the month, so the link
needs to change also. Is there a method for, say, opening the newest file (by
date), and therefore today's date, in all of 2009 and its sub-folders? All
files are pdf files and the daily date is included in the filename.

 

[Shyam Pillai]

Goto http://vb.mvps.org/. Karl Petersen has a couple of examples (DirDrill
sample and the FileInfo sample) which can be used to determine the newest
file.

Regards,
Shyam Pillai

Image Importer Wizard: http://skp.mvps.org/iiw.htm

 

[jake]

Thanks for that Shyam.

I managed to use the filesearch method with lastmodifiedtoday and it seems
to be working alright.