So I am basically new to Macros; I took Java a long time ago. I am trying to create a macro where it goes into a folder of my choice and it pulls out the most recent file.

Example:

Folder is - C:\Users\ywatanabe\Desktop\Security Database\Vendor Out\

Files look like - vendor-195709 - 10.31.2012; vendor-195709 - 11.05.2012; etc.

Can anyone help me create a macro so that it looks up the vendor number and then goes to the most recent one?

It this possible?



Thanks,
-B