How to display text file in VBA

Clive Beaton
Clive Beaton used Ask the Experts™
I create a log file, LogEvent.txt in my application.  How can I display the file from a command button in the application.

Thanks in advance

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
If you have an application associated with .txt extension (standard application for txt files is notepad), you can use hyperlink:
Application.FollowHyperlink "path to your txt file"
Most Valuable Expert 2015
Distinguished Expert 2018

You can link  it as a table, and then display this in, say, a form in datasheetview.
Clive BeatonAccess Developer


als: Perfect.  Thanks very much.


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial