vb code to save a spreadsheet to file
 

I'm stuck....I have one spreadsheet in which there is a form which get
completed by other users. What I would like to do is be able to save this
sheet to a different file using the date to file it under. Also as read only.
Many thanks.
--
ASU

vb code to save a spreadsheet to file
 

ASU,
Did you look at the .SaveAs method ?
MyWB.SaveAs Format(Now(),"YYYYMMDD")

regarding Read Only, use SetAttr.

NickHK

"ASU" wrote in message
...
I'm stuck....I have one spreadsheet in which there is a form which get
completed by other users. What I would like to do is be able to save this
sheet to a different file using the date to file it under. Also as read
only.
Many thanks.
--
ASU