NSearch Posted May 10, 2005 Posted May 10, 2005 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 Posted May 10, 2005 Posted May 10, 2005 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
NSearch Posted May 10, 2005 Author Posted May 10, 2005 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 Posted May 10, 2005 Author Posted May 10, 2005 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 Posted May 10, 2005 Author Posted May 10, 2005 GUICtrlRead($value10) worked.... But I am still having trouble with closing after the file automatically saves. Any help would be much appreciated. Thanks.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now