Saving userform data to different workbook

[jcarstens]

Is it possible to have a userform open in a workbook and when the data from the form is saved, save it to a completely different workbook. If so, will that other workbook need to be open for the userform data to be saved?

Thank you

[royUK]

The code will need to open the workbook then save to it. Not difficult, you need to specify the workbook & sheet to write to.

Hide the procedure by switching off screen updating

[jcarstens]

Would you mind helping me out with this. I attached a sample. The user form is in Workbook test1 and I would like the data saved in both workbook test1 and duplicately in workbook test2. I undestand the pathe will change on your machine, but if you could help me out with the layout, that would be extremely helpful.

Thank You

[jaslake]

Hi jcarstens
I've modified your code to copy the userform data to Test2.xlsx. The procedure assumes both workbooks are in the same folder.
Let me know of issues. John

PS: I should have pointed out that the procedure assumes Test2.xlsx is closed when you click Button1. If you need to include a test to see if Test2 is open, that can be added.

[jcarstens]

That is perfect, thank you.

[John Cruz]

That is Really Helpful "jaslake"

[Loe]

Its been a long time since your code was posted jaslake, rest assured that it is still as useful as the day you posted!
thank you so much!!