Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2007
i have a script for saving a file to 2 locations, 1st location saves in
excell2007 macro enabled, 2nd location saves in excel2003 compatable version, i have put a WriteResPassword on 2003 version so its read only... the trouble i have is when i run the script again it cant save to the 2nd location as is protected... script is below any ideas how to solve the issue so it will save over the password with out falling over Application.DisplayAlerts = False ChDir "O:\Distribution\Loadplan\1delsch" ActiveWorkbook.SaveAs Filename:= _ "O:\Distribution\Loadplan\1delsch\delsch.xlsm" , FileFormat:= _ xlOpenXMLWorkbookMacroEnabled, ReadOnlyRecommended:=False, CreateBackup:=False Application.DisplayAlerts = True ChDir "P:\Distribution\Schedule\Bracknell" Application.DisplayAlerts = False ActiveWorkbook.SaveAs Filename:= _ "P:\Distribution\Schedule\Bracknell\Newdelsch.xls" , FileFormat:=xlExcel8, _ Password:="", WriteResPassword:="260959", ReadOnlyRecommended:=False, _ CreateBackup:=False Application.DisplayAlerts = True ActiveWindow.Close |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 | Excel Discussion (Misc queries) | |||
In Excel 2007 is there a way... | New Users to Excel | |||
Problems with my links to an excel 2007 file from a word 2007 file | Links and Linking in Excel | |||
excel 2007 | Excel Discussion (Misc queries) | |||
Office 2007 Pro Plus 2007 (Beta) - getting small red and green arr | Excel Discussion (Misc queries) |