Results 1 to 10 of 10

Print to PDF with Looping

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Manila, Philippines
    MS-Off Ver
    2019
    Posts
    102

    Print to PDF with Looping

    Good day gurus!

    First off, please take a look at the attached Excel workbook to get a good grip of the challenge I am currently facing

    Now to the query.

    I have a task to populate a form and save it as PDF. It is actually a resume database and all entries/fields are in Excel sheet. Easy, right? Easy to manually do it if there are only say 5 to 10 resumes, and convert them to PDF one by one. The problem arise as the there are as of the moment, close to 100 different entries/resumes that I need to convert to PDF. I will be needing a system that loops through the ID Number in "DATABASE" sheet, get the information per row that correspond to that ID number and send to "RESUME FORM" sheet, and convert that sheet to PDF. I should end up with multiple pages of PDF file.

    I am quite confident that gurus here will be able to find a solution to this challenge, as I have been posting questions here before with more complicated systems. Hope you guys an help me with this.

    Thanks in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trying to Build a Looping Print Macro
    By baersarke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2016, 04:06 PM
  2. Looping through list box selections to print range to PPTX
    By e30325i in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2014, 02:10 PM
  3. Disabled print toolbar and menu but Print Macro button cannot print also...
    By zein97 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-22-2014, 01:42 PM
  4. Set print area of selected range then print preview if ok then print the document!
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2014, 07:10 AM
  5. Do Until Looping (not looping through all other columns)
    By orle8050 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2013, 10:37 AM
  6. VBA to set print range, open box asking for print qty, print, then redefine print area
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2012, 06:43 PM
  7. Looping a print report through a series of records
    By AGM in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-22-2005, 04:25 AM

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