| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP: Update a password protected workbook and save it as unprotec
Hi All,
I have a protected workbook which is updated through a userform and then saved at a different location, I have everything working but one thing.. When I save it again at a different location I want it to be unprotected, Here is the piece of code I have to do that, but the workbook is still protected. please help! Set wbk = Workbooks.Open("C:\Documents\My_Sheet.xlsm", False, False, , "password") FPath = "C:\Documents\My_Sheet\" & "New_Sheet" & "-" & ".xlsm" 'Code to populate the worksheet goes here With wbk ..Unprotect "password" ..SaveAs FPath ..Close True End With |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HELP: Update a password protected workbook and save it as unprotec
wbk.protect
is like doing Tools|Protection|protect workbook (in xl2003 menus). Try with wbk .password = "" .... sam wrote: Hi All, I have a protected workbook which is updated through a userform and then saved at a different location, I have everything working but one thing.. When I save it again at a different location I want it to be unprotected, Here is the piece of code I have to do that, but the workbook is still protected. please help! Set wbk = Workbooks.Open("C:\Documents\My_Sheet.xlsm", False, False, , "password") FPath = "C:\Documents\My_Sheet\" & "New_Sheet" & "-" & ".xlsm" 'Code to populate the worksheet goes here With wbk .Unprotect "password" .SaveAs FPath .Close True End With -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HELP: Update a password protected workbook and save it as unprotec
sam,
see if this helps ..SaveAs Filename:=FPath, _ FileFormat:=xlNormal, _ Password:="", _ WriteResPassword:="", _ ReadOnlyRecommended:=False, _ CreateBackup:=False -- jb "sam" wrote: Hi All, I have a protected workbook which is updated through a userform and then saved at a different location, I have everything working but one thing.. When I save it again at a different location I want it to be unprotected, Here is the piece of code I have to do that, but the workbook is still protected. please help! Set wbk = Workbooks.Open("C:\Documents\My_Sheet.xlsm", False, False, , "password") FPath = "C:\Documents\My_Sheet\" & "New_Sheet" & "-" & ".xlsm" 'Code to populate the worksheet goes here With wbk .Unprotect "password" .SaveAs FPath .Close True End With |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I save a password protected .xlsm file containing old macro | Excel Programming | |||
| update links to password protected workbooks. | Excel Discussion (Misc queries) | |||
| How do I save a password protected Excel doc in order to open? | Excel Discussion (Misc queries) | |||
| bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
| Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming | |||
Hybrid Mode
