+ Reply to Thread
Results 1 to 1 of 1

VBA macro imported photos are overlapping with cell borders on export to PDF [Example Att]

  1. #1
    Registered User
    Join Date
    10-08-2019
    Location
    US
    MS-Off Ver
    Office 365
    Posts
    2

    Exclamation VBA macro imported photos are overlapping with cell borders on export to PDF [Example Att]

    We often have a large number of photos with associated meta data that need to be sorted, edited, and eventually exported to a PDF in order to create a photolog. I had sliced together a macro that automatically imports a selection of photos into excel and allows them to still be sorted or moved with the cell. The problem is that anytime they are printed or exported to a PDF, is that every page has a tiny sliver of the first photo from the next page at the bottom. It seems that excel is including the sliver because it is too close to the border, so when it uses that cell border to finish off the bottom of the page its pulling part of the picture with it? I have tried adding thick borders to the pictures and adding thick boarders to the cells to try to push the picture sliver down to its correct page. In instances where we have over 200 photos it is not feasible to resize every photo manually, and in the past changing certain photo attributes by hand has resulted in them not sorting with their cell.

    I have included a zipped example workbook and two sample photos as attachments for ease. It cut me off at two photos and for whatever reason the system refused to accept a zipped folder that contained more than one file so they are all individually packaged.

    Capture.PNG
    Attached Files Attached Files

+ 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. Macro inserts photos but photos are lost when spreadsheet distributed
    By SamFojbk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2019, 02:51 AM
  2. Need help with Macro for Cell Borders
    By judykpoll in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-18-2017, 11:35 AM
  3. VBA Insert all Photos from folder - photos not lined up w/ cell borders in older versions
    By jaimelwilson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2014, 02:26 PM
  4. [SOLVED] Macro - Cell borders + Red Rows
    By delusional in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-27-2012, 06:33 AM
  5. problem with cell borders macro
    By mehdoush in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-05-2009, 03:36 PM
  6. Export two overlapping charts to .gif
    By DynamiteSkippy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-02-2005, 02:05 AM
  7. Macro to change cell borders
    By Roddie Grant in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-03-2005, 07:06 AM

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