View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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.



ranebow wrote:

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

--
ranebow
------------------------------------------------------------------------
ranebow's Profile: http://www.excelforum.com/member.php...o&userid=23730
View this thread: http://www.excelforum.com/showthread...hreadid=374030


--

Dave Peterson