Open a workbook with a password via macro - How to?

F

fishy

Can anyone advise how I can open the following workbook via a macro:

Workbooks.Open Filename:= "\\server_route\tbl_processes.xls"

Password = XYZ
 
M

Mike H

Hi,

Try this

Sub stantial()
Workbooks.Open "c:\mypath\book1.xls", Password:="abc"
End Sub

Mike
 
Top