Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA to call Powerplay for Excel file

Status
Not open for further replies.

hendrixharrison

Technical User
Mar 15, 2005
16
0
0
CA
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top