I want to copy a portion (A1:F54) of my current worksheet that I am working on, over to another workbook, that is not open. I want to use a button to do this. I am sure VBA is necessary and there would probably need to be a call to open the other workbook. There might also be another obstacle : the workbook that is to be copied to is in a shared online folder.
Any assistance in this issue would be greatly appreciated. Any time that you have taken to read or investigate into this question is greatly appreciated.
Excel vba copy worksheet to another workbook without opening
Excel vba copy worksheet to another workbook and rename - Best answers
Excel vba copy data from another workbook without opening - Best answers