Jump to content

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


Imbuter2000
 Share

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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
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.

Link to comment
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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
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  :(
Link to comment
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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
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.

Link to comment
Share on other sites

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

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
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... 

Link to comment
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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
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.

Link to comment
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...

Link to comment
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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...