Jump to content

Recommended Posts

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 by Champak
Link to post
Share on other sites
  • Champak changed the title to Unable to overwrite excel file

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 - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to post
Share on other sites

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...