Jim,

Welcome to the board!

Have you looked at the following Macro for Kix?

quote:

@HOMESHR Server and share name part of home directory

So.. If we take your code we can just simply change it around to be..

code:

USE J: @HOMESHR ; connect to user's home share

HTH,

- Kent

_________________________
Utilize these resources:
UDFs (Full List)
KiXtart FAQ & How to's