+ Reply to Thread
Results 1 to 4 of 4

Help resizing image - produces different image size on different computers.

  1. #1
    Forum Contributor
    Join Date
    03-15-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    w 10, Excel 2016
    Posts
    125

    Help resizing image - produces different image size on different computers.

    I have Excel VBA code that copies .JPG files into a specific location in a worksheet, resizes it and exports the sheet into a PDF file. It works fine on my MS Surface notebook running Office 2016 and Windows 10.
    When I run the same code on a different computer (Lenovo) running the same version of Office on Windows 10 – the images are different sizes and even the aspect ratio’s are wrong.
    Just wondering if anyone has ideas on where I start to look. Could screen resolution differences cause this? Here’s an extract of the code that copies the image in to the worksheet and works fine on my surface computer.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,151

    Re: Help resizing image - produces different image size on different computers.

    But your code is not for worksheet but to chart.

    Add maybe line:
    Please Login or Register  to view this content.
    And then test it out maybe:
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    03-15-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    w 10, Excel 2016
    Posts
    125

    Re: Help resizing image - produces different image size on different computers.

    Thanks for your reply. Yes I miswrote it is for a chart sheet not worksheet. I will test out your suggestions. Just to repeat that it works fine on MS Surface but not on another computer running identical setup.

  4. #4
    Forum Contributor
    Join Date
    03-15-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    w 10, Excel 2016
    Posts
    125

    Re: Help resizing image - produces different image size on different computers.

    The problem turned out to be a corrupt file on the destination computer. Apologies.

+ 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. resizing image in userform
    By sammu78 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2014, 09:25 AM
  2. Fix the image size for all image in cell
    By ganeshkumar in forum Excel General
    Replies: 5
    Last Post: 02-20-2014, 08:23 AM
  3. resizing the image in PPT using VBA
    By queryak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-10-2012, 04:23 AM
  4. Resizing an image pasted to ppt
    By c7015 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2012, 01:21 PM
  5. Placing and resizing an image + delete existing image
    By dsheets05 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2011, 09:05 PM
  6. Lookup function that produces a image
    By Brian Tam in forum Excel General
    Replies: 7
    Last Post: 04-21-2011, 08:54 PM
  7. Resizing an image to a % value
    By Taff in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-20-2005, 01:42 AM

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