Welcome! Log In Create A New Profile

Advanced

Converting .xls to xlsx

Posted by Frans 
Converting .xls to xlsx
September 11, 2020 11:38AM
Hello to you all,

I have a problem with converting .xls to .xlsx.
Opening Excel and opening the document works fine. Saving is the problem.
Here is a part off the code:

MyExcelObject>>workbooks>>Open("c:test.xls") //works fine

MyExcelObject>>workbook>>SaveAs("c:test.xlsx",51) //gives an error


It says: Access to workbook Automation member:
Error 80020006 Nom Inconnu.

What could be wrong?

Thanks in advance,
Regards Frans
Re: Converting .xls to xlsx
September 11, 2020 12:44PM
Dear Frans,

Try with this:
MyExcelObject>>ActiveWorkbook>>SaveAs("c:test.xlsx",51)

Regards

Vassilis Boutsikas
Solved Re: Converting .xls to xlsx
September 11, 2020 02:19PM
Hello Vassilis,

That did the job.
Thanks !

Regards Frans
Author:

Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: