Sign in to follow this  
Followers 0
eldis

_ExcelBookClose w/ Excel 2010 and Win7 64bit

12 posts in this topic

_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



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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - 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

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

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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - 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

Office 32 bit

Share this post


Link to post
Share on other sites

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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - 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

#7 ·  Posted (edited)

sorry lil late on post

Edited by eldis

Share this post


Link to post
Share on other sites

32 bit

Share this post


Link to post
Share on other sites

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

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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - 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

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

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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - 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  
Followers 0