com


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.


.Net and Progress Gui

I'm not sure this is even possible but figured I'd throw it out there, it's at least good for an eye roll and muttered "WTF?"...

We have a legacy application, heavily based upon adm2. The idea is being explored to redo the UI, and instead of doing the entire app at once, the goal is to impliment pieces at a time. The solution that is being explored is to embed a web browser in the application, write the new functionality in Asp.net with ajax and utilize the embedded browser to view the page, essentially "overriding" the former functionality.


Syndicate content