'Copying data from multiple worksheets on a workbook to other workbooks that each have the same name as the current worksheets while they are closed

I'm quite new to VBA.

I have a workbook named Fruit. It has multiple worksheets such as Apple, Orange, Grape and so on.

In a certain folder, I have workbooks whose names are the same as the worksheets above(Apple, Orange, Grape, ...) and each has one worksheet named the same as each workbook.

I want to copy data from the workbook Fruit to the workbooks on another folder while not opening them. Data from each worksheet should be copied to the workbooks named the same as the worksheets. Importantly, I don't want to copy worksheets themselves but just cells on certain ranges.

Sorry for not providing any codes. As I said, I'm new to VBA and trying to learn it by studying the codes you provide for me. I'll really appreciate your help.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source