+ Reply to Thread
Results 1 to 4 of 4

Export sheet to PDF as sheet name help with code

  1. 03-20-2018, 09:31 AM #1
    taylorsm
    taylorsm is offline
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Export sheet to PDF as sheet name help with code

    How do I make it ask me where to save instead of a default location? 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 03-20-2018, 10:12 AM #2
    6StringJazzer
    6StringJazzer is offline
    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: Export sheet to PDF as sheet name help with code

    Modify by adding red code:

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  3. 03-20-2018, 10:40 AM #3
    kev_
    kev_ is offline
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Export sheet to PDF as sheet name help with code 

    Please Login or Register  to view this content.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear
    Reply With QuoteRegister To Reply
  4. 03-22-2018, 12:01 PM #4
    taylorsm
    taylorsm is offline
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: Export sheet to PDF as sheet name help with code

    Thank you guys!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] is there a way to export data from a sheet to a different workbook with VBA code?
    By kevinu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2017, 01:43 AM
  2. [SOLVED] Export data from sheet to sheet based on single criteria
    By WHATSXL in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-27-2017, 01:31 PM
  3. VBA code to export Pivot from masterbook to active sheet on both side
    By johnmacpro in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2016, 03:26 PM
  4. How Command Button click to print out the sheet and export the value to another sheet?
    By Abrisam in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-16-2015, 07:00 AM
  5. Need VBA code to export data from HP ALM to excel sheet
    By prat123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-27-2015, 11:13 AM
  6. Export each sheet to PDF. Filenames change, but prints same sheet to all
    By cdself in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-03-2014, 05:25 PM
  7. Export 2 coloums data from 1 to 30 sheet to one new excel or in a different new sheet
    By Dhamu13 in forum Excel General
    Replies: 3
    Last Post: 09-04-2013, 02:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1