Open Excel Macro to enter passwords

[hansretallick]

I have a spreadsheet in Excel 2003 which has a number of worksheets which each look up data from separate files in our company web site. Each of the originating spreadsheets is separately password protected, and when the master sheet is opened, it requests passwords in sequence from the originating sheets. Any ideas of a VB code to enter the passwords in turn as they are requested? I am unable to create a macro as the tools menu isn't enabled until the passowrds have been read. A typical cell reference is ='

http://companyweb/General

Documents/Targets/[Targets 101.xls]Sheet1'!B33.

 

[combo]

If you open workbooks with vba, look at Workbooks.Open method 'Password' parameter.

combo

 

[GlennUK]

Please explain "I am unable to create a macro"?!?!? You are asking advice on what code to put in a macro.

In the meantime, assuming you can actually create a macro, you'd have to store the passwords in the macro ( or some other storage place ). Do you have the passwords? Are you happy about them being stored in this way? You would use them in the way that combo suggests ( opening the supporting documents before opening the master ).

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.