 | I'm using PowerBuilder 9.0 and I want to run MACRO in Excel 2000.
Something is wrong and I don't know what? Can you help me?
CODE:
-------------------------------------------------------------------------------
OLEObject iOLEExcel
iOLEExcel = CREATE OLEObject
iOLEExcel.ConnectToNewObject("excel.application")
iOLEExcel.Visible = TRUE
iOLEExcel.Workbooks.Open("C:\TEST.xls")
iOLEExcel.ActiveWorkbook.Worksheets[1].Activate
iOLEExcel.Application.Run("PERSONAL.XLS!Macro1") //ERROR
iOLEExcel.Application.Quit
iOLEExcel.DisConnectObject()
Destroy iOLEExcel
-------------------------------------------------------------------------------
|
|
