I have the follwing code that opens up an Excel Template i have two errors with it
Private Sub Command3_Click()
'Open, and make visible the Excel Template (Request.xlt)
Set objXL = GetObject("J:\DATA\ESTIMATI\Chedley\Quotation Files\ACCESS 97 TEST Static.xlt")
objXL.Application.Visible = True
objXL.Parent.Windows(1).Visible = True
End Sub
There are two errors with the code
1) The template wizard will not open with the document
2) The program window freezes and i get an application error telling me that the applciation can not read the memory location.
Do i have a problem with the code?
Private Sub Command3_Click()
'Open, and make visible the Excel Template (Request.xlt)
Set objXL = GetObject("J:\DATA\ESTIMATI\Chedley\Quotation Files\ACCESS 97 TEST Static.xlt")
objXL.Application.Visible = True
objXL.Parent.Windows(1).Visible = True
End Sub
There are two errors with the code
1) The template wizard will not open with the document
2) The program window freezes and i get an application error telling me that the applciation can not read the memory location.
Do i have a problem with the code?
