Open an existing Excel spreadsheet with a command button

[Clarinet]

This is probably the easiest question of the day, but I cannot fine a way to open an existing Excel spreadsheet with the click of a command button.

Any help would be greatly appreciated!

 

[Remou]

Use the wizard to create the command button. One of the options is Application, which includes Excel.

 

[Clarinet]

Hello Remou,

Thank you for reminding me of the wizard for creating a command button.

I added the line in red to the wizard's code to open the specific spreadsheet that I wanted to view/print.

Dim oApp As Object

Set oApp = CreateObject("Excel.Application")
[COLOR=red]oApp.Workbooks.Open FileName[/color]
oApp.Visible = True
oApp.UserControl = True

 

[Remou]

Sorry, I misread your post. You can also use FollowHyperlink to open a file with its registered application:

FollowHyperlink Filename

 

[Clarinet]

Yes! FollowHyperlink is exactly what I needed - a simple way to open an existing spreadsheet. (Don't even need CreateObject).

Thank you Remou.