hyperlink using part of file name

  • Thread starter Thread starter gymphil
  • Start date Start date
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
 
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?
 
Back
Top