NSearch Posted May 10, 2005 Share 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. Link to comment Share on other sites More sharing options...
Blue_Drache Posted May 10, 2005 Share 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 Link to comment Share on other sites More sharing options...
NSearch Posted May 10, 2005 Author Share 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. Link to comment Share on other sites More sharing options...
NSearch Posted May 10, 2005 Author Share 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? Link to comment Share on other sites More sharing options...
NSearch Posted May 10, 2005 Author Share 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. Link to comment Share on other sites More sharing options...
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