Champak Posted June 13, 2022 Share Posted June 13, 2022 (edited) Is there a way to test in autoit if an excel file is currently read only?...or simply tell me why this isn't working? My app opens an excel file and reads it to an array, I then call excel_close. Later in another function I try to save to that file I originally open and I use different variables if it matters like: _Excel_Close($oExcel) ; Create application object Local $oExcel2 = _Excel_Open() If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookOpen Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended) ; Create a new workbook with only 2 worksheets ;$oWorkbook = _Excel_BookNew($oExcel, 2) $oWorkbook2 = _Excel_BookOpen($oExcel2, $rExportPath) If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookNew Example 1", "Error creating new workbook." & @CRLF & "@error = " & @error & ", @extended = " & @extended) _Excel_RangeWrite ( $oWorkbook2, $oWorkbook2.Activesheet, $aRet) $oWorkbook2.Worksheets(1).Name = "Products" $oWorkbook2.Worksheets(2).Name = "Barcode Printer" ; Local $sWorkbook = @DesktopDir & "\_Excel1.xlsx" _Excel_BookSaveAs($oWorkbook2, $rExportPath, Default, True) I even called the excel close again just for the sake of it before this save function. I've checked task manager to make sure there is no other excel running, and I checked the attribute and it is not readonly. This simply wont save if the excel file already exists. I expect if it's read/write it should overwrite an existing file. Am I incorrect in assuming that? The help file didn't specifically say an existing file cannot be overwritten. Edited June 13, 2022 by Champak Link to comment Share on other sites More sharing options...
water Posted June 13, 2022 Share Posted June 13, 2022 What’s the value of @error and @extended after saving the workbook? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Champak Posted June 13, 2022 Author Share Posted June 13, 2022 4, unable to delete the file. Link to comment Share on other sites More sharing options...
dmob Posted June 16, 2022 Share Posted June 16, 2022 Try adding a Sleep before save? Link to comment Share on other sites More sharing options...
Champak Posted June 16, 2022 Author Share Posted June 16, 2022 @dmobNo sleep doesn't help anything. @water I missed the @extended part, that is 0. 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