Consulting

Page 2 of 2 FirstFirst 1 2
Results 21 to 23 of 23

Thread: Print userform to PDF

  1. #21
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    You didn't include my function. The more important thing is that you did not provide a drive:\path\filename.pdf for the file to create. Are you going to create a static filename like I did or is it built from parts of your userform control Values?

    The userform was too big to fully display and show the buttons for me. That may be a factor for you if others have screen settings lower than yours.

    e.g. Static Name:
    Private Sub btnPrintPDF_Click()  
      WindowToPDF ThisWorkbook.Path & "\Staples.pdf"
    End Sub

  2. #22
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location
    perfect!!! thanks for hanging in there with me on this. much appreciated. Solved.
    Peace of mind is found in some of the strangest places.

  3. #23
    I'm just here to say THANK YOU! I needed to perform this exact operation and was able to successfully use the code supplied.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •