Hi,
Please can someone assist me with my code below, i am tying to get this to work, i input data in one sheet and then want to store the data in another workbook, if i save the data to the same workbook the code works fine, but when i attempt to save to another workbook, it records the data but does not close the workbook, i am also looking at sending this out to multiple users, have researched so many alternatives but none seem to work, there is talk about ADO but my knowledge is low on that...hoping that someoone can help with this...

Private Sub Auto_Open()