le 06-04-2019 08:40 AM
Hello everyone,
I'm trying to get a worksheet from a workbook and copy it into another workbook using ActiveX Controls.
I manage to copy the worksheet in the same workbook but what i need is to transfer this worksheet.
Any help would be appreciated 🙂 🙂
le 06-05-2019 10:26 AM
Hello,
You have to save the data on a tab (get data) => close the file => Open new file => Write the tab on the selected worksheet.
Best regards
Kevin
le 06-06-2019 08:59 AM
le 06-06-2019 09:35 AM
Thanks a lot that was helpful