Name of Last File Saved

[NSearch]

I am working with Excel, and one of a programmers wrote some macros that are not I can not access. The code processes the information and automatically saves the spreadsheet. What I am trying to do is store the name of the saved file, so that I can open it back up and run some additional macros on it.

Does Autoit have a function like that, or does anyone have a good solution.

[jdickens]

Though it's a little clunky, if you know the directory where things will be saved, you could check for the newest file...

Alternately, if the existing macros put the filename into Excel's MRU (most recently used) list, you could get to that using shortcuts in Excel, or sending it keypresses.

Either one sound good?

J

[NSearch]

Thank you for your help. Both of you. I believe that I am going to have another macro query the database for the information that the previous macro used to save the file, and then open it again to process further, but I might end up using one of those solutions.

Thanks again.