opening text file

[skate]

I have a form that views one record at a time. I want to create a button that opens a specific text file (eg. word) depending on the current record. I was thinking it would be along the lines of
Shell "C:\Folder1\Folder2\mydoc.doc", vbMaximizedFocus but possibly having a variable for the document name that will be set according to the record's index?

 

[Fornatian]

Application.FollowHyperlink "C:\MyFile.doc"

 

[Oldsoftboss]

This attachment is for an excel spread sheet. Maybe you can adopt the code for word.
HTH
Dave

 

[IMO]

skate,

Is this the sort of thing you are looking for?

IMO

 

[IMO]

97 version

IMO