-
Open external file as administrator
I have the following script that works fine on XP, but having issues running it in Windows 7. I believe it's because it's not opening the .lab file as an administrator, since I right click .lab file and run as administrator it opens without a problem.
[vba]Sub FetchFile_Click()
On Error GoTo NoFile
strAddress = "C:\Incoming grabber.lab"
ActiveWorkbook.FollowHyperlink Address:=strAddress
Exit Sub
NoFile:
MsgBox "Sorry. File is not available at this time", vbInformation, "Error!"
End Sub
[/vba]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules