Copy & Paste sheet to another workbook VBA

[Mihael]

Hi,

I have two open workbooks workbook 1 called (A) en workbook 2 called (B). I need to copy the data from sheet1 workbook (A) and paste it in workbook (B) in sheet called Hexagon. I can't figure this out, can someone help me to figure this out in VBA?

 

[Joe4]

If you turn on the Macro Recorder, and record yourself doing this manually, it should give you the VBA code that you need for this.
After you get that, if you need help making it more dynamic, just post the code here along with your needs.

 

[Mihael]

Hi, thats what I did. But I get an error on Sheets("Hexagon").Select

This is the code:

    Cells.Select
    Selection.Copy
    Workbooks.Open ("J:\Kwaliteit Helmond\Hexagon\Excel Templates\Optiv_\" & Matnr & "_ep.xls")
    Workbooks("10704_EP.xls").Activate
    Sheets("Hexagon").Select
    Cells.Select
    ActiveSheet.Paste

It says "Subscript out of range"

 

[Joe4]

That seems to suggest that there isn't a sheet named "Hexagon" in the file named "10704_EP.xls".
Confirm that the sheet really is there, really is named that, and is not hidden.