Accessing workbook info from a different workbook macro

[Brian Bowman]

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

 

[GJones]

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

 

[Brian Bowman]

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