Command Button to open excel file

[Sheila.deJesus]

Is this possible? A command button when click will open an excel file...

Cheers!
Sheila

 

[Road_Warrior]

Dim objExcel As Object
Dim strFile As String

strFile = "C:\MyFile.xls"
Set objExcel = GetObject(strFile)
objExcel.Application.Visible = True
objExcel.Windows(1).Visible = True

 

[Sheila.deJesus]

Hi road warrior! Thanks for the code. Forgive a novice... where shall i put this code?

Thanks a million!
Sheila

 

[Sheila.deJesus]

Also, it this also applicable when opening an HTML document using command button?

Thanks again.

Have a nice day!
Sheila

 

[Road_Warrior]

Just put it on the click event of a button. As for HTML never done that, perhaps someone else can help.

 

[Joe8915]

have you tried TransferSpreadsheet in the macro event?