Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data from password protected files
I have 50 password-protected workbooks (time sheets) and a control file. Each
employee has his own file with unique password, supervisor is the only one who can access control file and enter information that is compared to data from individual time sheets and flags any errors. The problem I have is when I open control file, it tries to access individual time sheets to get data, and since every time sheet file is password protected, I have to enter 50 passwords. Is there any way around this? Note: every time sheet must be password protected - privacy concerns. Any help on this would be greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
data from password protected files
Since you state that the control files begins to access the time sheets, I assume you have a macro set up that initiates the action. Add a code snippet to the macro that automatically provides the password to access the file, and make sure to close the file once the information is retrieved/reconciled. "0o0o0o0o" wrote: I have 50 password-protected workbooks (time sheets) and a control file. Each employee has his own file with unique password, supervisor is the only one who can access control file and enter information that is compared to data from individual time sheets and flags any errors. The problem I have is when I open control file, it tries to access individual time sheets to get data, and since every time sheet file is password protected, I have to enter 50 passwords. Is there any way around this? Note: every time sheet must be password protected - privacy concerns. Any help on this would be greatly appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
data from password protected files
Thanks for answering. I don't have a macro written to pull data from data
sheets, it's just a cell reference from time sheets, and then data is compared to values from control file. How would macro for passwords look like, and is there any way to have those passwords stored in one of the worksheets within control file so it's easy to lookup and change. Person accessing control file doesn't know much about Excel. Thanks again "JLGWhiz" wrote: Since you state that the control files begins to access the time sheets, I assume you have a macro set up that initiates the action. Add a code snippet to the macro that automatically provides the password to access the file, and make sure to close the file once the information is retrieved/reconciled. "0o0o0o0o" wrote: I have 50 password-protected workbooks (time sheets) and a control file. Each employee has his own file with unique password, supervisor is the only one who can access control file and enter information that is compared to data from individual time sheets and flags any errors. The problem I have is when I open control file, it tries to access individual time sheets to get data, and since every time sheet file is password protected, I have to enter 50 passwords. Is there any way around this? Note: every time sheet must be password protected - privacy concerns. Any help on this would be greatly appreciated. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
data from password protected files
In tools=Options=Edit tab, make sure "Ask to update automatic links" is
checked. This is an Application level setting In the workbook itself, if you are using Excel 2002 or later then under edit=Links, click the startup button at the bottom and make the appropriate selection. -- Regards, Tom Ogilvy "0o0o0o0o" wrote in message ... Thanks for answering. I don't have a macro written to pull data from data sheets, it's just a cell reference from time sheets, and then data is compared to values from control file. How would macro for passwords look like, and is there any way to have those passwords stored in one of the worksheets within control file so it's easy to lookup and change. Person accessing control file doesn't know much about Excel. Thanks again "JLGWhiz" wrote: Since you state that the control files begins to access the time sheets, I assume you have a macro set up that initiates the action. Add a code snippet to the macro that automatically provides the password to access the file, and make sure to close the file once the information is retrieved/reconciled. "0o0o0o0o" wrote: I have 50 password-protected workbooks (time sheets) and a control file. Each employee has his own file with unique password, supervisor is the only one who can access control file and enter information that is compared to data from individual time sheets and flags any errors. The problem I have is when I open control file, it tries to access individual time sheets to get data, and since every time sheet file is password protected, I have to enter 50 passwords. Is there any way around this? Note: every time sheet must be password protected - privacy concerns. Any help on this would be greatly appreciated. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
data from password protected files
Tom
I have a similar situation that links to 50 password protected files, but the summary file always asks for the password. do you have a sample macro for the summary file to update the summary file from the 50 protected files. It would be greatly appreciated. I have the tools set up the way you suggest and the update link startup set correctly. -- Steve D "Tom Ogilvy" wrote: In tools=Options=Edit tab, make sure "Ask to update automatic links" is checked. This is an Application level setting In the workbook itself, if you are using Excel 2002 or later then under edit=Links, click the startup button at the bottom and make the appropriate selection. -- Regards, Tom Ogilvy "0o0o0o0o" wrote in message ... Thanks for answering. I don't have a macro written to pull data from data sheets, it's just a cell reference from time sheets, and then data is compared to values from control file. How would macro for passwords look like, and is there any way to have those passwords stored in one of the worksheets within control file so it's easy to lookup and change. Person accessing control file doesn't know much about Excel. Thanks again "JLGWhiz" wrote: Since you state that the control files begins to access the time sheets, I assume you have a macro set up that initiates the action. Add a code snippet to the macro that automatically provides the password to access the file, and make sure to close the file once the information is retrieved/reconciled. "0o0o0o0o" wrote: I have 50 password-protected workbooks (time sheets) and a control file. Each employee has his own file with unique password, supervisor is the only one who can access control file and enter information that is compared to data from individual time sheets and flags any errors. The problem I have is when I open control file, it tries to access individual time sheets to get data, and since every time sheet file is password protected, I have to enter 50 passwords. Is there any way around this? Note: every time sheet must be password protected - privacy concerns. Any help on this would be greatly appreciated. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
data from password protected files
Steve,
I've been trying to find a solution to this problem on some other Excel related web sites, but no luck. Just hoping that someone will be able to answer this. Let me know please if you find the answer somewhere else, I will do the same. "Steve D" wrote: Tom I have a similar situation that links to 50 password protected files, but the summary file always asks for the password. do you have a sample macro for the summary file to update the summary file from the 50 protected files. It would be greatly appreciated. I have the tools set up the way you suggest and the update link startup set correctly. -- Steve D "Tom Ogilvy" wrote: In tools=Options=Edit tab, make sure "Ask to update automatic links" is checked. This is an Application level setting In the workbook itself, if you are using Excel 2002 or later then under edit=Links, click the startup button at the bottom and make the appropriate selection. -- Regards, Tom Ogilvy "0o0o0o0o" wrote in message ... Thanks for answering. I don't have a macro written to pull data from data sheets, it's just a cell reference from time sheets, and then data is compared to values from control file. How would macro for passwords look like, and is there any way to have those passwords stored in one of the worksheets within control file so it's easy to lookup and change. Person accessing control file doesn't know much about Excel. Thanks again "JLGWhiz" wrote: Since you state that the control files begins to access the time sheets, I assume you have a macro set up that initiates the action. Add a code snippet to the macro that automatically provides the password to access the file, and make sure to close the file once the information is retrieved/reconciled. "0o0o0o0o" wrote: I have 50 password-protected workbooks (time sheets) and a control file. Each employee has his own file with unique password, supervisor is the only one who can access control file and enter information that is compared to data from individual time sheets and flags any errors. The problem I have is when I open control file, it tries to access individual time sheets to get data, and since every time sheet file is password protected, I have to enter 50 passwords. Is there any way around this? Note: every time sheet must be password protected - privacy concerns. Any help on this would be greatly appreciated. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
data from password protected files
Will do.
-- Steve D "0o0o0o0o" wrote: Steve, I've been trying to find a solution to this problem on some other Excel related web sites, but no luck. Just hoping that someone will be able to answer this. Let me know please if you find the answer somewhere else, I will do the same. "Steve D" wrote: Tom I have a similar situation that links to 50 password protected files, but the summary file always asks for the password. do you have a sample macro for the summary file to update the summary file from the 50 protected files. It would be greatly appreciated. I have the tools set up the way you suggest and the update link startup set correctly. -- Steve D "Tom Ogilvy" wrote: In tools=Options=Edit tab, make sure "Ask to update automatic links" is checked. This is an Application level setting In the workbook itself, if you are using Excel 2002 or later then under edit=Links, click the startup button at the bottom and make the appropriate selection. -- Regards, Tom Ogilvy "0o0o0o0o" wrote in message ... Thanks for answering. I don't have a macro written to pull data from data sheets, it's just a cell reference from time sheets, and then data is compared to values from control file. How would macro for passwords look like, and is there any way to have those passwords stored in one of the worksheets within control file so it's easy to lookup and change. Person accessing control file doesn't know much about Excel. Thanks again "JLGWhiz" wrote: Since you state that the control files begins to access the time sheets, I assume you have a macro set up that initiates the action. Add a code snippet to the macro that automatically provides the password to access the file, and make sure to close the file once the information is retrieved/reconciled. "0o0o0o0o" wrote: I have 50 password-protected workbooks (time sheets) and a control file. Each employee has his own file with unique password, supervisor is the only one who can access control file and enter information that is compared to data from individual time sheets and flags any errors. The problem I have is when I open control file, it tries to access individual time sheets to get data, and since every time sheet file is password protected, I have to enter 50 passwords. Is there any way around this? Note: every time sheet must be password protected - privacy concerns. Any help on this would be greatly appreciated. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
data from password protected files
You can do this with a workbook_open event in the control file. Since there
are links to all 50 in the control file, "Ask to update automatic links" is off, it will want to open all 50 workbooks. I believe Mr. Ogilvy gave you the best answer: In tools=Options=Edit tab, make sure "Ask to update automatic links" is checked. Since this is a control file, I presume you are opening it to make changes. When you open it with Mr. Ogilvy's method, it temporarily stops updating the links. Make the changes to the control file, save, and close the control file. When the users open their workbooks, the links will refresh in their workbooks. So why bother opening all 50 files. Regards, Alan "0o0o0o0o" wrote in message ... I have 50 password-protected workbooks (time sheets) and a control file. Each employee has his own file with unique password, supervisor is the only one who can access control file and enter information that is compared to data from individual time sheets and flags any errors. The problem I have is when I open control file, it tries to access individual time sheets to get data, and since every time sheet file is password protected, I have to enter 50 passwords. Is there any way around this? Note: every time sheet must be password protected - privacy concerns. Any help on this would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password Protected Files | Excel Discussion (Misc queries) | |||
Password Protected Files | Excel Discussion (Misc queries) | |||
Using Password-protected files for a report | Excel Discussion (Misc queries) | |||
Opening password protected files | Excel Programming | |||
Password protected files | Excel Discussion (Misc queries) |