Hyperlink to TXT file

[ranebow]

I have a TXT file that is created from another software program. I'
like to create a hyperlink to that TXT file in Excel. When I click o
the hyperlink I'd like the TXT file to open with Excel, not the defaul
Notepad. Is this possible to do

 

[Dave Peterson]

You might be able to fiddle with your file associations--but I wouldn't do that.

There's too much variability in the layout of text files to have them all open
in excel (how would you open them--fixed width or delimited--and based on what.

I think I'd record a macro that opened that .txt file, parsed it correctly and
even added headers/filters/print setup stuff.

Then I'd assign that recorded macro to the button.

 

[Dave Peterson]

Oooh. And I'd put a nice button from the Forms toolbar near that filename so
that the macro would work!