Msg: RE: executable XyWrite hyperlink in Excel?

Avran

Just click Start / Run and type in CMD then click OK.

This will open a DOS box.

Then just enter the commands as Robert detailed below.

Modify the D:\PATH to reflect where your EDITOR.EXE is located.

BTW. Thanks Robert. Very useful info.

Cheers

Marc

From: owner-xywrite@xxxxxxxx [mailto:owner-xywrite@xxxxxxxx] On Behalf Of sacksa@xxxxxxxx
Sent: Saturday, 21 August 2004 5:48 a.m.
To: xywrite@xxxxxxxx
Cc: Robert Holmgren
Subject: Re: executable XyWrite hyperlink in Excel?

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
-----------------------------