OpeningWord

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access2000.

On a form I have a combo box that the user can select a company from the
llist. On update of the combo box I want to open a particular word doc. The
name of the different word docs are FY[year][conbr].doc. Ex. FY20051132.doc.
I set a variable in VB txtFileToGet and populate it, txtFileToGet = "FY" &
cboCo.column(0) & cboCo.column(2) & ".doc". The next line in VB reads
Application.FollowHyperlink "D:\path\txtFileToGet.

Question; Can somone help me with this? I've tried everything I can think
of. Thanks.
 
Hi,
if txtFileToGet holds the true full name of the document and you are
specifying the path to it hardcoded then your followhyperlink statement
should look something like this:

Application.FollowHyperlink "d:\path\" & Me.txtFileToGet

HTH
Good luck
 
Back
Top