redpicker Posted October 10, 2011 Share Posted October 10, 2011 It seems that putting " #AutoIt3Wrapper_UseX64=n" at the start of my scrpits doesn't fix the ExcelBookClose problems. I can open and read Excel files fine, but if I try to close them, they don't close. Furthermore, when I try to open a third Excel workbook, it doesn't even open. I am not a programmer, so a lot of this stuff is over my head. But, I have developed several scripts to evaluate several different excel file data and they worked fine until I was upgraded to a 64-bit machine with windows 7. My prior machine was 32bit and ran XP, if that helps. I would like to get these scripts running agian, I like to run them once a week, but lately, I have had to do the work manually. Thanks for any help or insight anyone can give me. rp Link to comment Share on other sites More sharing options...
Juvigy Posted October 10, 2011 Share Posted October 10, 2011 Does this work for closing: $oExcel.Application.DisplayAlerts = False $oExcel.Application.WorkBooks.Close $oExcel.Application.DisplayAlerts = True $oExcel.Application.Quit $oExcel.Quit Link to comment Share on other sites More sharing options...
water Posted October 10, 2011 Share Posted October 10, 2011 I think the problems have been solved with the latest AutoIt beta. 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...
redpicker Posted October 10, 2011 Author Share Posted October 10, 2011 Yes, that does fine. Do just need to add those five lines when I want to close? Another issue that might be messing things up is that my Excel workbook object variables are not named "$oExcel", but "$oEnginering", "$oAccounting", and "$oProduction". I don't think that would matter, since I replace $oExcel with the appropiate variable. Link to comment Share on other sites More sharing options...
redpicker Posted October 10, 2011 Author Share Posted October 10, 2011 OK, I'll try the new beta version and see if that fixes it. Thanks, 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