This content has been marked as final. Show 2 replies
I figured this out, If anyone is interested, the code is as follows:
Dim ExcelApp As Excel.Application
Dim swApp As Object
Set ExcelApp = CreateObject("Excel.Application")
ExcelApp.Visible = True
ChDir "Z:\New inspection form"
Workbooks.Open FileName:= _
"Z:\New inspection form\New Inspection form-test1.xls"
Now for my next step....
Just wanted to thank you for the update. I was trying to do the exact same thing.