hendrixharrison
Technical User
Here is an access vba code it works on access but generates an error upon closing the excel file.
--------------------------------
Dim oApp As Object
Set oApp = CreateObject("Excel.Application")
oApp.workbooks.Open ("C:My documents\report_template.xls")
oApp.Visible = True
'oApp.ppxl.Visible = True
On Error Resume Next
oApp.UserControl = True
----------------------------------
The code here opens the particular workbook report_template.xls which contains a cognos powerplay addin for excel.
The error occurs as when xls file is closed because suddenly it could not see the pplx code that is supposed to be attach to it.
so what should I code on the createobject(" ")
I tried calling it cognospowerplayforexcel.application,
cognospplx.application etc. -- all do not open the application.
so what is the right extention to this object on vba then?
--------------------------------
Dim oApp As Object
Set oApp = CreateObject("Excel.Application")
oApp.workbooks.Open ("C:My documents\report_template.xls")
oApp.Visible = True
'oApp.ppxl.Visible = True
On Error Resume Next
oApp.UserControl = True
----------------------------------
The code here opens the particular workbook report_template.xls which contains a cognos powerplay addin for excel.
The error occurs as when xls file is closed because suddenly it could not see the pplx code that is supposed to be attach to it.
so what should I code on the createobject(" ")
I tried calling it cognospowerplayforexcel.application,
cognospplx.application etc. -- all do not open the application.
so what is the right extention to this object on vba then?