Fill Table Pdf For Free

hello this is Randy with Excel for freelancers  and today is training we're going to be taking   information from a table and automatically filling  in multiple PDF forms with a click of a single   button so please join us for this amazing training  all righty let's get started so we're starting off   with the table in this table we have a total of  10 names and this table basically contains basic   information for our contacts in this case we're  going to call them patients here's a reason why   you might want to have this type of macro running  let's say you work in a medical office and your   boss asks you to complete patient intake forms for  each and every patient coming in he asks you right   out there their last name first name the address  city state zip and email well now you could write   each one of these out individually however if you  have a list of names we can actually have Excel   automate that through VBA to automate filling out  that PDF and we do have a PDF form available so   that we're going to be using that and we have it  here right in here and now what we can do is that   what we're going to do is we're going to automate  filling in the information of using this PDF form   using the last name first name address to the  state and the fields and then what we're going to   do is we're going to have it save that in a folder  and now we can also have them print it out but in   this case we're going to save it individual each  one with their own individual and distinct name so   let's get started first what we're going to do is  we're going to add some buttons up here and you'll   see I've pre-populated the table with data and  we also have a PDF template and what we want to   do is we want to know what template we're going  to start out with what is the PDF template that   we're going to use and so this gives users the  ability to change the template should so we'll   go ahead and enter some buttons here and we'll go  to what we want to do is we want to locate that   okay so we'll go ahead and enter a browse selected  and that's going to help us locate where the PDF   form is and I've already written the macaron  that in just a very quick math row so I'll go   ahead and show that to you and first we'll go  ahead and format the button to see how we like   it and let's go ahead and give this blue color  and so basically in excel vba and we can do it   alt f11 to get to it or you can use once again  the file options and go to customize ribbon if   you don't have the Developer tab you want to  add it and if you do have it simply click on   developer and then visual basic or alt f11 okay  and here what I've got two macros that we have   and basically one is a PDF template this is going  to allow us to browse for a specific file and the   other is going to allow us to browse through a  specific folder so they're very simple macros   that have written that allow us to do that since  this is not really part of what I want to teach  ...