Read Only


VBA for Excel and COM-handles

Hi,

I’m trying to launch a VBA for Excel from our Progress application, and I’m encountering a problem when I’m testing for access privileges. Essentially, I’m checking the read-only property for the workbook and alert the user if it’s true. Here’s a portion of the code:

DEF VAR chFileName AS CHAR INIT "N:\TestRegion2\testvba.xls" NO-UNDO.

DEF VAR chExcel AS com-handle no-undo.
DEF VAR chWorkbook AS com-handle no-undo.
DEF VAR chExcelApplication AS com-handle no-undo.
DEF VAR chWorksheet AS com-handle no-undo.


Syndicate content