from VBA open text file in default text editor application
Thanks bunches, Tom.
That does indeed do the trick.
Now that I've got that working instead of having to use Notepad, I've
found that I need to put a Wait call right after it to keep from
executing too quickly a statement that deletes the text file that is
being opened (a Kill statement). The text file being opened is a
temporary file for the user to view. Two seconds seems to be enough
time for the application to launch and load the file. Perhaps this is
necessary because of differences between VBA's Shell command and the
API's ShellExecute.
Anyway, it works now.
Cheers,
Brian
|