Problem with Macro to copy and paste a selection

[elgato74]

Hi Guys,


I am trying to come up with a macro that copies a selection from one workbook to another.

The macro should firstly select the range of filled data as shown here

1.png

and then copy and paste it to the end of my other workbook as shown here

2.png


Thank you for your help !

[kev_]

Try this - amend file name, path, worksheet names

Please Login or Register  to view this content.

[elgato74]

Thank you very much ! It works !

However, if my workbook (FileToPasteTo) is already open, then the macro gives me an error.

Can this be fixed ?

[kev_]

Try amended VBA below

If the file is already open you may not want to close it

replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[elgato74]

Thanks again !

Now I get the warning that the Workbook "FileToPasteTo" is already open and that re-opening it might cause loss of data. I do not want to re-open it, if it is already open. I want to paste in in the open workbook. If it isnt open, then the Macro should open it.

[kev_]

Please paste your code into reply
Then select the whole code and click on # icon (to include code tags)
thanks

[elgato74]

Please Login or Register  to view this content.

[elgato74]

btw, Cheers to Cornwall We always loved it there, esp. Mawgan Porth

[elgato74]

Duh, i think i found the error ! My bad !

[elgato74]

Please Login or Register  to view this content.

had to be replaced with my workbook name

thanks muchly kev_

[kev_]

You are welcome and of, course welcome to visit Cornwall again
Thanks for the rep