Error when run as a admin, Error on a line of code that does not exist (Error: Variable must be of type "Object") - (Moved)

[Garcia]

Hello everyone, my problem is that when I try to run my already compiled program as administrator I get this error, but when I run the script it works correctly.

this is my code

#include <MsgBoxConstants.au3> 
#include <Excel.au3>

;I use this code to not open a new excel file
Global $sWorkbook = @ScriptDir & "\facturacion.xlsx"
Global $oWorkbook = _Excel_BookAttach($sWorkbook)

;this line of code is the problem
$num = $oWorkBook.ActiveSheet.Range("C2").value

MsgBox(0,0, $num)

;this line of code is the problem
$num = $oWorkBook.ActiveSheet.Range("C2").value
 

Is there another way to obtain the data from a cell in an Excel file?

Thanks for your time 😊

[Danp2]

It's likely due to a rights issue. You should add some error checking after the _Excel_BookAttach attempt.

[Jos]

Moved to the appropriate forum.

Moderation Team

[Nine]

Agree with Dan, try open instead of attach, should solve your issue.

[rudi]

Hello,

when you run the program "as-administrator", it's in a different security context. (UAC elevated)

 

If you must attach, because you need that particular workbook opened in Excel, then start Excel UAC elevated as well.