Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi-user file save
I am creating a company survey and want to email the Excel document to all
employees. They will need to save it to a common file on our network and also I want to keep it confidential. I was thinking of creating a macro that was a "save as" and assigning it to a button - first of all will that work? Second - can I create a "save as" that adds the date and exact time to the document so that each form that is completed is saved seperately? (PS: to say that I am a novice might be an compliment) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi-user file save
Hi DeAnna
Look in the VBA help for SaveCopyAs ActiveWorkbook.SaveCopyAs "C:\Copy of " & ActiveWorkbook.Name & " " & Format(Now, "dd-mmm-yy h-mm-ss") & ".xls" -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DeAnna" wrote in message ... I am creating a company survey and want to email the Excel document to all employees. They will need to save it to a common file on our network and also I want to keep it confidential. I was thinking of creating a macro that was a "save as" and assigning it to a button - first of all will that work? Second - can I create a "save as" that adds the date and exact time to the document so that each form that is completed is saved seperately? (PS: to say that I am a novice might be an compliment) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi-user file save
Ron has shown you the necessary SaveAs code.
If you create a suitable network folder that everyone has write permission, but not read permission, you can hard code that UNC path into the SaveAs. That way everyone will save to the same place, but will not be able to see other's information. \\servername\sharedfolder\SurveyReplies\ & ActiveWorkbook.Name & " " & Format(Now, "dd-mmm-yy h-mm-ss") & ".xls" Of course, this assumes that no 2 people try to save at exactly the same second. Likely ? NickHK "DeAnna" wrote in message ... I am creating a company survey and want to email the Excel document to all employees. They will need to save it to a common file on our network and also I want to keep it confidential. I was thinking of creating a macro that was a "save as" and assigning it to a button - first of all will that work? Second - can I create a "save as" that adds the date and exact time to the document so that each form that is completed is saved seperately? (PS: to say that I am a novice might be an compliment) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to save multi lingual content from an Excel file to a CSV fil | Excel Discussion (Misc queries) | |||
prompt user to save file as {desired_name} and save it to a variab | Excel Programming | |||
Allowing User to save file | Excel Programming | |||
create multi-field, with layout, user questionnaire to save reply. | Excel Programming | |||
Prompt user to save their file | Excel Programming |