_Excel_BookOpen issue - (Moved)

[aaronhunter]

Hi all

Here is my code.It open the excel file what I want, but before the excel been opened,a msgbox show up with code "0".How to avoid the msgbox ??

$Openit = OpenExcel()

func OpenExcel()

Local $FilePath = "\\192.168.2.78\!Excel\123.xlsm"

Local $oExcel = _Excel_Open()

_Excel_BookOpen($oExcel, $FilePath)
EndFunc

 

 

[water]

Check your script and the Excel UDF for a MsgBox statement. 

[aaronhunter]

HI Water

Maybe the UDF  have some problem. I don't know....

I write it to another program, the msgbox problem is fixed. It doesn't show up anymore.

thx~~

[water]

I checked the Excel UDF - I couldn't find  a MsgBox statement.
Which version of AutoIt do you run?

[aaronhunter]

Hi Water

I run Autoit with version 3.5.4.

[Jos]

That is the SciTE version, not the AutoIt3 version!

[Danp2]

Isn't it possible that the message box is coming from Excel since he's opening a macro enabled spreadsheet?

[Nine]

It could be but the blue surrounding suggests it comes from AutoIt not VB.  To make sure, @aaronhunter press Alt-F11 in the excel sheet, if you see a macro there, remove it.  Otherwise, there must be some code you did not post (maybe some personal #include ?).

Edited May 27, 2020 by Nine

[aaronhunter]

Hi all

As @Danp2 said : Isn't it possible that the message box is coming from Excel.

I write those code in a TEST script witch means it also include a lot of others. 

I check the hole script and I found the reason of msgbox show up .

As the picture you can see,I miss  comment out the code "MsgBox(0, "", @Error)"

I'm so sorry and thank for all you kind of assistant.

[Melba23]

Moved to the appropriate forum, as the Developer General Discussion forum very clearly states:

Quote

General development and scripting discussions.

---

Do not create AutoIt-related topics here, use the AutoIt General Help and Support or AutoIt Technical Discussion forums.

Moderation Team