+ Reply to Thread
Results 1 to 5 of 5

move images to specific position

  1. #1
    Registered User
    Join Date
    01-11-2017
    Location
    London, England
    MS-Off Ver
    2003,2007,2010,2013
    Posts
    65

    Lightbulb move images to specific position

    Hello,

    well, I'm trying to get a possible way for a macro can move all non inline images (flowing images) with a specific criteria as following for ex.



    A= get the page width size (215.9 mm) whatever it is
    1.png



    B= get the image width size (60.96 mm) whatever it is
    2.png



    C= get the Absolute position for image in page (32.3 mm) whatever it is
    3.png




    then make (A) - (B) - (C) = the new position for image in page

    215.9 - 60.96 - 32.3 = 122.64


    4.png


    Notes:

    - all changes should be to the page not margin

    - all changes should be applied for non inline images only (flowing images)


    samples file is attached for before and after.


    Thanks in advance

    Cross - Posting link : here
    Attached Files Attached Files
    Last edited by Ethen5155; 01-02-2019 at 09:34 AM.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: move images to specific position

    Try:
    Please Login or Register  to view this content.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    01-11-2017
    Location
    London, England
    MS-Off Ver
    2003,2007,2010,2013
    Posts
    65

    Re: move images to specific position

    Hi Paul,

    first of all many thanks for your cooperation as always expected, second it works so cool but only one matter is left

    final position should be 122.6 mm as shown on the last screenshot on main topic

    but in your macro i found it be 122.7 mm !!

    why there is always extra 0.1 mm !!

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: move images to specific position

    The reported final position is correct; it is rounded off to the nearest 0.1mm. The original position (in twips) would probably not have equated to exactly 32.3mm from the page boundary and, likewise, its width (in twips) would probably not have equated to exactly 60.96mm. If you doubt this, you can use VBA query the various factors individually, then do the math.

  5. #5
    Registered User
    Join Date
    01-11-2017
    Location
    London, England
    MS-Off Ver
    2003,2007,2010,2013
    Posts
    65

    Re: move images to specific position

    aha i got it now, can't find enough words to thank you brother.

    many thanks again for your generous help

    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 09-07-2014, 12:25 AM
  2. move images from excel to my desktop
    By michaelgs in forum Excel General
    Replies: 0
    Last Post: 09-17-2013, 12:35 AM
  3. Replies: 2
    Last Post: 06-18-2013, 12:15 PM
  4. VBA - Search xls spreadsheet for specific data and move cell value up one position
    By qnmahan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2013, 05:55 PM
  5. How to click macro - Move right 15 cells - Next click move back to home position
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-05-2010, 10:47 PM
  6. Pictures/Images move and distort
    By mmetzler in forum Excel General
    Replies: 0
    Last Post: 06-28-2007, 10:52 AM
  7. [SOLVED] Can I move images in Excel forms?
    By Andy_G in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2005, 03:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1