opening files in excel with a macro that contains passwords

[1229]

I don't know a lot about macros. I have used the macro recorder to create my macro to open 11 files that I use everyday. The problem is these 11 files contain passwords and the macro will not automatically open these files. It prompts me to enter my password for each file it opens.

Is there a way to have the macro open the file and automatically enter the read-able and write-able password?

 

[MichaelRed]

There was a thread on this issue within the last few months. Results was a VERY good 'Macro' to open the file(s) with the password and path set dynamically. Use the 'search' function, not quite sure of the exact key words, but try Open, Excel, and path.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over