Open Locked/Protected workbook using vba

[VJ]

Hi,

Is there anyway to open a locked or protect workbook through another
workbook using VBA macro?

Thanks and regards,

 

[Dave Peterson]

You could provide the password in the workbooks.open statement. Do you know it?

Look at VBA's help for more info.

 

[JLGWhiz]

Workbooks.Open filename:=<filename>, password:=<password>