Sign in to follow this  
Followers 0
NSearch

Name of Last File Saved

3 posts in this topic

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.

Share this post


Link to post
Share on other sites



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


If I am too verbose, just say so. You don't need to run on and on.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0