ComradVlad Posted March 25, 2014 Share 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 Link to comment Share on other sites More sharing options...
water Posted March 25, 2014 Share Posted March 25, 2014 Do you save the workbook as XLS or XLSX? 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...
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