+ Reply to Thread
Results 1 to 2 of 2

Portrait Photos inserted with VBA are offset and not properly sized

  1. #1
    Registered User
    Join Date
    Michigan, USA
    MS-Off Ver
    Excel 2010

    Portrait Photos inserted with VBA are offset and not properly sized

    I have been using the same VBA code to insert images for years. It works well for landscape images and for SOME portrait images. Now, some portrait images are offset, not properly sized, and sometimes rotated. I have looked at the EXIF data of dozens of images to see if I can identify anything common to the images that will not go in properly. I cannot find anything. The EXIF orientation on most images is set to 0 (normal). Some are set to 6 (90 degrees CCW). However, some that are set to 0 insert correctly while others don't and some that are set to 6 insert correctly and others don't.

    I don't know when the problem started but I think it has been since Excel 2013. I have tried a couple of ways to insert images via VBA but the results are the same.

    This is one of the methods I use for inserting images. Pease note that I am not a programmer. This was written for me by a Microsoft MVP who is no longer in business. It has had some minor modifications by programmers over the years. I am open to any suggestions for improvements. Any help will be very much appreciated.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    East Auckland
    MS-Off Ver
    Excel 365

    Re: Portrait Photos inserted with VBA are offset and not properly sized

    That code doesn't do too bad a job of inserting images for me.

    Can you upload a sheet (and image?) with what you are getting and what you want to get so we can replicate the issue?
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

+ 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. [SOLVED] Running balance column formula not auto adjusting properly when rows are inserted.
    By JPollard in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-08-2018, 11:58 AM
  2. [SOLVED] Date is not inserted properly in Textbox (UserForm)
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-30-2014, 11:25 AM
  3. [SOLVED] Button Not Sized or Located Properly
    By jeff_kaufman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-12-2013, 06:12 PM
  4. How to reduce file size of photos inserted in Excel
    By pastelli@aol.com in forum Excel General
    Replies: 2
    Last Post: 07-28-2006, 10:20 AM
  5. Excell-why are my inserted photos fuzzy once page is reopened
    By Charlie Mitchell-Archive Services in forum Excel General
    Replies: 0
    Last Post: 04-14-2006, 02:00 PM
  6. Rows inserted into a List will not sort properly
    By Derek Jones in forum Excel General
    Replies: 2
    Last Post: 11-08-2005, 11:10 AM
  7. Replies: 0
    Last Post: 09-23-2005, 07:05 PM

Tags for this Thread


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