Open an special excel file test.xls

[Markir]

Hello,

I want to open the test.xls file by clicking on a button, but I Don't know how to do that.

I know, how I can run a program and this function already.

Can somebody help me please?

[Markir]

Has somebody an idea?

[Joel]

Run(@ComSpec & " /c start " & "test.xls")

If incorporating it with a button in a gui app:

$button = GUICtrlCreateButton ("YourButton", ###, ###, ###, ###)

While 1
   $msg = GUIGetMsg ()
   If $msg = $button Then Run(@ComSpec & " /c start " & "test.xls")   
Wend

Here that's a little cleaner for you. The ###,###,###,### are the positional numbers related to left, top, width, height. So, you have to use actual numbers there in relation to where your button is in the app.

Edited March 23, 2005 by Joel

[Markir]

Hello Joel,

I have now your code in my program, but there must I code a line

Send("123")

? If I make thsi line between the While Code it will be looped

#include <GUIConstants.au3>

Global $msg, $button
GUICreate("My GUI") ; will create a dialog box that when displayed is centered
GUISetState (@SW_SHOW)    ; will display an empty dialog box

$button = GUICtrlCreateButton("Excel öffnen",100,100)

While 1
 $msg = GUIGetMsg ()
   If $msg = $button Then Run(@ComSpec & " /c start " & "C:\test.xls")
Wend

[Markir]

Is it possible that you can go to a special field in the excel sheet, like "B3"?

[mikezwet2]

Maybe with tab button and arrow buttons? Send("{TAB}")

I dont know how to give a sign that goes directly to B3 or something else

[herewasplato]

Is it possible that you can go to a special field in the excel sheet, like "B3"?

<{POST_SNAPBACK}>

Send("^g")

WinWait("Go To")

Send("B3{ENTER}")

[Markir]

Hello,

I have now the following Code, but with this code, the special excel file will not be openend? Why is it so?

#include <GUIConstants.au3>

Global $msg, $button
GUICreate("My GUI") 
$button = GUICtrlCreateButton("Button",100,100)
GUICtrlSetOnEvent(-1, "Button")
GUISetState ()    

While 1
    Sleep(10)
Wend


Func Button()

RUN(@ComSpec & " /c start " & "C:\test.xls")

Send("^g")
WinWait("Go To")
Send("B3{ENTER}")

EndFUnc

[herewasplato]

Hello,

I have now the following Code, but with this code, the special excel file will not be openend? Why is it so?

#include <GUIConstants.au3>

Global $msg, $button
GUICreate("My GUI") 
$button = GUICtrlCreateButton("Button",100,100)
GUICtrlSetOnEvent(-1, "Button")
GUISetState ()      

While 1
    Sleep(10)
Wend
Func Button()

RUN(@ComSpec & " /c start " & "C:\test.xls")

Send("^g")
WinWait("Go To")
Send("B3{ENTER}")

EndFUnc

<{POST_SNAPBACK}>

RUN(@ComSpec & " /c start " & "C:\test.xls") should work if C:\test.xls is really the path to the file.

Try RUN("---your path to excel.exe C:\test.xls")

it is not as portable but might work for your needs

Also, you should not send the ^g to the excel application until it has finished loading and the window is active. Read the help file on WinWait and WinActivate.

[buzz44]

Why put an '&' between the words if you arn't using a variable?

Run(@ComSpec & " /c start C:\test.xls")

and I think it's.

Run('---your path to excel.exe  "C:\test.xls"')

If not then the qoutation marks need to be swapped.

Edited April 23, 2005 by Burrup

[Markir]

Hello, now I have use the following code:

RUN ("C:\Programme\Microsoft Office\OFFICE11\Excel.exe"), but it doesn't work. Excel will not be opened.

[phillip123adams]

RUN ("C:\Programme\Microsoft Office\OFFICE11\Excel.exe"), but it doesn't work. Excel will not be opened.

<{POST_SNAPBACK}>

It needs additional quotes because the path contains a space character. Try this:

RUN ('"C:\Programme\Microsoft Office\OFFICE11\Excel.exe"')

[Markir]

Sorry,

but your code to help me wasn't right, it doesn't start Excel

[phillip123adams]

Sorry,

but your code to help me wasn't right, it doesn't start Excel

<{POST_SNAPBACK}>

What does it do? Do you have the correct path? You can copy the path and filename from an Excel icon and paste it in the Run function.

Here's what runs Excel on my system (I've tested it and it works):

RUN ('"C:\Program Files\Microsoft Office\Office10\EXCEL.EXE"')

[phillip123adams]

#include <GUIConstants.au3>
GUICreate("My GUI") 
$button = GUICtrlCreateButton("Button",100,100)
GUICtrlSetOnEvent(-1, "Button")
GUISetState ()      

While 1
    Sleep(10)
Wend
Func Button()
   RUN ('"C:\Programme\Microsoft Office\Office10\EXCEL.EXE"')
EndFUnc

<{POST_SNAPBACK}>

You did not set GUIOnEventMode. Without it, the event does not fire when the button is clicked.

opt("GUIOnEventMode", 1)

[Markir]

Thank you now it works, it was a simple litlle mistake, in another program I have set this code :-(