Read range > Write Range
Do you need the header from excel A? if you don’t need the header from excel A then you can simply achieve this goal by disable add headers in write range. To be able to write in Excel B you need to have another excel application scope to open Excel B and put your write range inside of Excel B application scope.
belong link might be useful for you please have a look.