Open External File

[Scott Whetsell, A.S. - WVSP]

I would like to be able to have the user click a button on the form which
will open a file in a specified directory which matches criteria on the
selected record. The target file will probably be a pdf file. I'm not
looking to import any data from the target file, just open it for review.

Thanks.

 

[Albert D. Kallal]

"Scott Whetsell, A.S. - WVSP"

I would like to be able to have the user click a button on the form which
will open a file in a specified directory which matches criteria on the
selected record. The target file will probably be a pdf file. I'm not
looking to import any data from the target file, just open it for review.

You can go:

application.FollowHyperlink "c:\path name.txt"

Any legal file extension will work (the above would open a text file, but it
works equal excel, word, or a pdfs file...

 

[Scott Whetsell, A.S. - WVSP]

Very simple fix, yet very effective. Thanks!!

"Scott Whetsell, A.S. - WVSP"


You can go:

application.FollowHyperlink "c:\path name.txt"

Any legal file extension will work (the above would open a text file, but it
works equal excel, word, or a pdfs file...