Good Morning Excel Forum,
I'm having a little issue with taking a xlBitmap screenshot image and placing it in a Word document. I'm able to take the screenshot bitmap image and paste it into a Word doc, but the image has these borders on it. The borders appear even if I change the surrounding cell fills to white w/ white borders. Below is the code:
ActiveSheet.Range(Cells(6, 17), Cells(64, 23)).CopyPicture appearance:=xlScreen, Format:=xlBitmap
With objWdApp.Selection.PageSetup
.TopMargin = objWdApp.InchesToPoints(0.5)
.BottomMargin = objWdApp.InchesToPoints(0.5)
End With
objWdDoc.ActiveWindow.Selection.Paste
i = objWdApp.ActiveDocument.InlineShapes.Count
Set oShape = objWdApp.ActiveDocument.InlineShapes(i)
With oShape
.LockAspectRatio = msoTrue
.ScaleHeight = 75
.ScaleWidth = 75
End With
Set oShape = Nothing
I am choosing this method, because it prevents the exported table/image from being modified. Are there any techniques or methods that I can use to prevent these residual borders to appear?
Thanks Everyone,
Bob1980
Bookmarks