I am a newbie to writing macros so any help will be great. I
figured out how to write a macro to open excel from Solidworks. But
I'm having trouble opening a specific file. What I have so far is:
Dim ExcelApp As Excel.Application
Dim swApp As Object
Sub main()
Set ExcelApp = CreateObject("Excel.Application")
ExcelApp.Visible = True
Workbooks.Add
ActiveSheet.DisplayRightToLeft = False
End Sub
Like I said, I'm very new to all this so basically any help would be great! thanks
Dim ExcelApp As Excel.Application
Dim swApp As Object
Sub main()
Set ExcelApp = CreateObject("Excel.Application")
ExcelApp.Visible = True
Workbooks.Add
ActiveSheet.DisplayRightToLeft = False
End Sub
Like I said, I'm very new to all this so basically any help would be great! thanks
Dim ExcelApp As Excel.Application
Dim swApp As Object
Sub main()
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"
End Sub
Now for my next step....