Open Password Protected Excel Workbook with VBA from Word 1

[ACH381]

Using a VBA command, how do I open an Excel Workbook, that requires a password to open?

I am creating an automated mailmerge project using VBA in Word. I'm using an Excel Workbook as the datasource, but the workbook requires a password to open. I either need to be able to send the password in the "OpenDataSource" method OR open the Excel Workbook, save a copy without a password so mailmerge can access it, run the mailmerge, then delete the copy.

 

[rmikesmith]

The following will open the password-protected workbook:

Workbooks(NameOfWorkbook).Open Password:="Your Password"

Use the SaveAs method of the Workbook object to save a copy without password protection.


Regards,
Mike