VBA Find Latest Folder then largest file.

HI All

I would like to write a procedure which will automatically find and open a file.

The file folder is alway located in c:\backup\

I would like to find the latest folder in the above directory then look in that folder and open the largest file containied within.

Thanks in advance for your help.

I note in other threads the use of fileSearch however, notice this does not seem to work in Excel 2007 which I am using.

Any Ideas on this one anyone?

Thanks for the code guys, appreciate it.

Unfortunately, I am unable to get either to work.

snb - opens CMD but hangs "File Not Found" on the first Loop.

Originally Posted by WAW

Thanks for the code guys, appreciate it.

Unfortunately, I am unable to get either to work.

snb - opens CMD but hangs "File Not Found" on the first Loop.

Please try this way:

Please Login or Register  to view this content.