How do I open a Publisher file from Access 2010?

[RichStone]

I have a single document provided by a client that I wish to open by pressing a button. What is the easiest way to do this?

I already have strings called PubPath with the path to the publisher document
and PubDoc with the document name.

 

[cyanidem]

Application.FollowHyperlink Pubpath & "\" & PubDoc

 

[RichStone]

Thanks for your reply. This appears to work fine for opening the document but always brings up a window stating there may be security issues and asking me to click OK to continue anyway. Is there any way to stop it displaying this?

 

[cyanidem]

I never managed to get rid of those warnings completely, there's many solutions but only some of them work. Try to google "access suppress followhyperlink warning" or something similar.