+ Reply to Thread
Results 1 to 6 of 6

Print PDF Code

  1. #1
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Print PDF Code

    Can't seem to make this work, the first part open a folder with all the subs by value in C13. In C16 is the name of file,I want to click a button and have the folder open then chose the sub and save the
    file as pdf.Can this be done and only have one dialog box open?


    Please Login or Register  to view this content.
    Last edited by zplugger; 02-09-2015 at 09:09 AM.

  2. #2
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Print PDF Code

    Looking for help here too,will post results.
    http://www.mrexcel.com/forum/excel-q...t-working.html

  3. #3
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Print PDF Code

    Here is where were at, cant get it to show workbook name right in the save dialog box?

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Print PDF Code

    Guess my next question is Can this be done
    Open the selected folder by value in C13 then save active sheet as pdf with the sheet name is value c16?

  5. #5
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Print PDF Code

    Maybe this explains better what I would like to do.
    Thanks
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Print PDF Code

    Closing threat due to lack of suggestions
    Thanks for anyone that had a look.

+ 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. Print code with checkbox and print dialogue/summary
    By sigilbo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2014, 05:39 AM
  2. Correct VBA Code to Print Defined Print Area
    By newqueen in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-27-2014, 04:31 PM
  3. Code and Formula to print dynamic print area ranges
    By stpeter in forum Excel General
    Replies: 1
    Last Post: 10-15-2013, 03:33 PM
  4. [SOLVED] Need ‘Set Print Area’ Code for Dynamic Print Range based on Conditions
    By dosbirn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2013, 12:13 PM
  5. [SOLVED] Print array code for a series of pages that will also determine print area required?
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2012, 11:46 PM

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