Sign in to follow this  
Followers 0
radhoo

GUISetOnEvent issue

7 posts in this topic

Hi,

I am trying to run excel when pressing a button and put a text on it.

I have this code :

GUISetOnEvent($IDbuton_test1, Run("C:\Program Files\Microsoft Office\Office10\Excel.exe"))  
send("some text")

The button doesn't opne the excel and the send function when used like this, doesn't write anything in the file.

Run("C:\Program Files\Microsoft Office\Office10\Excel.exe")
send("some text")

Can you help me with this 2 issues?

Thanks

Share this post


Link to post
Share on other sites



The second parameter in GUISetOnEvent() must be a Func name of the Func to be performed.

Have a look at the Helpfile example for this Function.

Jos


Visit the SciTE4AutoIt3 Download page for the latest versions  - Beta files                                How to post scriptsource        Forum Rules
 
Live for the present,
Dream of the future,
Learn from the past.
  :)

Share this post


Link to post
Share on other sites

I'm using office 2007

so i change office10 to office12

Run("C:\Program Files\Microsoft Office\Office12\Excel.exe")
WinWaitActive("Microsoft","")
send("some text")

Sorry 4 Bad English, I'm Indonesian...I'm really need 'Translator' for helping me posting in this forum (http://deeriee.wordpress.com)

Share this post


Link to post
Share on other sites

#4 ·  Posted (edited)

Ok, the first problem is solved. Thanks Jos

The second too.

Thanks guys, fast answer...

Edited by radhoo

Share this post


Link to post
Share on other sites

One more thing, what I have to do to save the file ?

Func f_test1()                                                             
    Run("C:\Program Files\Microsoft Office\Office11\Excel.exe")
    WinWaitActive("Microsoft","")
send("some text")
EndFunc

Share this post


Link to post
Share on other sites

One more thing, what I have to do to save the file ?

Func f_test1()                                                             
    Run("C:\Program Files\Microsoft Office\Office11\Excel.exe")
    WinWaitActive("Microsoft","")
send("some text")
EndFunc
What file?

Serial port communications UDF Includes functions for binary transmission and reception.printing UDF Useful for graphs, forms, labels, reports etc.Add User Call Tips to SciTE for functions in UDFs not included with AutoIt and for your own scripts.Functions with parameters in OnEvent mode and for Hot Keys One function replaces GuiSetOnEvent, GuiCtrlSetOnEvent and HotKeySet.UDF IsConnected2 for notification of status of connected state of many urls or IPs, without slowing the script.

Share this post


Link to post
Share on other sites

I am trying to run excel when pressing a button and put a text on it, then save the excel file. So the saving part I don't know...

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