handofthrawn

_ExcelBookAttach trying to re-open excel file that is already open

4 posts in this topic

I have an excel sheet open and I'm trying to use _ExcelBookAttach.  However, sometimes when I use the script it tries to open up the file again.  Its giving the same action as if I double clicked the icon to open up the file and get that popup about it being locked for editing by the User.  I have this excel file start with my computer since I need it for work.  However, the weird thing is that when I shut it down and re-open it and try the script again it works.  It attaches fine and I'm able to read cells.

Does anyone know what could be causing this type of action?  Is there a way to insert code to see the error or action it performed and why?

Below is my test script I used where I still got the error.  Thanks for any help.

#include <Misc.au3>
#include <Excel.au3>
#include <GUIConstants.au3>
#include <GUIConstantsEx.au3>
#include <WindowsConstants.au3>
#include <GUIListView.au3>


Local $oExcel = _ExcelBookAttach(@DesktopDir & "\Morning IND.xls") ; Path to excel file that is on the desktop
Exit

 

Share this post


Link to post
Share on other sites



And using this code and the file is open you get the file opened again ?

Share this post


Link to post
Share on other sites

Seems you are using an old version of AutoIt (3.3.8.1). The Excel UDF has been rewritten since. Maybe upgrading to 3.3.12.0 (most stable version in my opinion) is an option?


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

Water I bet you are right.  I will try that and if I still have issues I will reply back.

 

Thanks for the help!

 

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