Open a NotePad

[kenrav]

I'd like to open a specific NotePad file (c:\help.txt) from a command button
using VBA. What code should I use? Thanks.

 

[Banana]

I'd like to open a specific NotePad file (c:\help.txt) from a command button
using VBA. What code should I use? Thanks.

You could use something like Shell command:

Shell("C:\help.txt")

This will open Notepad, if the .txt is associated with Notepad. If this
is not the case then you may need to open the Notepad.exe directly.
Maybe this:

Shell("Notepad.exe C:\help.txt")

But...if this is a help file for your application you're designing in
Access, why not use Control Tip & other built-in properties for
displaying help?

 

[Daniel Pineault]

Application.FollowHyperlink "c:\help.txt"
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.