Efficiently lining up pictures...

  • Thread starter Thread starter Tornados
  • Start date Start date
T

Tornados

Goodday and a happy new year to start off with!!

I have created a macro in which all charts in an excel sheet are bein
pasted as floating pictures in word.(10)


Now I would like to rearrange them immediatly in 2 koloms with
charts...

I've been trying, but can't figure out a nice and efficient way to d
so.... Someone maybe?

Regards, Ivo Geijsen

ps.. I know it is actually a word question, still it has something t
do with excel ;) and to my knowledge there aren't any word forums wher
posts are actually viewed :
 
There are several Word newsgroups in which you can get answers to your
Word questions. You can access them through a newsreader, such as
Outlook Express, or through the Microsoft Web site:


http://communities2.microsoft.com/communities/newsgroups/en-us/default.aspx


Your pictures will be much easier to manage if you format them as inline
shapes. Create a separate section in the Word document, and format that
section with two columns. For example:
'============================================
'Paste and format as inline
Selection.PasteSpecial Link:=False, _
DataType:=wdPasteEnhancedMetafile, _
Placement:=wdFloatOverText, DisplayAsIcon:=False
Selection.ShapeRange.ConvertToInlineShape
'============================================
'format section as two columns
With Selection.PageSetup.TextColumns
.SetCount NumColumns:=2
.EvenlySpaced = True
.LineBetween = False
.Width = InchesToPoints(2.75)
.Spacing = InchesToPoints(0.5)
End With
'======================================
 
Back
Top