Progress 4GL - need to select Excel worksheet by name

Question

Through a Progress 4GL program, I am trying to select a specific worksheet in the workbook. The worksheet name I am trying to select is called "Budget". Any ideas on how I can select this by name. Provide sample code snippet.

score 0 · Accepted Answer · answered Jul 16 '13 at 19:43

0

I haven't tried it but this should work:

CREATE "Excel.Application" chExcelApplication.

chWorkSheet = chExcelApplication:Sheets("SheetName")

answered Jul 16 '13 at 19:43

mhu

17,720
10
62
93

Progress 4GL - need to select Excel worksheet by name

1 Answers1