[solved] Object type returned by Excel UDF + Thiswookbook trap

[Myicq]

I am developing some excel export code.

A small part is outputting some constants not in the excel UDF.

I can find the constant using VBA editor from Excel. But my question is basically (since it did not work in AutoIT):

In terms of VBA code, which object type is $oExcel in this code:

Local $oExcel = _ExcelBookOpen(@ScriptDir & "\" & "tstfile.xlsx", 1)

I tried to do this:

; VBA CODE which works
Sub s()
MsgBox Application.ThisWorkbook.FullName
End Sub

personally I think $oExcel is an application object, so this should work:

ConsoleWrite("From Excel file : " & $oExcel.ThisWorkbook.FullName & @CRLF)

.. but it does not.

What am I missing here ? Normally I know my way in and out of VBA etc.

Edited November 1, 2012 by Myicq

[Myicq]

Update:

This is a real trap.

ThisWorkbook is for the workbook where the macro code is running. Since AutoIT is technically not running inside a workbook, it fails.

ActiveWorkbook the the visible workbook.

So, changing code to

"From Excel file : " & $oExcel.ActiveWorkbook.FullName & @CRLF

Will leave thread for others to learn.

And found that $oExcel IS an Application object, in VBA sense.

[water]

Correct. The object returned by _ExcelBookOpen is an application object.

Try

$oExcel.ActiveWorkbook.FullName

to get the full name of the workbook.

BTW: I'm just about to completely rewrite the that comes with AutoIt. The new UDF will get rid of all limitations the current version has.

In your case you will get the object of the opened workbook not the application.

Please have a look and tell me what you think.