+ Reply to Thread
Results 1 to 5 of 5

Naming PDF output based on cell value

  1. #1
    Registered User
    Join Date
    07-31-2012
    Location
    Minneapolis, Minnesota
    MS-Off Ver
    Excel 2016
    Posts
    52

    Post Naming PDF output based on cell value

    Hello – This bit of code does exactly what I have asked of it. That is - based on a spreadsheet in the same workbook which I have named “Print Control” which has the following: (Header Row is row 1) Column A is “Yes” or “No”, Column B is “Participants Statements”, Column C is 1,2,3…, and Column D is the participant’s name. In cell H7 is “2016 3rd Quarter”. For each “Yes” in column A the statement is generated. On the Participant Statement itself, in cell U2, when the number or value changes, the participant statement is populated with participant specific data. As you can see, as the code loops through, changes the value in U2, populates and prints.
    What I would like to have happen is that when each participant statement is output it does so with the Participant’s Name and “2016 3rd Quarter”. Ideally in PDF format. I appreciate the help!

    Please Login or Register  to view this content.

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

    Re: Naming PDF output based on cell value

    This compiles but I can't test it without your entire file.
    Please Login or Register  to view this content.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    07-31-2012
    Location
    Minneapolis, Minnesota
    MS-Off Ver
    Excel 2016
    Posts
    52

    Re: Naming PDF output based on cell value

    Hello 6StringJazzer,
    I redacted the file. Please advise on how I can attach excel file.

  4. #4
    Registered User
    Join Date
    07-31-2012
    Location
    Minneapolis, Minnesota
    MS-Off Ver
    Excel 2016
    Posts
    52

    Re: Naming PDF output based on cell value

    Hello-
    I uploaded redacted file, but could not seem to get it to attach. Please advise.

  5. #5
    Registered User
    Join Date
    07-31-2012
    Location
    Minneapolis, Minnesota
    MS-Off Ver
    Excel 2016
    Posts
    52

    Re: Naming PDF output based on cell value

    Got it! Thank you!

+ 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. Creating a txt file and naming it based off a cell
    By Johnnyv015 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2015, 06:21 PM
  2. Naming Sheets based on Cell Data
    By SeanD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2012, 06:57 AM
  3. cuting sheet and naming it based on value in specific cell?
    By nokia3650 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2012, 09:44 AM
  4. Naming worksheets based on cell values
    By F6Hawk in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-03-2007, 04:31 PM
  5. naming a file based on cell value?
    By nokia3650 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2006, 02:20 AM
  6. naming .xls file based on a cell in excel
    By lsu-i-like in forum Excel General
    Replies: 1
    Last Post: 06-24-2005, 04:44 PM
  7. Naming a worksheet based on cell data
    By compta_8 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-16-2005, 03:51 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