| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open password workbook not working
I am using this code
Workbooks.Open Filename:="I:\Aging\Month End\CMT Monthly Aging 07.xls", Password:="atervse" But I am still prompted for the password. I want the file to open with write rights without being prompted. Where am I going wrong? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open password workbook not working
Are you providing the correct password?
Also note that there are two types of password arguments: Password Optional Variant. A string that contains the password required to open a protected workbook. If this argument is omitted and the workbook requires a password, the user is prompted for the password. WriteResPassword Optional Variant. A string that contains the password required to write to a write-reserved workbook. If this argument is omitted and the workbook requires a password, the user will be prompted for the password. -- Regards, Tom Ogilvy "Aaron" wrote: I am using this code Workbooks.Open Filename:="I:\Aging\Month End\CMT Monthly Aging 07.xls", Password:="atervse" But I am still prompted for the password. I want the file to open with write rights without being prompted. Where am I going wrong? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open password workbook not working
try this
Workbooks.Open Filename:="I:\Aging\Month End\CMT Monthly Aging 07.xls", _ Password:="atervse", WriteResPassword:="atervse" -- Gary "Aaron" wrote in message ... I am using this code Workbooks.Open Filename:="I:\Aging\Month End\CMT Monthly Aging 07.xls", Password:="atervse" But I am still prompted for the password. I want the file to open with write rights without being prompted. Where am I going wrong? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open password workbook not working
Perfect!
Can we get a brief explanation why this works when passiing both password arguments at the same time? :beer: "Gary Keramidas" wrote: try this Workbooks.Open Filename:="I:\Aging\Month End\CMT Monthly Aging 07.xls", _ Password:="atervse", WriteResPassword:="atervse" -- Gary "Aaron" wrote in message ... I am using this code Workbooks.Open Filename:="I:\Aging\Month End\CMT Monthly Aging 07.xls", Password:="atervse" But I am still prompted for the password. I want the file to open with write rights without being prompted. Where am I going wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Password to open workbook | Excel Discussion (Misc queries) | |||
| Excel workbook password - not working | Excel Discussion (Misc queries) | |||
| Password not working on exported Workbook / Worksheet. | Excel Programming | |||
| my password quit working in an excel workbook, help! | Excel Worksheet Functions | |||
| Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming | |||
Hybrid Mode
