Got it working. Turned out my DCOM configuration needed some changing! Thanks and have a good day/evening.
Regards Lena From: [email protected] [mailto:[email protected]] On Behalf Of Lena Dammstrom Sent: Wednesday, December 09, 2015 2:07 PM To: Lena Dammstrom Subject: [RBASE-L] - GATEWAY Export XLSW RBASE 9.5(32) version 9.5.5.21111 Hello all, I am getting an information message Error of data export: Access is denied, ProgID: "Excel.Application" And the spreadsheet is not generated GATEWAY EXPORT XLSW &varrPathFileName + SELECT AccountNumber, `Business Name`, + AmntDue, `Current`, `30+`, `60+`, `90+`, `120+`, `180+`, + `270+`, `360+` + FROM TempARSumDueCurrVw WHERE AccountNumber IN &varrRAWCustList + OPTION COL_NAMES ON + |MESSAGES ON + |SHEET_INDEX '1' + |HEADER_TEXT &vTmp + |TAB_NAME RAW Cust AGE + |SHOW_PROGRESS ON ... another export for Sheet_Index 0 follows If I change this to XLS, it generates a spreadsheet; but of course I do not get multi sheets. It appears this only is happening on my computers, others can run the exact same code and it generates workbook just fine. Any clues to what maybe causing my issue? Thank you in advance Regards Lena
