Sign in to follow this  
Followers 0
NSearch

Excel Auto Save

5 posts in this topic

Hello All.

So far I have a text box which stores the file name to be saved. I would like to run a excel macro by sending keystrokes. All of that I know how to do, but I do not know how to autosave an excel spreadsheet using the stored file name. Does anyone know how to do this?

Thank you.

Share this post


Link to post
Share on other sites



Hello All.

So far I have a text box which stores the file name to be saved. I would like to run a excel macro by sending keystrokes. All of that I know how to do, but I do not know how to autosave an excel spreadsheet using the stored file name. Does anyone know how to do this?

Thank you.

<{POST_SNAPBACK}>

"Simulated Human" script would work well in this instance, I believe. Try opening the file menu, and selecting "Save As" and then inputting the path/to/file.xls on the controlID of the textbox, then clicking the "OK" button.

Lofting the cyberwinds on teknoleather wings, I am...The Blue Drache

Share this post


Link to post
Share on other sites

Thank you, I did not realize that the script had a text box that comes up and automatically saves the spread sheet. The problem now is that the speadsheet stays open, and I do not want to close excel before it saves. So is there a function that waits until the open application has processed before closing?

Thank you.

Share this post


Link to post
Share on other sites

I can type anything in the text box and I get 13 for a result....

Code:

$value10 = GUICtrlCreateInput("Duplicate Report File Name", 80, 255, 150)

GUICtrlSetState(-1,$GUI_ACCEPTFILES)

MsgBox(0, "Input Value", $value10)

What is going on here?

Share this post


Link to post
Share on other sites

GUICtrlRead($value10) worked....

But I am still having trouble with closing after the file automatically saves.

Any help would be much appreciated.

Thanks.

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