ProjectWoman: Pictures inside Excel comments:: Mar 22, 2007 Pictures inside Excel comments. In a previous tip of the day, I see or hear something cool, I can can crank it up and get the word out. http://www.projectwoman.com/2007/03/pictures-inside-excel-comments.htmlHOME | Hello,
Excel Insert Multiple Pictures Software 7.0 - Insert one or many :: Get pictures and photos from multiple Excel files quickly. This application will scan Related Software. Excel Import Multiple Word Files Software 7.0 http://www.fileflash.com/program/9831/HOME | [R] export graph/data to Word/Excel:: 2. how to export those data/graphs to other applications like Word/Excel? I use RODBC to import data. Thanks, Yu-Ling Wu http://stat.ethz.ch/pipermail/r-help/2001-January/010355.htmlHOME |
I am using Automation to pass pics from Excel into Word document.
Basically, I use -copy Range- and
Selection.PasteSpecial DataType:=wdPasteMetafilePicture
Then I would like to adjust the size of the picture so that the upper-left corner stays and down-right corner is shifted to the side or bottom page border, whichever it hits first. GetAFreelancer.com - Format Excel Files into good looking word :: Feb 15, 2008 -for each excel file there is at least 5 pictures and associated information for each picture -copy the picture into the word document (and http://www.getafreelancer.com/projects/Graphic-Design-Data-Processing/Format-Excel-Files-into-good.htmlHOME | Cross-platform issue with Excel grafics in Word:: My Word docs very often contain graphics from Excel which have been pasted in as unlinked pictures. The parent Excel files are massive so I.. http://forum.soft32.com/mac/Cross-platform-issue-Excel-grafics-ftopict92581.htmlHOME |
The proportionality of the picture should stay.
Is this possible?
Thank you
Martin
This may help: The first line centers the pic. (could left align if you like). The if statement checks to see if the pics are portrait or landscape and and size the pic accordingly.
.ParagraphFormat.Alignment = wdAlignParagraphCenter 'Center the picture
If .InlineShapes(1).Height / .InlineShapes(1).Width < 1 Then 'Landscape Pic
.InlineShapes(1).LockAspectRatio = msoFalse
.InlineShapes(1).Height = 270#
.InlineShapes(1).Width = 360#
Else ' Portrait Pic
.InlineShapes(1).LockAspectRatio = msoFalse
.InlineShapes(1).Height = 270#
.InlineShapes(1).Width = 201.6
End If
Where's The Advantage In Windows Genuine Advantage?
Stocks Bounce After S&P Joins Bear Market |