hyperlink using part of file name

G

gymphil

Can anyone assist?
I am using a hyperlink in vba to open an external pdf file. I want to be
able to have as part of the link, part of the file name
Application.FollowHyperlink "\\drawingofficeintranet\zz publication
order" & Me.Publication_Number & "*" & ".pdf".
I have tried using the wildcard as the pdf's that I am attempting to open
have large file names that include the 'publication_number' that is on the
form and in the database table.
Thank you
 
G

gymphil

Thank you for the quick response.

My trouble is that the remainder of the file name on the database does not
match the full pdf file name that I am trying to link to. The only thing that
is common is the first 6 characters.

Is there another way to achieve this without having ensure the two match
perfectly?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PDF opens then immediately minimizes 3
Hyperlink Coding (2000 vs. 2003) 1
Outlook How to create hyperlink with specific page of the pdf attachment in Outlook 2
find and display files 21
How to create a hyperlink to open a file with part of the name 4
access hyperlink using data from record on form 2
Hyperlink Image 3
Print hyperlink when saving to PDF. 1

Top