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

Look at VBA's help for more info.

VJ wrote:

Hi,

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

Thanks and regards,

--

Dave Peterson