+ Reply to Thread
Results 1 to 4 of 4

Saving sheets to PDF does not copy the correct format

  1. #1
    Forum Contributor
    Join Date
    08-23-2013
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 365
    Posts
    166

    Saving sheets to PDF does not copy the correct format

    Using the code below, the worksheets save to PDF and my destined file without a problem. But once I open my sheets in PDF some of the textual colours and columns are cut out and there is blotches of white is some of the cells. All in all, it doesn't look like the page in EXCEL as it does when I save it to PDF.
    [hope this makes sense]

    help would be awesome,

    thanks,

    Sheets("Zone A").Select
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, fileName:="s:\Communities\Monthly\Zone A\Zone A.pdf", Quality:=xlQualityStandard, IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:=False

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,044

    Re: Saving sheets to PDF does not copy the correct format

    Maybe you should use a different .pdf viewer?

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    08-23-2013
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 365
    Posts
    166

    Re: Saving sheets to PDF does not copy the correct format

    It worked with someone elses Adobe X, so perhaps theres an Adobe update?

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,044

    Re: Saving sheets to PDF does not copy the correct format

    I don't know. Your computer, he say no. Someone else's computer, he say yes. You haven't shared the file so we can't view or test it.

    There's usually a "check for updates" option, often under Help. I have Adobe Reader XI.

    Regards, TMS

+ 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] Check cells are correct format and contain correct data
    By rikosborne in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-26-2014, 02:53 PM
  2. Macro to copy email to excel not in correct format
    By josh640557 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2013, 11:59 AM
  3. Replies: 13
    Last Post: 08-20-2012, 01:37 PM
  4. Fix Needed for Code to Send Correct Data to Correct Sheets
    By swordswinger710 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-04-2012, 03:53 PM
  5. Saving Excel Files to Correct Format with Macro
    By Smurlos in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2010, 06:49 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