+ Reply to Thread
Results 1 to 3 of 3

Save as pdf based on cell value

  1. 10-16-2014, 03:49 AM #1
    BillDoor
    BillDoor is offline
    Forum Contributor
    Join Date
    12-13-2012
    Location
    Shropshire, England
    MS-Off Ver
    Excel 2007 /10 /13
    Posts
    118

    Save as pdf based on cell value

    Hi all

    I have a sheet that all I want to do is hide a few rows, save it as a pdf (title based on a cell ref) then unhide the rows again.

    I have the following code, but for some reason it doesn't seem to actually save the pdf, can you please help, as it's starting to drive me nuts

    thanks

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 10-16-2014, 04:25 AM #2
    bulina2k
    bulina2k is offline
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    861

    Re: Save as pdf based on cell value

    Hi there!
    I don't know what is in your "C6" cell but it should start with "\"(backslash), because the strPath does not end with one.
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you
    Reply With QuoteRegister To Reply
  3. 10-16-2014, 04:30 AM #3
    BillDoor
    BillDoor is offline
    Forum Contributor
    Join Date
    12-13-2012
    Location
    Shropshire, England
    MS-Off Ver
    Excel 2007 /10 /13
    Posts
    118

    Re: Save as pdf based on cell value

    ah, thanks so much!
    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] Save sheet based on cell value
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2013, 11:28 PM
  2. Excel macro to create directry based on cell value & save filename to folder from cell
    By jrr1962 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-13-2012, 09:49 AM
  3. Create Foler based on cell value & save file with cell value name to folder
    By jrr1962 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-12-2012, 11:29 AM
  4. Save based on cell values
    By Rage in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-26-2010, 05:00 PM
  5. save to folder based on cell value
    By Steve in forum Excel General
    Replies: 1
    Last Post: 06-15-2006, 03:00 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