Help with Automatic submission

[michellecairns]

I have a number of users completing information in individual workbooks, that I then need to collate. In order to do this I want to stick a workbook submission button on the first sheet of each workbook that once pressed sends the workbook automatically to a pre arranged folder. Does anyone know the easiest way of doing this?

I was originally going to just use a hyperlink to my email and get them to add the workbook as an attachment but this has been vetoed as too complex a process.

Any help gratefully recieved.

[arlu1201]

Wouldnt it be easier instead to have a button which will collate all the information for you?

The reason i say this is - if you have the button in the active workbook, you will not be able to save and close the same file and then move it to the destination folder. You will need a separate macro workbook for that. Alternatively you can save a copy of the file having the button and then transfer the copy to the destination folder.

Which of these options suit u?

[michellecairns]

Hi Arlette,

Option 2 sound great and would do the job. How would I go about making that happen? Each workbook has about 15 sheets.

[arlu1201]

If you did attach any workbook, we lost it during the upgrade. Can you please attach again?