I created a form to filter and write the results (tab separated) to a text in the C:\Temp folder. After the macro runs, I am opening the text file, and if required, I am cutting and pasting them in an Excel file. I opted for a text file because it is simpler to write the code.
Now I want the macro to open the text file from the C:\Temp folder at the end of the macro. I searched the internet for an answer but mostly they deal with opening, writing, reading or appending data to a text file.
I just want to open the text file for display on the screen.
Do we have anything like Application. OpenFile ... routine to display the file contents on the screen. Yes, the Access will open another application, in this case Notepad, but that should not be a big problem.
I am using Access 2007.
I'd appreciate any suggestion.