First off, I'd like to mention that I have no training at all so I ma
not understand many simple functions, so please bear with me.

Info:
My macro scans a column in sheet "Memo" for dynamic names and compare
them to a list of static names on sheet "Roster". When a match i
found, it takes info from the Roster and places next to the name in th
Memo. So far the script is flawless.

Concern:
The info copied from the Roster is the members social security. Her
is where the problem comes in.

Plan:
I would like to be able to place the socials in a seperate workbook an
tell the macro where to find them, thus providing better security fo
the members social.

Problems:
The workbook changes names and directories.

What I've tried:
To 'GetDir' of current workbook location, and the current name of th
workbook. Extensive testing of the '.open', and 'load' commands.

Any help would be greatly appreciated - I've been stumped for ages.
Thank you, for your time and consideration in this matter

--
Message posted from http://www.ExcelForum.com