Hi..I am a brand new to Progress and am needing some help involving accessing excel cells and exporting specified cells into a txt file. Any help at all would be monumentally appreciated!! Here is what I have so far.
/*use pro-tools...then use Com Object viewer to find correct syntax
for use with excel.application */
DEFINE VARIABLE ch-excel AS COM-HANDLE NO-UNDO.
DEF VAR chbook AS COM-HANDLE NO-UNDO.
DEF VAR chsheet AS COM-HANDLE NO-UNDO.
DEF VAR chcell AS COM-HANDLE NO-UNDO.
/*start excel application + open a .xls worksheet */
CREATE "excel.application" ch-excel.
ch-excel:VISIBLE = TRUE.
chbook = ch-excel:workbooks:OPEN("c:\temp\accdata1.xls").
PAUSE.
ch-excel:ActiveWindow:Close.
RELEASE OBJECT ch-excel.
Thanks, Trolls35
domers35@hotmail.com
/*use pro-tools...then use Com Object viewer to find correct syntax
for use with excel.application */
DEFINE VARIABLE ch-excel AS COM-HANDLE NO-UNDO.
DEF VAR chbook AS COM-HANDLE NO-UNDO.
DEF VAR chsheet AS COM-HANDLE NO-UNDO.
DEF VAR chcell AS COM-HANDLE NO-UNDO.
/*start excel application + open a .xls worksheet */
CREATE "excel.application" ch-excel.
ch-excel:VISIBLE = TRUE.
chbook = ch-excel:workbooks:OPEN("c:\temp\accdata1.xls").
PAUSE.
ch-excel:ActiveWindow:Close.
RELEASE OBJECT ch-excel.
Thanks, Trolls35
domers35@hotmail.com