Simultaneously Adding Record To Two Different Workbooks (Open And Closed Workbooks) With The Userform
For his process ,we have used Ado Connection again.
With userform in the first workbook,the data can be added easily into the closed workbook without opening workbook.