Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write-Reserve problem...
I'm trying to overwrite a template file so that some things are change
and others are not. The template loads, values are entered, then whe you press a userform command button, the file is saved as a .xls the the cell contents are removed, then the file should be saved as template, overwriting the template that is there (so some value remain). I have it doing everything it's supposed to but it keep saying that the template is write-reserved, but it shouldn't be, ho can I change this so that it works? Heres a piece of the code tha seems to be causing the snag, but I think the problem is really wit the template, I can manually do a save as, but I want this to b programmatic. Code ------------------- Worksheets("Quote").Range("Q9").ClearContents sPath = "C:\SyntheticShield\" ActiveWorkbook.SaveAs Filename:=sPath & "SyntheticShieldQuoteMaker.xlt", FileFormat:=xlTemplate ActiveWorkbook.Close Fals ------------------- -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write-Reserve problem...
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write-Reserve problem...
I believe Write-Reserved refers to the file being password protected s
that if it is opened without supplying the password, it is read onl (reserved from writing). If you have a password set on the file, tr adding this parameter when calling the SaveAs method... WriteResPassword:= *yourpassword* -Gitcyphe -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel template to calculate capital reserve funding %?? | Excel Discussion (Misc queries) | |||
How do I reserve a document | Excel Worksheet Functions | |||
attendance based pay for Army reserve | Excel Worksheet Functions | |||
Problem with a UDF im trying to write | Excel Worksheet Functions | |||
How do I set up a equipment replacement reserve schedule | Excel Worksheet Functions |