Build a link to another program? (modify a text file)

[paindivine]

I have a database that I plan to use to help us manage an old "Remedy" system....
There is a field for "Ticket number"
I want to be able to click a button and have this ticket open in Remedy.

Remedy DOES have a link system. When I creat a link it creates a file like this:

Ticketnumber.ARTask

The contents of the file are simple:

[Shortcut]
Name = NTRS-Trouble
Type = 0
Server = samson
Join = 0
Ticket = NTRS422904

The name of the file seems to be irrelevent.
How can I programatically get the button to re-write the ticketnumber into that file, in that spot (after the letters "NTRS") and then have it open the link? I figure I can keep 1 file in the working directory and just re-write that same file over and over again... I just don't know enough about VB or macros to figure it out.

 

[KeithG]

You will need to use the FSO (File Syetem Object) to open the file and rewrite the data. I believe the object you want to use is called a TextStream but am not positive because I don't have a version of Access at home.

 

[paindivine]

You will need to use the FSO (File Syetem Object) to open the file and rewrite the data. I believe the object you want to use is called a TextStream but am not positive because I don't have a version of Access at home.

Hmm... This looks promising, but I dont really know how to implament it.