Launch file from OLE Field

  • Thread starter Thread starter Sanya Ibrahim
  • Start date Start date
Sanya Ibrahim said:
HI,
Is there any way to open a file I saved in an OLE field of Access 2007
using vba? For example, I saved a word document in the field using methods
as shown in http://support.microsoft.com/default.aspx/kb/210486. Now
instead
of writing the file to disk, I want to open it in word using vba.
Can any one help?
Thanks in advance,
Sanya
Click to expand...

Write the file to disk as usual, then open it using:

Application.FollowHyperlink "C:\Temp\MyFilename.doc"

(substitute your actual path of course)
 
Back
Top