Copying Charts from Closed Workbooks

Hello, I’m creating some code to copy a number of charts from a closed workbook which are required to be pasted into specific locations within the open workbook (carrying the code). I’m getting a compile error (Expected function or variable) on the first occurence of;

Please Login or Register  to view this content.

There are several workbooks that I need to perform this operation for but my code in its early stages and only refers to one external workbook.

Please would someone guide me on where the current code is failing and recommendations for the next stage?

Thank you,

Jess

Please Login or Register  to view this content.

Thank you, that has nicely removed the compile error. Now the macro is running, I’m getting a run time error 5 (Invalid procedure call or argument) on line;

Please Login or Register  to view this content.

Do you know what the solution to this is please?