OLEDB Failure...

[BatMan22]

Global $sFilename = @ScriptDir & "C:\Users\Username\Desktop\File.xlsx"
Global $sConnectionString = 'Provider=Microsoft.ACE.OLEDB.12.0;Data Source=' & $sFilename & ';Extended Properties="Excel 12.0 Xml;HDR=YES"'

$oConnection.Open($sConnectionString) ; Open the connection

Hi Guys, I'm trying to connect to a CLOSED excel file with the OLEDB libraries and am getting an error when I attempt to open the file, I'm using the example as a reference but it seems like it's original version + this version doesn't work. Does it require admin perhaps (I don't have admin on this PC)? Opening the file doesn't help either.

I get the error below:

"C:\Users\Username\Programming\ExcelReadWorking - Copy.au3" (34) : ==> The requested action with this object has failed.:
$oConnection.Open($sConnectionString)
$oConnection^ ERROR

[BatMan22]

Can someone delete this string.. I didn't see the @scriptdir that needs to be removed. I am dumb.

[argumentum]

10 minutes ago, BatMan22 said:

I am dumb.

HEY !, that's my phrase !  

[argumentum]

33 minutes ago, BatMan22 said:

Properties="Excel 12.0 Xml;

what version of Office is there in the PC ?

[Andreik]

4 minutes ago, argumentum said:

HEY !, that's my phrase !  

Everyone knows that you are trolling us when you say that.

[robertocm]

Some ideas to check:

https://www.autoitscript.com/forum/topic/209361-read-xlsx-with-ado-anomaly/?do=findComment&comment=1511561

https://www.autoitscript.com/forum/topic/209361-read-xlsx-with-ado-anomaly/?do=findComment&comment=1511588