_ExcelBookClose w/ Excel 2010 and Win7 64bit

[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?

[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?

[eldis]

Okay, I came up with this..

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

[water]

But that's the hard way.

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

[eldis]

Office 32 bit

[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.

[eldis]

sorry lil late on post

Edited June 25, 2012 by eldis

[eldis]

32 bit

[eldis]

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

[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?

[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.

[water]

Glad you got your problem solved

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.