Commnd Button Wizard

[macamarr]

Hello,
I import an excel file and when I insert a command button I can set up to open my choice of applications. So I was wondering if it is possible when I open excel with the command button to have it point to the excel file I want to open or have it open the target file? Thanks!

 

[Ziggy]

I haven't done it often but you can do it a few different ways.

1. You can go into the properties of the button and under "Hyperlink Address search for your file.

2. Create a Macro using the "RunApp" Action using the following syntax:

"C:\Program Files\Microsoft Office\Office\Excel.exe" "C:\Documents and Settings\My Documents\YourExcelFile.xls"

The 1st set of quotations should be standard but the second set depends on the path to your file.

Once the Macro is created you can either go into the wizard and select "Run Macro" and choose the Macro, or in the On click event property you can choose the macro.

3. Use visual basic:

This example is the same as # 2 but converted to VB, There are other ways with VB I just can't find my notes on this subject right now.


Function Autoopen()
On Error GoTo Autoopen_Err

Call Shell("""C:\Program Files\Microsoft Office\Office\Excel.exe"" ""C:\Documents and Settings\My Documents\YourFile.xls""", 1)


Autoopen_Exit:
Exit Function

Autoopen_Err:
MsgBox Error$
Resume Autoopen_Exit

End Function



Ziggy

 

[macamarr]

Thanks, I endedupusing the hyperlink. I might give a go to the VB versoin.