Try opening a file from a folder without permission

[crasy]

Hello,

At my work i cannot open specific folders, but when i have the full url i can open the file (if i manually put that in my file explorer and i go there).
But if i try with VBA to open the file with the full url, it gets the error that the file isn't there.

What do i try to do:
I want excel to open files so that i dont have to open them manualy.

For example:
When i try opening C:\Program Files\Avaya\IC71\bin\qui.exe trough VBA with code i get the error "The file isn't there". When i go there manualy (copy/paste the full url) i can open the file. If i go manually to "C:\Program Files\Avaya\IC71\bin" i get the error that i don't have permission.

The code i use is:
Private Sub CommandButton2_Click()
Dim sFullPathToExecutable As String
sFullPathToExecutable = "C:\Program Files\Avaya\IC71\bin\qui.exe"
Shell sFullPathToExecutable
End Sub

Any help would be appriciated, since im stuck.

[john55]

try this

Please Login or Register  to view this content.

[crasy]

thanks for your reply John.

I tried the code but it doesn't work. It gives me the error "cannot open C:\Program Files\Avaya\IC71\bin\qui.exe"

[john55]

.......sorry!

[crasy]

hehe, no problem i appriciate the effort!

If anyone knows somethings to make it work, please let me know.

[john55]

did you see it?
https://social.msdn.microsoft.com/Fo...b?forum=isvvba