Opening Word Files 3

[demax182]

Hi,

In my form, I have a field which specifies the path of a specific file (PDF, Excel, or Word File). I'm trying to create a command button that when you click on it, it opens that specific file in the field. Is anything like that possible? Thanks in advance for your help.

Mike

 

[Aqif]

Hi,

If you just want to open the file than use

Dim strPath As String

strPath = Me.TxtFilePath '(The path should be complete)

Application.FollowHyperlink strPath, , True, False

Give it a go n see what happens.

Cheers!
ÙÇãá

It's important to learn the rules so that you know how to break them.

 

[demax182]

Aqif,

Works like a charm! Thanks a bunch!

Mike

 

[randy700]

Aqif,
Thanks. Your reply helps to simplify some code I've been using to do the same thing.


Randy

 

[Aqif]

Hi,

Thanks for the Star Guys Happy to help

Cheers!
ÙÇãá

It's important to learn the rules so that you know how to break them.