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

  • Thread starter Thread starter fishy
  • Start date Start date
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
 
Hi,

Try this

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Date format/value different when opening manually compare to VBA macro 4
Excel macro to open a password protected workbook 9
Macro to open, Update links, save and close workbooks 0
Using filename retrieved from GetOpenFilename 1
Excell 2000 macro will not open file! 1
Excel VBA open with Password 4
Saving a workbook with a makro 2

Back
Top