In Excel2000, I have 6 or 7 files that I use to run reports thru a
macro in another application. The problem is that each month my
password changes in this other application and I need to change the
code in each of the files. For example, I have the following code in
these files...

Application.SendKeys "bob49", True


bob49 is my password to start this other application. Is there a way to
have "bob49" be a variable that references a central location so I only
have to change the password once snd not in each of the Excel files?

Thanks