Log In
Register
Home
June 26, 2016
Offline
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
November 8, 2013
Offline
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
1 Guest(s)
