Activate Notepad and View .txt Document

[ProjectExplorer]

I am using code which exports data as a text file. Creating the text file is fine but does anyone know how to activate Notepad using code and view the document?

Any help appreciated.

Many thanks.

 

[JohnLowell]

I use:

Application.FollowHyperlink strLocation, , True

where strLocation is a string variable with the full path name for any file, not just .txt files.

 

[RoyVidar]

Hi!

I use the shell function:

[tt]shell "notepad.exe " & strPathAndName, vbNormalFocus[/tt]

Should it error, use full path also to Notepad.exe

HTH Roy-Vidar

 

[ProjectExplorer]

Many thanks for your replies.