You can find out how to make a URL that opens to a specific location in
Excel by opening two workbooks, then recording a macro while you Insert a
hyperlink in one of the workbooks and direct it to a specific location in
the other excel workbook. Then turn off the recorder.

You can then modify this to include a path to the file. The rest sounds
like Access programming of which I have no knowledge.

--
Regards,
Tom Ogilvy

"Jim" wrote in message
...
THe URL is a FIELD in Access. I would like it to "activate" the CompanyID
in
Excel as a Hyperlink.

THanks!