Opening an Excel file from a macro

[ScubaStevo]

Hi

How can I open an excel file from a macro? Or even in VBA will be fine.

Thanks

Steve

 

[ZmrAbdulla]

see thread692-90756 will get some idea

________________________________________________________________________
Zameer Abdulla
Visit Me
No two children are alike - particularly if one is yours and the other isn't.

 

[edsuk]

Hi

Private Sub btnExcel_Click()

Dim fso As Object
Dim strFile As String

Set fso = CreateObject("Scripting.FileSystemObject")

strFile = "C:\FileNameWithFullPath.xls"

If (fso.FileExists(strFile)) Then
Call Shell("excel.exe C:FileNameWithFullPath.xls", vbNormalFocus)
Exit Sub
Else
MsgBox "Excel File Specified In Path not Found.", vbInformation, "Open Excel File"
End If

End Sub

Mark...

[Worm]