Open and dispaly test file

[PC]

Hi

Could somebody point me to some code that I could use to open a text file in
notepad and display the contents. Basically I'm exporting data from some
table to a text file and would like for the use to see the results of the
export in the text file

Thanks

...pc

 

[Wayne Morgan]

Shell "Notepad.exe <path>\Mytextfile.txt", vbNormalFocus

This will work on an NT computer, because notepad is in the search path. On
a Win9x computer, you may need to specify the path to notepad.

 

[PC]

Thanks Wayne. That worked a treat

Shell "Notepad.exe <path>\Mytextfile.txt", vbNormalFocus

This will work on an NT computer, because notepad is in the search path. On
a Win9x computer, you may need to specify the path to notepad.