Linked table connection

[zz12]

I'm trying to execute a sql2k stored procedure through code but am trying to
avoid hard coding the connection string in a module and was wondering if it
was possible to use the user's successfully logged in sql account linked
table connection info as the connection string?

Thanks in advance.