Re: executable XyWrite hyperlink in Excel?

[sacksa@xxxxxxxx]

Hi, Robert.  Thanks for your response.  



Operating system is NT 2000.   I use as file extensions for all files created in XyWrite one of 3 extensions:  .tf, .als, .rev.    I only use the .rev extension for redline files (rev=revision) prior to use of the "put edits" command.   These files would not ever be placed in the Excel lists that I have.   The .tf and .als extensions are conventions that are used in-house, where I work and cannot be changed.  Under "tools/folder options/file types" in Windows Explorer I had associated the .tf extension with the xy3.bat file.  Although I don't recall exactly what I did.   This is the file that executes when opening XyWrite.  This bat file sets up a special, in-house, character mapping of the keyboard and then directs execution of the xy3.exe file.  



In Excel, I inserted a hyperlink for the cell that had as its only text a file with the .tf extension. Upon clicking on the hyperlink, it opened up XyWrite, but not file itself.  

Since this didn't work, I have since changed everything back to the way it was.



How do you use DOS to make the changes in order to get this to work?



//Avi

Avram Sacks

Chicago, IL











"Robert Holmgren" 

Sent by: owner-xywrite@xxxxxxxx
08/19/2004 05:10 PM

Please respond to xywrite


        

        To:        xywrite@xxxxxxxx

        cc:        

        Subject:        Re: executable XyWrite hyperlink in Excel?





** Reply to message from sacksa@xxxxxxxx on Thu, 19 Aug 2004 16:13:56 -0500





> I am able to get Windows to recognize all files of XyWrite type

> because all of my XyWrite-created files have only one of three possible

> file extensions...

> ... clicking on the hyperlink in Excel or on the XyWrite file in

> Windows Explorer will only open XyWrite.  It will not open the file.  I am

> assuming that because XyWrite requires that files be opened from the

> command line, it is not possible to open the file merely by clicking the

> link in Excel.  Is this correct?



No.  The extension recognition scheme depends upon proper ASSOCiations and

FileTYPEs.  You don't mention your three dedicated XyWrite extensions, nor your

OpSys; I assume some version of NT (4, 2K, XP).  Here's an example, using

extensions ".XY" and ".XYW" (note the replaceable parameter "%1", which is

probably what you're missing):



  ASSOC .xy=XyWrFile

  ASSOC .xyw=XyWrFile

  FTYPE XyWrFile=d:\path\EDITOR.EXE %1



You can manage these ASSOCiations and FTYPEs with My Computer ==> Tools ==>

Folder Options ==> File Types ==> Advanced, but it's a clumsy and dumb

interface -- much easer to do it via two DOS commands as above.



-----------------------------

Robert Holmgren

holmgren@xxxxxxxx

-----------------------------