CODEWITHSUNDEEP
excelvbscript
T Doe
T Doe

Reputation: 81

VBscript Can't Find Excel File

I am attempting to use VBscript to open an excel file. However, when I run the script, it says the file cannot be located. I am pretty certain I have the file path correct. Is it possible that something else is causing my code to fail?

Set objExcel = CreateObject("Excel.Application")

objExcel.Visible = True

Set objWorkbook = 
objExcel.Workbooks.Open("C:\Users\Guest\Documents\Projects\1A.xlsx")

Set objExcel = Nothing
Set objWorkbook = Nothing

Upvotes: 1

Views: 2250

Answers (2)

user692942
user692942

Reputation: 16672

As mentioned in the comments

In 9 out of 10 cases, this is permission related

The likeihood is (if you have already confirmed the file path is correct) that the VBScript does not have the permission required to access the file path, but due to the way elevation works along with UAC on most Windows Operating Systems means that VBScript doesn't know about the path, so it isn't reported as a access permission error.

As the path in question refers to a User Profile path the chances of it being permissions related increases.

To fix the problem the host process running the VBScript (wscript.exe or cscript.exe) needs to be run using elevated privileges. You can do this by opening an elevated command prompt (Run as Administrator context menu option) and specifying the host process followed by the script path.

Something like;

cscript.exe "yourscript.vbs"

Upvotes: 2

Spangen
Spangen

Reputation: 4720

From a windows command prompt type

c:\ dir C:\Users\Guest\Documents\Projects\1A.xlsx

The file could have been saved with a different file extension, or if explorer is hiding extensions and a user has provided the extension on save it might be called 1A.xlsx.xslx

Windows explorer might be hiding data. If you can see it in explorer, right click the file > properties > details.

The Name attribute should tell you exactly what the file is named on disk and the Folder path should give you the path.

You can combine the two to give the full path to the file on disk

Upvotes: 1

Related Questions