We help IT Professionals succeed at work.

How to display text file in VBA

Clive Beaton
Clive Beaton asked
on
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

CRB
Comment
Watch Question

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

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

Author

Commented:
als: Perfect.  Thanks very much.

CRB