ouestque
asked on
Excel VBA: Confirm user has access to network file
What VBA code would I use to confirm the following without opening another file:
1) User can access path on network.
2) User has at least Read access to a file on a network?
3) Sheet exists within a workbook on a network.
Network Path = //HelloWorld/Import/Closed /File/Clos edFile.xls
1) User can access path on network.
2) User has at least Read access to a file on a network?
3) Sheet exists within a workbook on a network.
Network Path = //HelloWorld/Import/Closed
ASKER
Makes sense Bill. What VBA would I use to check for at least Read access to a file and file path?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Really Cool Bill! Thank you!!
Welcome, glad that was helpful.
»bp
»bp
»bp