I try to figure out who is using a excel workbook which I can only open "read only". I use this code:
#include <Array.au3> #include <Excel.au3> Local $sFile = ; excel file with path on a network drive Local $oExcel = _Excel_Open(True, True) Local $oTabelle = _Excel_BookOpen($oExcel, $sFile) Local $aUsers If IsObj($oTabelle) Then $aUsers = $oTabelle.UserStatus _ArrayDisplay($aUsers) EndIf If I am the one allowed to write to the excel file (I'm the first one who opened it) then I will get an array with myself:
If my collegue opened the excel file first and I run the code I get the following error message:
"H:\_Conrad lokal\Downloads\AutoIt3\_COX\Tests\test.au3" (9) : ==> The requested action with this object has failed.: $aUsers = $oTabelle.UserStatus $aUsers = $oTabelle^ ERROR The excel file is on a network drive. Is that's the problem?
Is there anyway that AutoIT is able to pull the Windows username and password from the computer in use. This is for a program I am going to try and create that will unlock the computer when their information is entered into the appropriate fields. Any answers are much appreciated!