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

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

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

Password = XYZ

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

Hi,

Try this

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

Mike

"fishy" wrote:

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

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

Password = XYZ