in reply to Suppressing password prompting of an excel file.

According to the MSDN Documentation, you can pass the password as a parameter to the open:

Password (Optional)
Variant A string that contains the password required to open a protected workbook.
If this argument is omitted and the workbook requires a password, the user is prompted for the password.

     ..to maintain is to slowly feel your soul, sanity and sentience ebb away as you become one with the Evil.

  • Comment on Re: Suppressing password prompting of an excel file.

In Section Seekers of Perl Wisdom