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

Hi Brian;

You could do a couple of things.

(1) Don't use a different workbook but rather use a
seperate worksheet and then hide the sheet. You can then
protect the workbook structure so the sheet cannot be
changed to visible and when you need to unprotect the
workbook with your code. If you code is locked that would
prevent other folks from accessing the SS #s but still be
able to use the programatically.

(2) You could store the SS#s in a database and then access
them becase the db would always be in a central location.

In either case the source information has to be
centralized.

Thanks,

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

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

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

Plan:
I would like to be able to place the socials in a
seperate workbook and
tell the macro where to find them, thus providing better
security for
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 the
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/

.

GJones,

Hi, thanks, for your help.

I can't use the lock-out method. The file will be e-mailed on a
unsecure network.

How would I go about the Database method? Do you mean to use Access?
Is this a feature of Excel

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