Copy sheet into a new workbook including embedded objects

[katnip]

Hello MrExcel users,

Hope all is well.

I would just like to ask on what method to use for copying an entire worksheet including the embedded objects into a new workbook. The embedded objects I am referring to are the screenshots (Clipboard to Excel using API) attached to it.

It seems that the Worksheets("Sheet1").Copy method is not working.

Thanks in advance for those who will respond.

 

[yky]

The following code copies an entire sheet, including pictures, to a new sheet.

Workbooks("Book1").Sheets(1).Copy Workbooks("Book1").Sheets(Worksheets.Count)

 

[katnip]

The following code copies an entire sheet, including pictures, to a new sheet.

Workbooks("Book1").Sheets(1).Copy Workbooks("Book1").Sheets(Worksheets.Count)

Hello yky,

Thank you for giving your input. I'll give this a try and let you know if it works like magic. Thank you again!