Jump to content

Recommended Posts

Posted

I want to use _Excel_BookSaveAs with the path "\\10.0.4.191\AutoShare\New.xls" but Itnot work. 

_Excel_BookSaveAs ( $oWorkbook, "\\10.0.4.191\AutoShare\New.xls")

How to solved it!
Thanks all.

Posted

@langthang084 : read the remarks section in the help page :

Starting with Excel 2007 you have to provide both the $iFormat parameter and the correct file extension in $sFilePath.
E.g. $iFormat = $xlExcel8 and extension = "xlsx" will return an error.
Please see the XlFileFormat enumeration in ExcelConstants.au3 for possible values.

Try to change the $iFormat parameter ($xlExcel8 seems to be what you need)

Posted (edited)

I run on my laptop (dont save on LAN) it work normally, but on my computer at company, the excel has error in Unicode text and the sheet has been renamed (to Recovered_Sheet....)

Edited by langthang084

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...