Jump to content
Sign in to follow this  
eldis

_ExcelBookClose w/ Excel 2010 and Win7 64bit

Recommended Posts

eldis

_ExcelBookClose w/ Excel 2010 and Win7 64bit is not working for me, even with the sample scripts. Is there a work around for this?

Share this post


Link to post
Share on other sites
water

Welcome to AutoIt and the forum!

We need more information! Is Office 32 or 64 bit installed?

"Is not working" doesn't help us to help you. Do ou get any error messages, return code?


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
eldis

Okay, I came up with this..

_ExcelBookSave to save and WinClose("Microsoft Excel") .. easy enough.

Share this post


Link to post
Share on other sites
water

But that's the hard way.

There are already some threads on the forum dealing with this problem.


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
eldis

Office 32 bit

Share this post


Link to post
Share on other sites
water

Do you run/compile your AutoIt scripts for 32 or 64 bit? If 64 bit then change to 32 because COM for Office 32 bit needs 32 bit applications.


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
eldis

sorry lil late on post

Edited by eldis

Share this post


Link to post
Share on other sites
eldis

32 bit

Share this post


Link to post
Share on other sites
eldis

I don't understand how my solution is the hard way. Can you explain why it is?

Share this post


Link to post
Share on other sites
water

Because you first use COM to communicate with Excel and then you kill the process by closing the window. I wouldn't do that.

One of the threads I was referring to is one - when I had the same problem 1 1/2 years ago.

Maybe one solves your problem. There is a bug in the Excel UDF by not releasing the object.

BTW: Which version of AutoIt do you run?


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
eldis

I use AutoIT 3.3.6.1 and your thread you started with the same problem, solved mine. Thank you. I found that I was compiling in x64(64bit) and needed to compile it in x86(32bit). Just like you tried to tell me earlier. Guess I needed to be told twice.

Share this post


Link to post
Share on other sites
water

Glad you got your problem solved :D

Version 3.3.6.1 of AutoIt is quite old. I would recommend to update to the latest version (3.3.8.1) after reading the script breaking changes section of the history.


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

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  

×