| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing password from another file
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing a password protected excel file | Setting up and Configuration of Excel | |||
| PASSWORD REMOVAL I have the password to open the file and the password to modify the file now how to remove them | Excel Programming | |||
| how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
| Referencing password protected Workbook | Excel Programming | |||
| Referencing password protected worksheets | Excel Programming | |||
Threaded Mode
