Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-01-2017, 06:36 AM
gmaxey gmaxey is offline Picture inserting,resizing and rotating with Macro depending on height and width Windows 7 32bit Picture inserting,resizing and rotating with Macro depending on height and width Office 2016
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,636
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

Not exactly sure what you are after but maybe:



Code:
Sub ScratchMacro()
'A basic Word macro coded by Greg Maxey, http://gregmaxey.com/word_tips.html, 11/1/2017
Dim strFile As String
Dim oILS As InlineShape, oShp As Shape
Dim bRotate As Boolean
  
  bRotate = False
  With Dialogs(wdDialogInsertPicture)
    .Display
    If .Name <> "" Then strFile = .Name
  End With
  If strFile <> vbNullString Then
    Set oILS = Selection.InlineShapes.AddPicture(strFile)
    With oILS
      If .Width < .Height Then
        Set oShp = .ConvertToShape
        oShp.IncrementRotation 90
        bRotate = True
      End If
    End With
    If bRotate Then Set oILS = oShp.ConvertToInlineShape
    With oILS
      .LockAspectRatio = msoTrue
      If bRotate Then
        .Width = CentimetersToPoints(4.318)
      Else
        .Height = CentimetersToPoints(4.318)
      End If
      MsgBox .Height & " " & .Width
    End With
 End If
 Set oILS = Nothing: Set oShp = Nothing
End Sub
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
Reply

Tags
height, picture, width



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help - Run-time error 91 - VBA for inserting and formatting text depending on style mtrborges Word VBA 2 02-08-2015 11:35 PM
Lost photo content after rotating photos using MS Picture Manager jefflyon Office 1 08-22-2014 11:57 PM
Picture inserting,resizing and rotating with Macro depending on height and width Height and Width blank - Excel Chart in Powerpoint Metronome PowerPoint 1 04-06-2012 06:20 AM
Picture inserting,resizing and rotating with Macro depending on height and width Rotating a picture in a picture box Cath5000 PowerPoint 1 01-18-2012 03:04 PM
Picture inserting,resizing and rotating with Macro depending on height and width Word is inserting bold page-width lines without permission! kozureokami Word 6 05-22-2011 02:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft