| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Locked/Protected workbook using vba
Hi,
Is there anyway to open a locked or protect workbook through another workbook using VBA macro? Thanks and regards, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open Locked/Protected workbook using vba
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open Locked/Protected workbook using vba
Workbooks.Open filename:=<filename, password:=<password
"VJ" wrote in message ... Hi, Is there anyway to open a locked or protect workbook through another workbook using VBA macro? Thanks and regards, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 1004 Cell Protected Error for data validation lists when locked and protected | Excel Programming | |||
| Open A Locked Workbook | Excel Worksheet Functions | |||
| Open workbook that is protected with password | Excel Programming | |||
| Open password protected workbook. | Excel Programming | |||
| Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming | |||
Hybrid Mode
