View Single Post
 
Old 01-08-2020, 09:32 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I don't think there is a container you can paste into so I would be looking at the code to resize the graphic after the paste. I also haven't worked out the code to resample the bitmaps after resizing but the resizing could be done with...
Code:
Sub ResizeShapes()
  Dim aShp As Shape
  For Each aShp In ActiveWindow.Selection
    aShp.CellsSRC(visSectionObject, visRowXFormOut, visXFormWidth).FormulaU = "100 mm"
    aShp.CellsSRC(visSectionObject, visRowXFormOut, visXFormHeight).FormulaU = "50 mm"
  Next aShp
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote