Jump to content

Recommended Posts

Posted

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.

Posted

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

Posted

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.

Posted

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?

Posted

GUICtrlRead($value10) worked....

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

Any help would be much appreciated.

Thanks.

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
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...