Leaderboard

I don't think you were being to hard on the guy, and slwiser's post was just an easy target for a lame joke.

Well, the title is a bit misleading, as what I'm actually aiming to do is to print a filled-out pdf file with data saved in an FDF file. Here's the thing: at work, there is a blank form in pdf format that has fillable textboxes. What's been done until now is that a group of people painstakingly copy-paste client info into each field. And I was asked to do that today.... ...blech! Always seeking to automate whenever possible, I found that the info is copied from an Excel file, so I started looking for a way to get that info from Excel unto the pdf form. (we all have Acrobat Reader, not the full version) I came across the FDF format, which is a file that stores the data that goes into each field, telling the pdf file what piece of data should go into a given field. Eureka! Familiar with the wonders of VBA, I managed to populate the form now on the fly. But here's the problem. I wrote code to fill the pdf form with the info from any given row clicked on in the spreadsheet, then you print from the print button on the Acrobat Reader program. I wanted to automate it to the point that the code goes row by row printing each new form for each client, but the VBA code goes too quick and it fills the form before it gets sent to the print queue, so some clients get skipped. BUMMER! I can't save individual pdf files as all we have is Acrobat Reader. I'm basically working with the same file (the form) that dynamically has its data changed by the info stored on an FDF file. I thought about using the Wait or Sleep command to stop the code and give Acrobat Reader enough time to send the info to the print queue before the next client is loaded up on the form, but this is inefficient as I'm adding extra unnecessary time. So, any thoughts on what I can do?