+ Reply to Thread
Results 1 to 2 of 2

Generate PDF - text alignment

  1. #1
    Registered User
    Join Date
    12-07-2020
    Location
    Rotterdam, NL
    MS-Off Ver
    Office 2019
    Posts
    9

    Question Generate PDF - text alignment

    Hi we use a macro within our organization to be able to generate a PDF of a specific section within Excel. The only problem is that the line spacing of any text that is on the PDF varies from user/computer to user. So with one user/pc the text is completely on 1 line, and with another user the text falls off half way and then starts on a new line. How can we avoid this and create a unified PDF, where it doesn't matter which PC/user you are?

    This is the current code we're using:

    Please Login or Register  to view this content.
    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

    Please let me know, thanks!
    Last edited by 6StringJazzer; 07-20-2021 at 10:11 AM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Generate PDF - text alignment

    The code simply creates the PDF file. This does not give us information to diagnose the spacing. The problem is not in the VBA, it is in the content of the file. Can you attach the Excel file with content that causes the problem? Do you get the same problem when you use the user interface commands to export to PDF?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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] VBA to indent and text alignment
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2013, 08:31 PM
  2. Replies: 2
    Last Post: 05-24-2013, 10:52 AM
  3. Text alignment MaDnEsS!
    By resorte in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-19-2008, 10:25 AM
  4. Text alignment in a cell from VBA
    By brucemc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2006, 02:30 PM
  5. [SOLVED] How do I set text alignment in code.
    By Patch61 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2006, 02:40 PM
  6. [SOLVED] Text alignment within a listbox
    By ndm berry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-13-2005, 09:05 AM
  7. text alignment code
    By k483 in forum Excel General
    Replies: 1
    Last Post: 07-12-2005, 12: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