Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Dim XLAPP As Excel.Application
Set XLAPP = CreateObject("Excel.Application")
With XLAPP
'.Visible = True 'When you debug, sometimes it helps to see what is going on
.Workbooks.Open FileName:= _
strFilePath
[red].Run ExcelMacro, optional_parameter_1, optional_parameter_2 ... [/red]
.ActiveWorkbook.Close (True) 'Close and save workbook
.Quit
End With
Set XLAPP = Nothing