ComradVlad Posted March 25, 2014 Posted March 25, 2014 Basically what happens the program opens an excel document and does various tasks, saving the document on certain events. However _ExcelBookSave returns 1 even if it fails to save. For example I closed the excel document and triggered a save event and the messegebox said 1. The reason im using a $saveTest instead of @error is i thought maybe that was causing the issue for whatver reason, but obviously it isnt. Any ideas? func _save () local $saveTest = _ExcelBookSave($DBFile) msgbox(0,"TEST",$saveTest) if $saveTest = 0 then msgbox(4096,"ERROR","Failed to save database file, you should probably call ????") endif endfunc
water Posted March 25, 2014 Posted March 25, 2014 Do you save the workbook as XLS or XLSX? My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.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 (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
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