How to use _Excel_BookOpen with network path?

[AI123]

[UPDATE: PROBLEM SOLVED, WORKS NOW WITHOUT CHANGES]

Hello, I have this code:

;Local $var = "C:\Users\q\Downloads\tshirts\Daten.xlsx" ; lokal auf Rechner
Local $var = "\\fritz.box\FRITZ.NAS\ESD_USB\tshirts\Daten.xlsx" ; über USB-Stick an FritzBOX

Local $oWorkbook = _Excel_BookOpen($oExcel_1,$var)

With the commented local path all worked well.

But with my network path I get this error:

"C:\Program Files (x86)\AutoIt3\Include\Excel.au3" (233) : ==> The requested action with this object has failed.:
Local $oWindow = $oExcel.Windows($oWorkbook.Name)
Local $oWindow = $oExcel.Windows($oWorkbook^ ERROR
->11:59:07 AutoIt3.exe ended.rc:1
+>11:59:07 AutoIt3Wrapper Finished.
>Exit code: 1    Time: 1.772

My OS is Windows 10. If I enter \\fritz.box\FRITZ.NAS\ESD_USB\tshirts\Daten.xlsx in the Windows explorer Excel is opened with this file, so the file path is right.

So why can't I open the file in the network with _Excel_BookOpen? And what have I to do to do it?

Edited May 1, 2021 by AI123

[water]

Which version of AutoIt do you run?

[AI123]

Version 3

[AI123]

After a lot of restarts now it works without changes. I don't know why, but problem seems to be solved.

Edited May 1, 2021 by AI123

[water]

👍

[seadoggie01]

I've seen this before with AutoIt scripts... but not with _Excel_BookOpen. I recently found that you can map a network drive easily and temporarily while your script is running, which seems to solve my issues with network files.

Func DoStuffWithNetworkDrive($sNetworkPath)
    
    ; Map the drive to any drive letter this function then returns the letter
    Local $sDrive = DriveMapAdd($sNetworkPath, "*")
    If @error Then Exit MsgBox(0, "Network Drive", "Failed to map the network drive, check that it's connected")
    
    ; Do your stuff here
    
    DriveMapDelete($sDrive)
    
EndFunc

The other thing to note (and may not be valid for non-http or https paths) is that you should make sure that the network location (the root folder) is in your "Trusted Sites" in internet explorer. (Open IE, click Settings, Internet Options, switch to the Security tab, select Trusted Sites, click Sites button, then finally add the address)