Progress/Excel

[raymoose]

I have created a csv file in progress and would like to open excel using the created csv file. I have tried using the commands below and I am not having much luck, any suggestions.

DEF VAR excel AS COM-HANDLE.
DEF VAR workbook AS COM-HANDLE.
DEF VAR worksheet1 AS COM-HANDLE.
DEF VAR worksheet2 AS COM-HANDLE.
DEF VAR range AS COM-HANDLE.

CREATE "Excel.Application" excel.

excel:VISIBLE=FALSE.

excel:workbooks:ADD.
/* excel:Workbooks:Open FileName:="F:\Temp\MRT-GM2.csv". This is the command I can not get to work. */

excel:VISIBLE=TRUE.
RELEASE OBJECT excel NO-ERROR.
RELEASE OBJECT workbook NO-ERROR.
RELEASE OBJECT worksheet1 NO-ERROR.
RELEASE OBJECT worksheet2 NO-ERROR.
RELEASE OBJECT range NO-ERROR.

 

[HelloMike]

raymoose,

Don't bother with

excel:workbooks:ADD.

The correct syntax for opening the file with your set of com-handle variables is:

    ASSIGN workbook = excel:Workbooks:Open("F:\Temp\MRT-GM2.csv").

And to select the worksheet after opening (at least I think so ... please don't shoot me if I'm wrong):

    ASSIGN worksheet1 = excel:Sheets:Item(1).

And finally ... release your com-handles in reverse order.

 

[raymoose]

This worked great. I appreciate your help.