HMGforum.com

Posted: **Mon Nov 02, 2015 3:19 pm**

Hello

oExcel := CreateObject( "Excel.Application" )
oExcel:WorkBooks:Add()
oExcel:Visible := .F.
oExcel:AlertBeforeOverwriting := .F.
*
oExcel:ActiveWorkBook:SaveAs(cNameXlsx)
or
oExcel:ActiveWorkBook:SaveAs(cNameXls,56)
*
oExcel:Quit()

Greetings
brunello pulix

Posted: **Mon Nov 02, 2015 3:23 pm**

Thanks Brunello !

I will take a look at it.

Serge

Posted: **Fri Jan 15, 2021 6:17 am**

ERROR 2147352567

I have encountered this error today & found it was data error. Text started with "=" eliminated it with code & problem is solved

Hope it will be beneficial to others!!!

Regards
Sudipto Barua

HMGforum.com

Error on oSheet1:SaveAs(cFILE_NAME)

Re: Error on oSheet1:SaveAs(cFILE_NAME)

Re: Error on oSheet1:SaveAs(cFILE_NAME)

Re: Error on oSheet1:SaveAs(cFILE_NAME)