excel macro write reserve

[paulcedarhill]

I am a novice programmer trying to write a macro to save a write protected fil. The macro is activiated through a control box, after the file has been opened with read/write priviledge. I get an error saying file is write reserved. Here is tha code for the save, that was recorded through keystrokes in macor record. What am I missing?

ActiveWorkbook.SaveAs Filename:="T:\Production Logs\06 prod log.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="STARS", _
ReadOnlyRecommended:=False, CreateBackup:=False

 

[rmikesmith]

Are you opening the file via code? If so, could you post this. The only way I can trigger the error you report is if the file is saved with a Write Reservation password but opened Read Only prior to running your SaveAs code.


Regards,
Mike

 

[paulcedarhill]

No I am opening it manually with the password necessary for write priveledges. There may be another network user with the file open in read only mode. I just now thought of that but it does not effect the operator generated attempt at saving the file.