+ Reply to Thread
Results 1 to 13 of 13

Macro To Populate Adobe PDF

  1. 04-07-2011, 03:25 PM #1
    rygon8
    rygon8 is offline
    Registered User
    Join Date
    03-15-2011
    Location
    Rio Rancho, NM
    MS-Off Ver
    Excel 2010
    Posts
    21

    Macro To Populate Adobe PDF

    Hi

    I have another problem involving a set-up to a PDF from a macro. On the "results tab", there is a macro built-in to the purple button, that populates the information below based on the end user's selections of category and percentage. (thank you forum gurus marvinP & jaslake)

    Is there any macro out there that would create a PDF based on the selections from the results tab? Could I potentially solve this issue with a lot of IF,THEN formulas (I think that could become very messy)? I'm open to any and all suggestions.

    I have attached the spreadsheet, the "for PDF" tab shows the preferred layout for the end user's PDF.

    Thank you.
    Attached Files Attached Files
    Last edited by rygon8; 04-12-2011 at 01:50 PM.
    Reply With QuoteRegister To Reply
  2. 04-07-2011, 03:32 PM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Macro To Populate Adobe PDF

    Hi,

    I found my name in your post and was worried I was in trouble (again).

    Excel 2010 has a Save As PDF, which I did and attached the output. Is this what you want?
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  3. 04-07-2011, 03:36 PM #3
    rygon8
    rygon8 is offline
    Registered User
    Join Date
    03-15-2011
    Location
    Rio Rancho, NM
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Macro To Populate Adobe PDF

    Quote Originally Posted by MarvinP View Post
    Hi,

    I found my name in your post and was worried I was in trouble (again).

    Excel 2010 has a Save As PDF, which I did and attached the output. Is this what you want?
    Hi Marvin

    No, your previous help was greatly appreciated . Yes, that is the end result that the user will need, but based off of the users inputs from the "results" tab. The current "for PDF" tab from the attached spreadsheet is just to show the wanted layout.

    Thanks.
    Last edited by rygon8; 04-07-2011 at 05:10 PM.
    Reply With QuoteRegister To Reply
  4. 04-10-2011, 10:47 PM #4
    rygon8
    rygon8 is offline
    Registered User
    Join Date
    03-15-2011
    Location
    Rio Rancho, NM
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Macro To Populate Adobe PDF

    Bump. No Response.

    Any new thoughts on Adobe Macro ?
    Reply With QuoteRegister To Reply
  5. 04-11-2011, 01:57 PM #5
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Macro To Populate Adobe PDF

    Hi rygon8

    I'm not certain but I THINK you're asking for a procedure to POPULATE Sheet "For PDF". The code in the attached does that. If this is not what you require, please explain further.
    Attached Files Attached Files
    Last edited by jaslake; 04-11-2011 at 02:30 PM.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
  6. 04-11-2011, 02:06 PM #6
    rygon8
    rygon8 is offline
    Registered User
    Join Date
    03-15-2011
    Location
    Rio Rancho, NM
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Macro To Populate Adobe PDF

    Hi John

    Yes, that is what I'm looking for. To have the "for PDF" tab populated based on the user's inputs from the "results" tab. I don't think you attached anything to your thread ?

    Thank you.
    Reply With QuoteRegister To Reply
  7. 04-11-2011, 02:31 PM #7
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Macro To Populate Adobe PDF

    Hi rygon8

    Sorry 'bout that...must have brain freeze today...I've attached the file to my previous post.
    Reply With QuoteRegister To Reply
  8. 04-11-2011, 06:29 PM #8
    rygon8
    rygon8 is offline
    Registered User
    Join Date
    03-15-2011
    Location
    Rio Rancho, NM
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Macro To Populate Adobe PDF

    Hi John,

    Yes, this works great. I was wondering is it possible to have the code set so that the "for PDF" tab stacked on top of each other, you can see from the attached spreadsheet on the "example tab".

    Thank you for all of your help.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 04-11-2011, 06:46 PM #9
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Macro To Populate Adobe PDF

    Hi rygon8

    Was wondering how you might wish to deal with that WIDE pdf. Yes, I should think that possible...need to work on it. Get back to you...
    Reply With QuoteRegister To Reply
  10. 04-12-2011, 10:18 AM #10
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Macro To Populate Adobe PDF

    Hi rygon8

    Try the attached. I've taken the liberty to do some formatting on Sheet "For PDF 5". You can comment out those lines if you like. Let me know of issues.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  11. 04-12-2011, 12:46 PM #11
    rygon8
    rygon8 is offline
    Registered User
    Join Date
    03-15-2011
    Location
    Rio Rancho, NM
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Macro To Populate Adobe PDF

    Hi John

    Thank you again for all of your help on this. One issue, when you select one or two categories from the "results" tab the filter gets turned on in Excel in the results tab. When you then click on the purple button the categories and percentages go blank. Let me know of any solutions to this.

    Thanks.
    Reply With QuoteRegister To Reply
  12. 04-12-2011, 01:42 PM #12
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Macro To Populate Adobe PDF

    Hi rygon8

    Sorry, I'm color blind and didn't notice Auto Filter was still on. There's a line of code out of place 
    Please Login or Register  to view this content.
    Notice the lines of code in bold and italics. If you're not comfortable making the changes, let me know.
    Reply With QuoteRegister To Reply
  13. 04-12-2011, 01:49 PM #13
    rygon8
    rygon8 is offline
    Registered User
    Join Date
    03-15-2011
    Location
    Rio Rancho, NM
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Macro To Populate Adobe PDF

    Hi John

    That worked great. I re-attached the file, in case anyone else wants to see the final excel file.

    Thank you, very much appreciated.
    Attached Files Attached Files
    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)

Tags for this Thread

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