run-time Error problem

**lgross** · 10-29-2018, 03:23 PM

Can anyone help me with a run-time error?

The error reads : run-time error ‘-2147221014(800401ea)’:
Cannot open the specificied file

What I want is to put the program on network for all to use to pull up pdf files
I can open the pdf file on computer no error
When someone else tries to open the hyperlink, this when the error show up.

This is part of the VBA code to open pdf file
ActiveSheet.HyperLinks.Add Anchor:=Selection, Address:= _
"F:\QUALITY\FINAL INSPECTION REPORT\" & a & b, TextToDisplay:= _
"F:\QUALITY\FINAL INSPECTION REPORT\" & a & b
Selection.HyperLinks(1).Follow NewWindow:=False, AddHistory:=True

Thanks

**alansidman** · 10-29-2018, 03:25 PM

Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 6)

run-time Error problem

LinkBack

Thread Tools

Rate This Thread

Display

run-time Error problem

Re: run-time Error problem

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] run time error 481 PROBLEM

[SOLVED] Elapsed time Problem #name error.

[SOLVED] Correcting a Run-time error ‘445’ problem

Problem with run time error 91 in macro

run time error 91 problem

Problem Run-time error '1004'

Run-time error 9 Problem

Bookmarks

Bookmarks

Posting Permissions