S
spoefi
Form within Word, I open an excel-workbook, paste data in it, save th
workbook as "c:\..." and then i want to close the workbooks en Qui
excel.
The problem is that excel keeps on turning in the background and tha
it is not possible to open my excel-workbook by doubleclicking on it
It gives an error.
--------
Private xlApp As Object
Private xlWB As Object
Private mySheet As Object
Set xlApp = CreateObject("Excel.Application")
Set xlWB = xlApp.Workbooks.Ope
"c:\projects\asus\Ycomm.bestellingimportACZ.xls")
Set mySheet = xlWB.Sheets(1)
(...I put data in this templatesheet, which i save then in the pat
'strSaveAs')
xlWB.SaveAs strSaveAs
xlWB.Close False
Set xlWB = Nothing
xlApp.Application.Quit ' close the Excel application
Set xlApp = Nothing
workbook as "c:\..." and then i want to close the workbooks en Qui
excel.
The problem is that excel keeps on turning in the background and tha
it is not possible to open my excel-workbook by doubleclicking on it
It gives an error.
--------
Private xlApp As Object
Private xlWB As Object
Private mySheet As Object
Set xlApp = CreateObject("Excel.Application")
Set xlWB = xlApp.Workbooks.Ope
"c:\projects\asus\Ycomm.bestellingimportACZ.xls")
Set mySheet = xlWB.Sheets(1)
(...I put data in this templatesheet, which i save then in the pat
'strSaveAs')
xlWB.SaveAs strSaveAs
xlWB.Close False
Set xlWB = Nothing
xlApp.Application.Quit ' close the Excel application
Set xlApp = Nothing