MJOAP Posted October 1, 2009 Share Posted October 1, 2009 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. Link to comment Share on other sites More sharing options...
Juvigy Posted October 1, 2009 Share Posted October 1, 2009 (edited) 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 Link to comment Share on other sites More sharing options...
MJOAP Posted October 11, 2009 Author Share Posted October 11, 2009 Thanks a million for the help. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now