ERROR with datawindow1.SaveAs("C:\db\mydb.xls",EXCEL5!,True)

[randall2nd]

I am new to PB,using PB 7.0 Build 5031, connecting to a sybase db.
I am getting a return code of -1 when i try to use the SaveAsType EXCEL5!

datawindow1.SaveAs("C:\db\mydb.xls",EXCEL5!,True)

It works just fine when I use:

datawindow1.SaveAs("C:\db\mydb.xls",EXCEL!,True)

But this creates an excel file with a version of 2.1, that it is too low for what i need.

Does the SaveAsType EXCEL5! not work?
Any help appreciated. Randall2nd

 

[randall2nd]

Found the problem.
I had Power builder version 7.0, in which EXCEL5! does not work.

Sybase released some updates to fix bugs.
version 7.0.3 is the one that fixed the EXCEL5! errors. Randall2nd