link to pdf (1 Viewer)

[kitty77]

I have a form with a button that links to a pdf. It works fine...

Application.FollowHyperlink "\\customers\invoices\" & [Minvoiceno] & ".pdf"

However, I would like to have a msgbox come up if the pdf does not exist.

Not sure how to approach this...

Thanks.

 

[Gasman]

See if this helps, it will work for Access as well.

VBA Check if File or Folder Exists - Automate Excel

VBA allows you to check if a file or folder exists by using the Dir function. Using the Dir Command to Check If a File Exists As we mentioned in the introduction, the Dir function allows us to check if a selected file exists on the computer. Here is the code: Sub CheckFileExists () Dim strFileName…

www.automateexcel.com

 

[kitty77]

Actually, the way I'm using it now is it opens the pdf if it is there. And if it's not I get an error.
So, I want it to open the pdf if there and give me a message if its not.

 

[GinaWhipp]

@kitty77 That is the link Doc Man posted. It will check if the file is there or not and give you a message if it's not.