_ExcelBookSaveAs and the xlsx file extension

[MJOAP]

Hi Everyone,

I am trying to find out if the following is working yet with xlsx extensions.

I have tried and have had no joy.

_ExcelBookSaveAs($oExcel, @DesktopDir & "\Test3", "xls", 0, 1)

Thanks a lot.

Michael.

[Juvigy]

Try this line instead of your line :

$oExcel.Application.ActiveWorkBook.SaveAs("C:\Your file.xlsx",51,"","",False,False)

edit:

You have office 2007 right?

Edited October 1, 2009 by Juvigy

[MJOAP]

Thanks a million for the help.