| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel macro to open a password protected workbook | Excel Discussion (Misc queries) | |||
| Open Workbook Macro??? | Excel Discussion (Misc queries) | |||
| need to open my workbook not asking for password so i can do so | Excel Discussion (Misc queries) | |||
| Excel Macro to open password protected workbooks? | Excel Discussion (Misc queries) | |||
| Macro Password to open or access | Excel Worksheet Functions | |||
Linear Mode
