Hi everyone, I'm Maurizio
I am writing to you as I have a problem that I would like to solve with my new Microsoft office 2019 Pro Plus.
My problem is this:
On an excel sheet I try to make a sort of Template for an Attachment that I will then have to use as a sort of Attachment to be sent via Email to whoever I want.
Now I was able to create and save an Excel sheet and insert only the data I want by saving only sheet 1
And so far everything is ok
Now I would like to be able to make this Excel file that I created could also insert the image I have on the Main Sheet.
You have some ability to copy this image as well
That's it. Send test file Thank you
Greetings from A.Maurizio
To Insert (copy) a shape from a file to another:
Dim Pic1 As Shape, Pic2 As Shape, Sh1 as Worksheet, Sh2 as worksheet
Set Sh1 = SourceWorkbook.Worksheets("SourceSheetName")
Set Sh2 = DestinationWorkbook.Worksheets("DestinationSheetName")
End With
Set Pic1 = Sh1.Shapes("Picture Name")
Pic1.Copy
Sh2.Paste
Set Pic2 = Sh2.Shapes(.Shapes.Count)
Pic2.Top=Sh2.Cells(1,1).Top
Pic2.Left=Sh2.Cells(1,1).Left
Hi Catalin Thanks for your support
It was what I wanted to accomplish but it never worked
Now it's perfect. Thank you
You are as awesome as ever
Greetings and good day from A.Maurizio
