Hello,

I've been trying to find a solution to this for the past few days.
I need to open a workbook(target workbook) saved in Sharepoint and copy data into it. I've been able to open it and transfer data to it. However, if the workbook is already open, the macro will try to open it again.
Is there something I'm doing wrong within the code? Or would this be a matter of mapping network drives correctly? Any help is greatly appreciated! 


Please Login or Register  to view this content.