Error on oSheet1:SaveAs(cFILE_NAME)

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

brunellopulix
Posts: 80
Joined: Sat Apr 24, 2010 10:17 am

Re: Error on oSheet1:SaveAs(cFILE_NAME)

Post by brunellopulix »

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
User avatar
serge_girard
Posts: 3308
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: Error on oSheet1:SaveAs(cFILE_NAME)

Post by serge_girard »

Thanks Brunello !

I will take a look at it.

Serge
There's nothing you can do that can't be done...
barua.hmg
Posts: 1
Joined: Thu Jun 19, 2014 7:52 am

Re: Error on oSheet1:SaveAs(cFILE_NAME)

Post by barua.hmg »

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
Post Reply