Jump to content
Sign in to follow this  
Imbuter2000

found a bug in my Excel files... introduced by _ExcelBookOpen (?)

Recommended Posts

As AutoIt does nothing to the xlsx file I'm sure this can only be an Excel bug.

Can you try on another machine in your company? Maybe reinstalling Excel could solve the problem?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-30 - Version 1.6.2.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

The problem is triggered only when I open the file from AutoIT. If I open it manually it's not triggered.
Therefore the problem could still be anywhere in chain AutoIT - COM - Excel...

In my company it happened on 3 PCs out of 4 where I tried.  On the 4rd PC it happened one time in the past, not now in these tests.

Share this post


Link to post
Share on other sites

If you could open the xlsx file by COM using Visual Basic and the error persists then I dare to say it is a MS bug.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-30 - Version 1.6.2.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

Good idea water.
 

I tried again:
 

VBA (executed inside Excel):

Sub test()
    Workbooks.Open Filename:="c:tempbug-free original copy.xlsx"
End Sub
 

AutoIT:

$oE = ObjCreate("Excel.Application")
$oE.Visible = 1
$oE.WorkBooks.Open("c:tempbug-free original copy.xlsx")
 
VBA doesn't cause the problem.
AutoIT causes the problem  :(

Share this post


Link to post
Share on other sites

Looks like it is time to open a ticket in the BugTracker.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-30 - Version 1.6.2.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

Despite trying a plethora of different methods, I still can not duplicate your problem / error on excel 07 or 2010.

Did make note, though; with normally opening linked workbooks a message appears asking if I want to update links.

If I open linked workbook with   _ExcelBookOpen    it simply updates without asking. This can change or remove named ranges or filters.

Not a duplication of error though.

Studying Excel.au3 provides no clues (to me) to this behaviour.

Not done yet. Too many unanswered questions.

Share this post


Link to post
Share on other sites

Often a fresh install of Office solves such strange "problems" :)


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-30 - Version 1.6.2.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

Often a fresh install of Office solves such strange "problems" :)

The strange thing is that it also happens on 3 PC out of 4 tried in my bank office (where I don't have admin rights and license for reinstalling Office)...

I don't know... may be "Italian" is the only difference between my PCs and yours... 

Share this post


Link to post
Share on other sites

I have no more ideas :-(

Best would be to open a Ticket on the AutoIt BugTracker.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-30 - Version 1.6.2.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

excel options>language settings

&

Windows >regional & language settings

So- both.

It seemed (things are not always as they seem) to be the last variable I had not tried.

My inability to duplicate the problem does not mean it does not occur.

I am unable to duplitate this problem. Perhaps a more qualified person can.

Share this post


Link to post
Share on other sites

excel options>language settings

&

Windows >regional & language settings

So- both.

It seemed (things are not always as they seem) to be the last variable I had not tried.

My inability to duplicate the problem does not mean it does not occur.

I am unable to duplitate this problem. Perhaps a more qualified person can.

What language is your Windows OS? English? Mine is Italian... and this could be the difference...

Regional & language settings don't change the OS language...

Share this post


Link to post
Share on other sites

My OS is english

Though I am quite adventurous;

OS language is one last variable that I am unwilling to deal with.

No $ for the install disc, otherwise I'd give it a go.........

Sorry to bail on you, but I'm bailing on you.

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  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...