Excel Auto Save

[NSearch 0]

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.

[Blue_Drache 259]

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.

[NSearch 0]

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.

[NSearch 0]

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?

[NSearch 0]

GUICtrlRead($value10) worked....

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

Any help would be much appreciated.

Thanks.