Jump to content
Sign in to follow this  
redpicker

#AutoIt3Wrapper_UseX64=n doesn't work (ExcelBookClose problem)

Recommended Posts

redpicker

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

Share this post


Link to post
Share on other sites
Juvigy

Does this work for closing:

$oExcel.Application.DisplayAlerts = False

$oExcel.Application.WorkBooks.Close

$oExcel.Application.DisplayAlerts = True

$oExcel.Application.Quit

$oExcel.Quit

Share this post


Link to post
Share on other sites
water

I think the problems have been solved with the latest AutoIt beta.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
redpicker

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.

Share this post


Link to post
Share on other sites
redpicker

OK, I'll try the new beta version and see if that fixes it.

Thanks,

Share this post


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
Sign in to follow this  

×