Hello, I just want to ask, whether it is possible, that access exports some data into a existing workbook, but into a new sheet. Does anybody have experience with it? Thank you
Hello, I just want to ask, whether it is possible, that access exports some data into a existing workbook, but into a new sheet. Does anybody have experience with it? Thank you
If you solved this thread, would you care to share with others that read this forum?
Hi I have just realized, that the question was quite simple, and can be answered by typing the basic-method into the VBE editor.Code:DoCmd.TransferSpreadsheet {Direction of Transfer}, _ {SpreadSheet Type}, {Query to Select Data}, _ {Full Name of Excel WorkBook, True, {Name of WorkSheet}
Thanks for sharing!