Open 2nd workbook that has password

I have a workbook open and want to open another workbook that has a password.

I try using the macro recorder, but it doesn't record the password being entered (like MWord does). Is there anyway to have the password already coded.


2nd question....Is there anyway to automatically choose disable macros in the 2nd workbook from code in the first.


thank you for any help



Josh

Hello Josh,

In your code add this line...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Do you know how to code for the code to disable macros?

Hello Josh,

The disable macro dialog is generated by Excel and isn't exposed through VBA. It may be possible using some API calls to catch when the dialog appears and click the appropriate button. I have never tried this, but it does seem possible.

Sincerely,
Leith Ross