Hi,

I am trying to copy formulas and pictures from one workbook to another via VBA code. I've got the formula part working as follows:

  filetoopen = Application _
    .GetOpenFilename("Excel Files (*.xls*), *.xls*", , _
      "Select Old File from which to Import Data")
   Workbooks.Open filetoopen
   Set xlOld = ActiveWorkbook
   Set xlNew = ThisWorkbook

    xlOld.Sheets("Worksheet").Cells.Copy
    xlNew.Sheets("Worksheet").Select
    Cells.Select
    Selection.PasteSpecial Paste:=xlPasteFormulasAndNumberFormats, Operation:= _
        xlNone, SkipBlanks:=False, Transpose:=False
I can't seem to figure out how to copy the pictures on the original Worksheet tab to the new workbook Worksheet tab.

Can someone help me with this please?

Many Thanks,
Karyn