radhoo Posted December 6, 2008 Share Posted December 6, 2008 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 Link to comment Share on other sites More sharing options...
Developers Jos Posted December 6, 2008 Developers Share Posted December 6, 2008 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 SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past. Link to comment Share on other sites More sharing options...
DeeRiee Posted December 6, 2008 Share Posted December 6, 2008 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") Link to comment Share on other sites More sharing options...
radhoo Posted December 6, 2008 Author Share Posted December 6, 2008 (edited) Ok, the first problem is solved. Thanks Jos The second too. Thanks guys, fast answer... Edited December 6, 2008 by radhoo Link to comment Share on other sites More sharing options...
radhoo Posted December 6, 2008 Author Share Posted December 6, 2008 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 Link to comment Share on other sites More sharing options...
martin Posted December 6, 2008 Share Posted December 6, 2008 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") EndFuncWhat 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. Link to comment Share on other sites More sharing options...
radhoo Posted December 6, 2008 Author Share Posted December 6, 2008 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... 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