Except for he starts somewhere other than the beginning of the process. How did he get the Acrobat values (PDF TEMPLATE) into an Excel spreadsheet? That would be a better stating point instead of the 10 stories off the ground he choose to start from!!
Normally never comment on a video. Was trying to automate this process using the JSObject and couldn't for the life of me get it to work. Wish I had seen your tutorial before going down that rabbit hole. The applications for this are boundless. Bypassing the APIs and going right to simple inputting the data like a user would is genius. Thank you so much for posting this video.
Thank you so much Derek, I do appreciate that. I know some of my videos are more complex. I will try to keep them as simple and straightforward as possible. Love the feedback.
HI Andre thanks so much. I have another one I recently did that is simpler and you may enjoy it here: ruclips.net/video/qeQmrADtFjw/видео.html Thank you for your Likes, Shares & Comments. It really helps.
I'm not one to comment on videos, but this has been SUPER helpful! I have never done anything with excel or VBA before and this was a knockout explanation. I'm hoping to cut down manual input and boost continuity within our office and this might just be the perfect fit!
Thanks so much Jacob, I am really glad you enjoyed this and I appreciate your comments. I have another ones along the same lines as this in which you may find helpful right here: ruclips.net/video/6fot1T_g1dM/видео.html Thank you for your Likes, Shares & Comments. It really helps.
Thanks so much Noel. I will be setting up a shop so you can purchase some small Excel items (mugs, shirts, etc) I also have some products and courses you might be interested in here: www.excelforfreelancers.com/products-in-excel/
Thank you for explaining what each step does and for the apostrophe tip! When I run the first check (around 14:10) I keep getting: Compile error: Sub or Fucntion not defined, for the OpenURL "" & PDFTemplateFile & "", Show_Maximized. I re typed the code from scratch numerous times but it keeps popping up.
VBA has always been super intimidating to me. This video may be the best tutorial I have ever watched. The explanation was top notch and I definitely feel like I have the tools to apply this to my cases. Thank you so much.
WOW. That is really amazing. I am super happy to help and share. I also just started a new weekend series on VBA For Beginners, with a new video every weekend. Thank you for your Likes, Shares & Comments. It really helps.
Thanks so much. I do appreciate that. I will only email you new weekly videos on Tuesdays. I won't be spamming :) (also some people have trouble with emails so automated facebook chat works well too, to get your downloads and to get weekly new video announcements)
Another worthy tip for anyone interested, one of the reasons why SendKeys is discouraged is because with this methodology, it sends the keystroke to what's the active window, which can be disastrous for your macro. To that end, be sure that you enable focus on the application you are sending keys to.
Hi and thanks for your comment. Instead of OPenURL please use ThisWorkbook.FollowHyperlink instead. Please see my sample. You can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
You are a great teacher! Just wanted to point out that VBA doesn’t allow you to declare a group of variables to be a particular data type by separating the variables with commas. For example, though valid, the following statement does not declare all the variables as Integers: Dim i, j, k As Integer In this example, only k is declared to be an Integer; the other variables default to the Variant data type.
Hi and thanks so much for your comment. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
@@ExcelForFreelancers Thanks for responding! I have a long list of clients for whom I am trying to populate individual forms. I have an excel sheet with the names and a pdf form template. The only difference with my pdf template is that it is fillable with dropdown options as well. I wish to keep the layout of my pdf template. I would be happy to speak with you off this public domain, if possible?
Hi and thanks. The application is open and you are welcome to customize this to fit your exact requirements, however I am unable to take on any projects of my own. If you would like some help with this, we have a group with 40,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet) You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project. I hope this helps and thanks so much.
Can you help me openurl statement ? when I put OpenURL "" & pdftemplatefile & "", Show_Maximized show maximized gives compile error: variable not defined. This erroe it gives on show_maximized highlighted
Hi thanks you will not want to use OpenURL (this was not a good idea by me) You an use Application.FollowHyperlink pdftemplaefile You can also download my copy, which has the FollowHypperlink code, using hte links in the description. (i hope this helps)
Thanks and I am glad you like it. I would try save the file using just your keyboard only to see what shortcuts are required, then you can transfer that shortcut to VBA using sendkeys
@@wadepritchard1283 in case nobody replied to your question after a year, one of his other video has exactly that. Use sendkeys for ''save as'' instead of ''print'' and keep the process the same
This is fantastic. It really opened my eyes to the possibilities of interaction between excel and other applications. Keep up the great videos. Do you know if there is a way to use sendkeys with formatted font options instead of just black... i.e. red, or bold ...or both. Thanks.
Hi and thanks so much for your comment. SendKeys can be used perhaps you can if you use the same keys for the formatting however it does depend on the host application and how they determine the formatting. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
I appreciate this video! Great work. A suggestion would be to slightly alter the code so that instead of writing a new PDF file each time, that instead, you save the template with the patient-appt date file name. That way, the form-based PDF could be forwarded to the patient for them to fill in any blank fields, and more importantly, give them the ability to edit any fields that might have incorrect information. OOPS - I just read the comment from Ruth Block a few comments back - and your reply that answers this need!
HI and thanks so much. I am glad you were able to get the solution. Since this video i have had a lot more ways to fill in pdf's, including this one ruclips.net/video/wI6nFlq9CS8/видео.html I hope this helps and thanks so much.
Hi you can use ThisWorkbook.FollowHyperlink along with the variable, and you also should check the long file name to make sure its correct. Thanks so much.
Excel For Freelancers: Thank you SO much for your useful tutorial! First time tuning into your channel and have subscribed! This solution proves very useful as I am filling out multiple PDF forms for multiple individuals! Thank you again! Keep up the great work! Be Blessed
Great tuts here Randy. Btw, I was reading all the comments to find out whats the hot key for or the work around for Radio butttons with a yes, no and other options. Thanks Randy.
Hi Deither, usually its the spacebar to check/uncheck or select/unselect these options. (you can try it with your keyboard on your pdf) You would then use an If Then statement within VBA to see if a check is necessary and if so use a space such as If sheet1.range("A1").value = True then Sendkeys " " Sendkeys "{TAB}" Else: Sendkeys "{TAB}" End If Perhaps something like that. I hope that helps and thanks.
I know that this is an old video but it's new to me. Excellent. I've been using and programming apps on Excel for a while and I learned quite a few things on this video. I'm going to test this form right away.
Hi JG, Thanks so much. I was just thinking to redo this video next week but to add more 1) Start with a form that is not fillable, and also do it from scratch, starting with a blank worksheet. So it would go from: Static/Scanned in PDF > Fillable PDF with Fields > Automatically Add in Data from a table > Email, Print, Save the form All from scratch. What are your thoughts?
this was one of the best tutorial I have ever seen. one question is that once all the data is created, how would you make the last row to be entered since all other rows are filled. a new customer comes and we want only create a file for the last customer
HI and thanks so much for a new customer you would assign the first available row, such as CustRow = Sheet1.Range("A99999").end (xlup).row + 1 I hope this helps and thanks so much.
Great video, it helped me out so much. I have a question about the file if it already exists. What text would I replace "Kill" with to instead "Overwrite"?
H and thanks so much. You can use FileCopy OriginalPath, DestinationPath The destination path would overwrite the existing file. Make sure the existing file is in a closed application and not open on your desktop. I hope this helps and thanks so much.
Hi and thanks for your comment. I am sure this can be completely customized for your requirements. If you need help with this, I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
Very helpful and encouraging explanation. I have a question. Think that I have a PDF form that has checkbox or radio buttons (Like GENDER- Male / Female or EYECOLOR - Brown/Blue/Hazel /etc), how should I format related cells in excel without adding check-box or radio button in each cells for each record. If just enter "X" or any other character in related cell, how would it convert to a tick or X in pdf form?
Hi and thanks very much. The Spacebar is used to check radio buttons or checkboxes, so you can use something like this If .range("M" & ContRow).value = True then 'Checks a condition to see if its true SendKeys " ", True SendKeys "{TAB}", True Else 'Tabs through without checking SendKeys "{TAB}", True SendKeys "{TAB}", True End IF I have not tested this code but it would be something like that. I hope this helps and thanks so much.
I am having troubles with the first PDFTemplate macro you have here at 3:03 on my mac. When attempting to run this, I am receiving the message: "Run-time error '91': Object variable or With block variable not set". Any ideas how to resolve this?
HI and thanks. If you are trying to run this on a Mac, the browse for file is slightly different. You can find the code updates for that here www.macexcel.com/ If not, you can also post your issue in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
This was very helpful! I saw your response to a comment below regarding check boxes. What do you recommend for radio buttons in the PDF form? If I am only using keys to fill out the form, it only switches between radio buttons using the left and right keys, so I am a little lost. Thanks!
Hi and thanks so much for your comment. You can use an If/Then statement, based on your data. Something like If .range("A" & CustRow).value = True then SendKeys "{LEFT}" , True Else Sendkeys "{RIGHT}", True End IF I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Thanks for sharing valuable knowledge. I have a question I am preparing the invoice form in acrobat but I have the product list and there prices. I want to link with Excel file to pdf and when I update the prices than pdf form also update these prices of the product
Hi and thanks so much for your comment. You can print the invoice in PDF format and replace the existing one with a new one. I show you how to do that in this video ruclips.net/video/eF678YvQ93g/видео.html I hope this helps and thanks so much.
I can't begin to explain how helpful this video has been!!! Thank you so much man!!! You are a gem! Kudos!!!! However, I have one issue. I would be really really grateful if you could please share the coding for someone using Mac instead of Windows! PLEASE RESPOND. THANKS. I AM WILLING TO PAY TO CHANGE THE CODING FOR MAC
HI and thanks, I would hope Mac's would be the same, however since I do not have a Mac here to test on, I can't be sure. However there is no doubt we can help you with that. Can you post your question in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.
Hello, when i run OpenURL "" & PDFTemplateFile & "", Show_Maximized. (around 14:10) I keep getting: Compile error: Sub or Function not defined, for the OpenURL "" & PDFTemplateFile & "", Show_Maximized. ive tried different ways including ThisWorkbook.FollowHyperlink PDFTemplateFile but it still doesn't run correct and tells me method FollowHyperlink of object _workbook' failed. could it be im running it on exel office 365?
While an older video, it is new to me and absolutely stunning! It helped me immensely! Is there a way to alter the code into a separate macro that would allow you to do the same thing but for an individual row based on a data validation drop down? Such as if this amazing program has already run, but you would update new/existing users into the table and would then only need to have it run for a specified user?
Hello. Excellent tutorial. I have one question. Is it possible to specify which printer to use with VBA code? I want to use "Microsoft Print to PDF." If I've recently printed with my physical printer then it sets that physical printer as the default and I don't want to set print to PDF as the default for me entire computer. Thoughts? Thanks!
Hi Patrick, Thanks for your comment and question. You can print to a specific printer using some code such as this Sub MyPrint() Dim sCurrentPrinter As String Const MyPrinter As String = "Lexmark E350d" sCurrentPrinter = Application.ActivePrinter Application.ActivePrinter = MyPrinter ActiveSheet.PrintOut ' Application.ActivePrinter = sCurrentPrinter End Sub I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi Sir, First of all a big thanks to making very powerful training videos for us. Sir request you to please release a short video for add and save a pdf file in vba excel. Thanks
very well explained, Awesome Video for the beginner. this is my first time coding on VBA but it went well with your help. i was able to create a different set of variables which works well on my new project. Thank you so much.
Thank you so much for the tips and explanation. I'm having trouble with the line "OpenURL", it says its a compile error: sub or function not defined. Any work-around this?
Thanks for your training. This is super helpful. I have one question- let’s say there are some checkboxes on the fillable PDF form, and I have yes/no on the excel template. What language should I use in this case?
Hi Helen, thanks so much for your message. In a PDF generally the space or spacebar is used to select a checkbox and a Tab is used to skip it. So you can add something like this If .Range("N" & CustRow).value = "Yes" then Application.SendKeys " ",True Else Application.SendKeys "{Tab}", True You can just adapt it for your workbook. I hope this helps and thanks so much.
Excellent video explaining this, however I have a question. If a person updates an appointment date in the excel list can you set it up to only print the updated changes to the list or filter it to the changed date and then print the pdf?
Hi and thanks so much. Yes it is certainly possible if we know the field that was changed in the form. For example, if the 7th field was changed in the form, we can tab through the form 6 times and then on the final tab we can update the field. I hope this helps and thanks so much.
Hi and thanks for your comment. I did this training nearly 7 years ago so i am not sure of the code, however please post your detailed question in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi and thanks. You do not need to use OpenURL, you can use ThisWorkbook.FollowHyperlink instead and it will work properly. (Please see instructions in the description above) I also have an updated video to show you how to do this here: ruclips.net/video/6fot1T_g1dM/видео.html
@@ExcelForFreelancers Yes, after researching few hours internet I found it and Foxit reader solved many issues. Thank you so much. You are a Great teacher ❤️
@@ExcelForFreelancers I want to ask one thing. Why when we enter%,(),- these symbols cant export to pdf form? Any special format do we need to set? Thanks in advance 😊
Hi and thanks its best to replace any symbols that can't be used in a file link with an underscore Something like FileName = Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(FileName, "", "_"), ":", "_"), Chr(34), "_"), "/", "_"), "\", "_"), "|", "_"), "?", "_"), "*", "_") I hope this helps and thanks.
@@ExcelForFreelancers Hi, really appreciate your replies. Yesterday I struggled with, how to export % symbol to pdf form. Then found a way. If we use {%} like this it will appear in pdf form without curly brackets. Just to share my experience. Have a nice day.
The Newer Adobe Acrobat DC pro has an additional Save as Screen. If you use Ctrl+Shift+s it opens to a preview screen and you have to click on "Choose Another Folder" to actually get to the "Save As" dialog box. What would be the send command to go directly to the "Save As" dialog box?
I tried this method, but what happened is VBA sent command location without special characters ( ":" and "\") and it ended up becoming the file's name. i would like to hear this solution too.
HI Tina, thanks for your comment. Even with newer versions of Adobe there is still a keyboard process to achieve what you want to do. So first you want to map out all of the steps, before you code it in VBA. I walk you through the process in this newer video here: ruclips.net/video/6fot1T_g1dM/видео.html I hope this helps and thanks.
HI Vibrol, you want to make sure to replace any special characters in the file name with perhaps an underscore. So use the replace command to do this such as FileName = Replace(Replace(FileName,":","_"),"\","_") This way you won't have any issues saving files when those file names contain those characters. I hope this helps and thanks.
Thank you so very much, I really appreciate that. Make sure you to catch my latest series "School Manager" in which I am creating an entire application from scratch in a multi-part series here: bit.ly/SchoolManagerSeries
@@ExcelForFreelancers thanks a lot. I am facing an issue with OpenURL function. It is giving an error when runnind it. Any advice on how to resolve this issue? [OpenURL "" & PDFTemplateFile & "", Show_Maximized] this is how i am writing it. do i need to define this function. Thanks a lot for your support
Hi and thanks. Do not use the Open URL but instead use: ActiveWorkbook.FollowHyperlink Address:="" & PDFTemplateFile & "" You can find this solution in the downloaded workbook as well. I hope this helps and thanks so much.
Hi! Thank you so much for the video. I am having some problems with OpenURL, it returns the error: Sub or function not defined. ¿Do you know which can be the problem?
Hi Sonia and thanks for your comment. You can replace OpenURL with ThisWorkbook.FollowHyperlink instead. You can also download my sample workbook which has this as well using the links in the description. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi, is it possible to Auto populate the form with a selected row only? Not every row at the same time, just specific ones. Thank you for all this lesson! Really great for beginners.
Hi Beitriss, Thanks for your comment. You can run a For / Next Loop from the first row to the last row, then for each row you can use an If/ Then statement to see if a row meets your requirements. if it does you can fill the form, if it does not, you can skip it. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
This is one of the best tutorials I've ever seen. I ust have one question. The complier doesn't like the "Show_Maximized" on the OpenURL Line. Is there a way around that?
Hi and thanks, yes there is a great alternative I should have used. You can use the ThisWorkbook.FollowHyperlink instead I hope this helps and thanks so much.
Hi and thanks. Once the hyperlinks are removed in cells, the pop-up should no longer appear. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
This is really nice but I have one question @ExcelForFreelancers. If the Excel file is constantly adding new info collected what would be the code? Is it possible to get the new added info only to PDF? Please I really need this
Hi and thanks so much. In any cell you can store the 'last row added' so that the next time the macro runs, it checks for new rows, and starts from the last row added + 1, this ensures that only new data is added. I hope this helps and thanks so much.
Hi, I'm a complete newbie to VBA and getting a compile error: sub or function not defined error when we get to the initial test to open the PDF. It seems to not like the OpenURL function and was wondering if you could give me any pointers please. Thanks for a great video though
Hi and thanks very much. I am glad you liked the training. Actually, OpenURL was my fault, as this option does not work on every computer, and I should have gone with another statement. Please try ThisWorkbook.FollowHyperlink PDFTemplateFile This should work. Thank you for your Likes, Shares & Comments. It really helps.
Thanks for this incredible guide. Is there a code for using "save as" instead of "print"? I tried using "^+(s)" for coding "save as" and prompting acrobat to open the save as window but the rest of the code doesnt work propertly, sendkeys {enter} doesnt correctly work as it taks a while for the code to execute enter, then on the saving window where you choose the file destination, the rest of the codesending the destination folder and file name doesnt work. Hopefully you can aid me here. Thanks again for this tutorial!
HI and thanks you will want to double check your shortcut keys and add in additional wait statements so you can follow what is going on in the code. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Thanks for the video. great job. I have a question tho. Is it possible to create a button for each row that creates a PDF file with just the information on that row, instead of making PDF files for all the rows in the worksheet?
Hi and thanks. Yes sure it is possible. You can duplicate the macro and instead of looping through the rows you can assign a variable to the selected row and use only that. I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you for the reply. I'm really new to this and i have no idea how to do that. And i'm having no luck searching it online. Is there a video of yours that helps with this problem?
Hi and thanks so much. These are intermediate to advanced VBA techniques. You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBADiscount_Randy
Hi and thanks so much PDF"s can be opened in a mobile OS, however Excel with Macros only runs on Desktop versions of Windows and Mac. I hope this helps and thanks so much.
Love the video overall! I did have a couple of questions though: 1) Do you have a video explaining the PDFTemplate and SavePDFFolder code? I can an error when copying and running it (double-checked and I don't have typos)? 2) On a Mac, I get an error when trying to insert a pdf as an object that says "Alert Cannot Insert Object", any idea what's going on? Thanks!
Hi Jay and thanks so much. Mac's are very limited when it comes to VBA and Excel, so it is always best to use a PC. Here are some workarounds when using a Mac Https://www.macexcel.com/ I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi, very great tutorial, thank you so much! I have one question. Would it be possible to have VBA remove certain text directly from the PDF if a certain column value is empty?
Hi and thanks, most likely you can if it is a fillable pdf. If you can do it with your keyboard, then you can use Sendkeys to mimic the behavior of the keyboard. I hope this helps and thanks so much.
HI and thanks, checkboxes are generally filled with a space or a spacebar command, You can use sendkeys with a " " which should fill in the checkbox. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi Thanks for this Tuto which seems to respond to my search on how to automate Filling PDF Form with VBA, I tried it but can't use OpenURL, maybe I need to reference a library I coudn't find ?
HI please use FollowHyperlink (See description above for details or download the free file using the links in the description) The downloaded file has the correction. FollowHyperlink will work without issue. Thanks very much.
@@ExcelForFreelancers Thanks, I received the files and tried to run the updated Excel, The FollowHyperlink works properly. But the fields are not filled correctly (City in Fisrt name, State in Las Name, ... Mail splitted between Address (John) and City (@gmail.com) ... . I wonder if there is a way to position the starting offset in an other manner than the fiste {TAB}. Thanks very much, JF Denes
Hello Sir. Thank you for a well put together tutorial. I am stuck at saving the individual files. How would you write the SendKeys for Ctrl+Shift+S? I am trying to bypass the printing to PDF section
Hi Mark, thanks for your email. You can write SendKeys.Send("^+{S}") I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel Thank you for your Likes, Shares & Comments. It really helps.
Hi I was able to get the vba code to work however I am needing to fill out 2 pdf pages. The code works perfectly on the first file but once the first loop finishes and the second one starts, the loop begins on page 2 instead of page 1. What code could I use to get the loop to start on page 1?
Hi Jasmine, thanks for your comment. You would have to determine the shortcut key to 'clear the form'. Almost all PDF applications have a clear form feature. Once you determine what that is, you will put it into the sendkeys. Once cleared, it should then start at the beginning of the form once again. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Great video and tutorial. I used this to print the pdfs, now I would like to write a code to email each pdf that was created. Do you have a video that explains that? Thanks!
By the way, I've never heard of VBA before watching your video. I knew that I had a problem and knew that there had to be a solution. This video explained how I could accomplish that. I had to change a few things for my specific application, but the general guidelines that you provided allowed me to do that. When I told coworkers in IT what I was doing, they laughed and said good luck.
Hi and thanks so much. To email PDF's you can watch this video: ruclips.net/video/qeQmrADtFjw/видео.html I hope this helps and thanks so much for your continued support
This is great, thank you so much! I have a question. Do you have a suggestion for doing this with data that comes from a web form that was submitted instead of the data being in the rows in the video?
Hi and thanks very much. It should not matter where the data comes from. As long as it is imported into your worksheet it should work fine. I hope this helps and thanks so much.
Hi and thanks, I have a series on importing data that will help here: ruclips.net/p/PLIBeRriXvKzAFEKvn0PUTyYpnluDmeQTR Thank you for your Likes, Shares & Comments. It really helps.
I have a question please. If I am putting 3 bits of data City, State, Zip into the same field in the PDF document, how do I write that in the VBA code?
Hi and thanks, assuming you want to put the address in Cell K8 and the address information is coming from columns D, E & F in a database sheet you could do something like this Range("K8").Value = DBSht.Range("D" & RecRow).Value & ", " & DBSht.Range("E" & RecRow).Value & " " & DBSht.Range("F" & RecRow).Value 'Full Address I hope this helps and thanks so much.
Hi and thanks you can use FollowHyperlink instead of open URL. You can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Amazing tutorial. Succinct and useful. I see you'd have to set you default printer beforehand, but that's easy enough to do when this is saving you so many keystrokes. Thanks for a great tutorial with downloads.
Hi and thanks you can step through the code using F8 to see which line of code is causing it. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Thank you, extremely usefull and enlightening. I am kindly asking for your help though. I want the vba code to fill my pdf form only from the selected row (not to E999). It's been days trying to tweak the code, but apparently I am missing something. Could you be so kind as to help me out? Thank you in advance!
Hi thanks for your message. I have been focused on creating some amazing Excel courses for all Excel enthusiasts so I am unable to offer any one on one support at this time, since I get literally hundreds of request for help per day. However, I have created a Facebook group with 30,000 Excel Experts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: bit.ly/groupexcel. This way we can get you the answers you need, fast.
@@ExcelForFreelancers Thank you very much for your quick answer to my inquiry. Very much appreciated! I will join your FB group, in the meanwhile keep up the wonderfull work you are doing!
Superb video. I throughly enjoyed it. I do, however have a question for you. Is there a way to be able to add in information, say for instance if I am creating a resume in word and I have a template set, would there be a way for a person to keep the current record and add to it automatically without having to create new code, like adding a new job history?
Thank you for the video, im trying to test the save function with the Macro idential to yours, it's giving me the compile error, "label not defined". what am i doing wrong?
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@@ExcelForFreelancers thanks, just rqueted to join... also liked and subscribed thanks again and also kudos for taking the time to answer a comment on a video you posted 6 years ago, even tho its a new comment!!
Hi Randy, Thank you so much. I do have a question.. sorry for the lack of vba knowledge What if the all the data in excel Is in the same column compared to different Columns as in the video . Which part of the code should I change? Eg. Column A = “all the headers as per the video” Column B = “ add the data” Please let me know. Thank you as always... 🙏
Hi Avi, I have not memorized the code in each workbook so I would not know what you are referring to. Pleas make sure to create a post and upload all code screenshots in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel Thanks very much
HI Dr. Fail, I have create a group of over 1800 Excel experts to give advice and help on nearly any excel problem. So please join and post and we will do our best to help you. Here is the group link: bit.ly/groupexcel
Thank you for your very comprehensive programme. I am having a problem however where my pdf generated file cannot be opened in Adobe Acrobat Reader because it is not a supported file type or the file has been damaged. Can you please offer some advice?
Hi can you try the free Foxit Reader application. I love that one and its worked well for me in the past. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Thank you for your response. Just to let you know that I am very new to using vba, but discovered that if I opened Adobe prior to running your programme, then the pdf files that are generated can be read in Adobe Reader DC. Keep up your awesome work
Awesome tutorial! On SaveAs the "full" name is not entering in the address bar, it is trimming the directory location and part of the file name from the from of the address, and then the job fails. I can manually enter the address and the save as works fine, any help you can provide would be awesome.
Hi and thanks, please slow down the code by adding additional time to the Wait Now command. This will increase the time in which VBA adds to placing the full file path in the field. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@@ExcelForFreelancers I have a 20 second delay, and still have issues...and it is trimming the front of the string...not the end. I see in another reply that you said an API may be necessary. That would definitely take it out of my pay grade. :)
I figured out my issue, and thought I'd share. I was using the following send key: Application.SendKeys "{Enter}", True This uses the numeric enter key, and was not working for me. I then tried: Application.SendKeys "~", True This uses the keyboard enter. One note, make sure to not use the brackets around the tilde as that doesn't work.
Wow! Incredible video. I can see many applications for your coding. With a few changes from patient information into financial modeling I can visualize an incredible for reporting potential profitable projects. Thank you very much for this invaluable lesson/tutorial. Ruben
In the sub Create PDFForms... you specified ''With Sheet1'' so you wouldn't have to reference if over and over again.. is there way to keep it simple in the macro's code if the table with the patient's information is on sheet 1 and the buttons for the macro on sheet 2?
Hi Oliver, thanks for your comment. There are several ways you can reference a sheet, you can also Dim and set a sheet such as Dim Ws as workheet Set Ws = ThisWorkbook.Sheets("Sheet1") then you can just refer to Ws within the code. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@@ExcelForFreelancers That helps a lot thank you!! I joined the facebook group and your videos officially got me interested in writing my own scripts in Excel!!:D Your explanations are much easier to follow and extrapolate than what I've read in books so far..! Cheers!
Thanks so much. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
Hi! My first time automatically filling in a pdf form using excel. I'm at the beginning when you put OpenURL "" & PDFTemplateFile & "", Show_Maximized....the show maximized does not come in a drop down item for me, when I click run I get an error Compile error variable not defined, when I click ok then the Sub CreatePDFForms() is highlighted. Am I missing an object under my reference and tools. Mind providing what reference tool objects are used for this? Thanks for your help!
Hi Cynthia, thanks for your comment. You can try this ThisWorkbook.FollowHyperlink PDFTemplateFile I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Amazing! Thank youe very much for this video. But i have a questions: You made 10 records at once. If, for example, I add a new data record every half an hour (another line, i.e. a new patient) and I want to print it out immediately afterwards. How can I solve this? So I would like to expand the list steadily and print out the expansions one by one. Thank you very much !
Hi and thanks very much. You can run a macro on a Worksheet Change event so that anytime a new record is added the macro will run and print. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Awesome video. As I was following along I went to test my open PDF line and it would only open in a certain PDF app. I tried changing the default app on my computer but it still only opens that one. Is there a way to designate which app is opens the PDF with? Thanks in advance!
Hi and thanks so much. I saw your post in our group and Rob commented correctly on how to change the default program to open PDFs. You may want to restart your machine for this change to take effect. I hope this helps and thanks so much.
Tank you for this video, it's quite helpful! I'm just having a problem, I'd really appreciate if someone could help me out on this, (I'm too new to VBA): When the loop continues to the second row it doesn't replace the new text, instead, it writes after the previous, how can I fix this? Thanks for your time!
Hi Carlos, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much. Also if you are new to VBA I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
Thanks so much for this useful guide! I have one issue when trying out this method and I hope some folks might be able to help me out. In cases when I accidentally navigate myself to another window while the macro is still running, is there anyway that the macro can automatically break when it happens? There have been times where I accidentally click on another window with the macro still running, Sendkeys continues to mess up the contents of whichever windows I am at. Using the Ctrl+break shortcut wont work as it immediately registers the key in the Sendkeys, and also some of the devices I am using does not have a break button. Does anyone has similar issues and have found a solution? Any suggestions would help! Thanks in advance.
I think you could perhaps check the active window and see if it is Excel and if it is not then exit the sub. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@@ExcelForFreelancers thank you for the suggestions, however I couldnt manage to find much useful information on how to determine whether the active windows is Acrobat reader or not, maybe you could give a an idea on which VBA property that I can use? Thanks in advance
First, thanks for this very helpful video! Second, a question. I have customized what I need to and it runs perfectly, however I need it to save as a PDF (not print to PDF) because it is a fillable form that needs to remain fillable after being saved. I've adjusted the code to run a "Save as", and have gotten it to the point where the dialogue box opens and it needs to enter the file name, however, it does not change the filename from the template, so it does not go any further. Any ideas on how I can get that filename field to populate correctly?
Hi Ruth, thanks for your comment and question. For the PDF to remain a fillable form you will want to use the API associated with the PDF. You can try this training which includes fillable PDF's as well: ruclips.net/video/6fot1T_g1dM/видео.html
Hi and thanks so much. Perhaps you can use the character equivalent in VBA which is Char(43) in the ASCII code I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
🎄 𝗦𝗮𝘃𝗶𝗻𝗴𝘀 𝗔𝘀 𝗕𝗿𝗶𝗴𝗵𝘁 𝗔𝘀 𝗖𝗵𝗿𝗶𝘀𝘁𝗺𝗮𝘀 𝗟𝗶𝗴𝗵𝘁𝘀 - 𝗨𝗽 𝗧𝗼 𝟱𝟱% 𝗪𝗮𝗶𝘁𝗶𝗻𝗴 𝗙𝗼𝗿 𝗬𝗼𝘂! 👉 www.excelforfreelancers.com/XmasSale2024_YTPinnedComm
Not a single unecessary word said in this 42 mins long tutorial! Simple, professional, useful, I cannot thank you enough! Keep it up!
Thank you Michal, I really appreciate that, I look forward to making unique and exciting videos each and every week.
Except for he starts somewhere other than the beginning of the process. How did he get the Acrobat values (PDF TEMPLATE) into an Excel spreadsheet? That would be a better stating point instead of the 10 stories off the ground he choose to start from!!
Normally never comment on a video. Was trying to automate this process using the JSObject and couldn't for the life of me get it to work. Wish I had seen your tutorial before going down that rabbit hole. The applications for this are boundless. Bypassing the APIs and going right to simple inputting the data like a user would is genius.
Thank you so much for posting this video.
For sure, you are very welcome Dennis and so great to have you here. Much appreciated.
I haven't seen a programming video that was so straight forward and easy to understand. Great job!
Thank you so much Derek, I do appreciate that. I know some of my videos are more complex. I will try to keep them as simple and straightforward as possible. Love the feedback.
Absolutely fantastic. I have been doing copy-paste for years. Completely soul killing but no more. Works perfect!
Awesome. I am happy to help and share. Thanks so much
I'm very thankful to people like you who explain complicated Excel tricks or macros in a very understandable way. I am learning a lot. Much thanks!
Thank you very much. Glad I could help.
What a beautiful, simple way to automate this process. Thank you for creating this video and saving us all countless hours!
HI Andre thanks so much. I have another one I recently did that is simpler and you may enjoy it here: ruclips.net/video/qeQmrADtFjw/видео.html
Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Subscribed! Thank you Sir!
Thanks so much Andre :)
I'm not one to comment on videos, but this has been SUPER helpful! I have never done anything with excel or VBA before and this was a knockout explanation. I'm hoping to cut down manual input and boost continuity within our office and this might just be the perfect fit!
Thanks so much Jacob, I am really glad you enjoyed this and I appreciate your comments. I have another ones along the same lines as this in which you may find helpful right here: ruclips.net/video/6fot1T_g1dM/видео.html
Thank you for your Likes, Shares & Comments. It really helps.
You must consider setting up a Patreon account. I'm sure many of us would consider supporting your great content - has helped me a LOT in the past.
Thanks so much Noel. I will be setting up a shop so you can purchase some small Excel items (mugs, shirts, etc) I also have some products and courses you might be interested in here: www.excelforfreelancers.com/products-in-excel/
Thank you for explaining what each step does and for the apostrophe tip! When I run the first check (around 14:10) I keep getting: Compile error: Sub or Fucntion not defined, for the OpenURL "" & PDFTemplateFile & "", Show_Maximized. I re typed the code from scratch numerous times but it keeps popping up.
Hi and tahnks, instead of the OpenURL line you can use
ThisWorkbook.FollowHyperlink PDFTemplateFile
I hope this helps and thanks so much.
@@ExcelForFreelancers Had the same issue as above, this fixed it for me Thank You!
I’m having the same issue. But I can’t get the follow hyperlink to work either
VBA has always been super intimidating to me. This video may be the best tutorial I have ever watched. The explanation was top notch and I definitely feel like I have the tools to apply this to my cases. Thank you so much.
WOW. That is really amazing. I am super happy to help and share. I also just started a new weekend series on VBA For Beginners, with a new video every weekend. Thank you for your Likes, Shares & Comments. It really helps.
HUGE THUMBS UP I had 1000+ forms that needed to be created, you saved me weeks of work!!!
That is FANTASTIC To hear. I am so glad I could help.
It works perfectly. Only use "Enter" instead of "Safe". Many thanks.
R.C. de Jonge OK Excellent. Glad to hear that you got it working
First Excellent video on programming VBA. Cool tips, excellent explanation. Easy to understand. I will be happy to subscribe!
Thanks so much. I do appreciate that. I will only email you new weekly videos on Tuesdays. I won't be spamming :) (also some people have trouble with emails so automated facebook chat works well too, to get your downloads and to get weekly new video announcements)
Another worthy tip for anyone interested, one of the reasons why SendKeys is discouraged is because with this methodology, it sends the keystroke to what's the active window, which can be disastrous for your macro. To that end, be sure that you enable focus on the application you are sending keys to.
Thanks for the great suggestion Kelvin. I appreciate your comment.
@@ExcelForFreelancers You are quite welcome
Hi, I am a beginner and I am getting Compile error: Sub or Function not defined for 'OpenURL' as part of the first run around 14:00 mins of the video
Hi and thanks for your comment. Instead of OPenURL please use ThisWorkbook.FollowHyperlink instead. Please see my sample. You can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
@@ExcelForFreelancers Awesome! This is where I was getting stuck as well. Thanks Randy!
You are a great teacher! Just wanted to point out that VBA doesn’t allow you to declare a group of variables to be a particular data type by separating the variables with commas. For example, though valid, the following statement does not declare all the variables as Integers:
Dim i, j, k As Integer
In this example, only k is declared to be an Integer; the other variables default to the Variant data type.
Hi and yes, thanks so much. IN all of my newer videos I declare variables properly. This was a bad habit I got rid of a while ago. Thanks so much.
you explain office products better than Microsoft it slef thanks so much sir .
Thank you very much. I really appreciate that. :)
Hi, I am very new to VBA. how do I create the initial macros at 3:26? Do you have a video link for that? Greatful if you could assist.
Hi and thanks so much for your comment. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
@@ExcelForFreelancers Thanks for responding! I have a long list of clients for whom I am trying to populate individual forms. I have an excel sheet with the names and a pdf form template. The only difference with my pdf template is that it is fillable with dropdown options as well. I wish to keep the layout of my pdf template. I would be happy to speak with you off this public domain, if possible?
Hi and thanks. The application is open and you are welcome to customize this to fit your exact requirements, however I am unable to take on any projects of my own. If you would like some help with this, we have a group with 40,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet)
You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project.
I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you.
Can you help me openurl statement ?
when I put OpenURL "" & pdftemplatefile & "", Show_Maximized
show maximized gives compile error: variable not defined.
This erroe it gives on show_maximized highlighted
Hi thanks you will not want to use OpenURL (this was not a good idea by me) You an use Application.FollowHyperlink pdftemplaefile
You can also download my copy, which has the FollowHypperlink code, using hte links in the description. (i hope this helps)
Excel For Freelancers now it shows Run-Time error ‘438’, Object doesn’t support this property or method...
@@rifaaabdulwahid try typing:
ActiveWorkbook.FollowHyperlink Address:="" & PDFTemplateFile & ""
That seemed to get it working for me.
Never seen detailed tutorials with a wealth of knowledge like yours sir. Excellent!
Thank you so much. I really appreciate that.
Really excellent tutorial, for some reason when it comes to the save step it doesn't open on the screen but sits in the task bar
Any ideas?
Thanks and I am glad you like it. I would try save the file using just your keyboard only to see what shortcuts are required, then you can transfer that shortcut to VBA using sendkeys
@@ExcelForFreelancers One last question, can the filled pdf be saved directly to a folder instead of going through the print phase?
@@wadepritchard1283 in case nobody replied to your question after a year, one of his other video has exactly that. Use sendkeys for ''save as'' instead of ''print'' and keep the process the same
Your designing is out of this world.
Thank you so much Imran. I apprecaite that.
This is fantastic. It really opened my eyes to the possibilities of interaction between excel and other applications. Keep up the great videos. Do you know if there is a way to use sendkeys with formatted font options instead of just black... i.e. red, or bold ...or both. Thanks.
Hi and thanks so much for your comment. SendKeys can be used perhaps you can if you use the same keys for the formatting however it does depend on the host application and how they determine the formatting.
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Novice / moving into intermediate territory Excel user here. Subscribed! Thank you very much. Cheers
Thanks so much. Really great to have you on board. :)
Thank You.....Sir
For sure u are welcome
You are welcome
I appreciate this video! Great work. A suggestion would be to slightly alter the code so that instead of writing a new PDF file each time, that instead, you save the template with the patient-appt date file name. That way, the form-based PDF could be forwarded to the patient for them to fill in any blank fields, and more importantly, give them the ability to edit any fields that might have incorrect information. OOPS - I just read the comment from Ruth Block a few comments back - and your reply that answers this need!
HI and thanks so much. I am glad you were able to get the solution. Since this video i have had a lot more ways to fill in pdf's, including this one ruclips.net/video/wI6nFlq9CS8/видео.html
I hope this helps and thanks so much.
SO far nice but I cant for the life of VBA get it to open the predefined file with OpenURL or Thisworkbook.FollowHyperlink :(
Hi you can use ThisWorkbook.FollowHyperlink along with the variable, and you also should check the long file name to make sure its correct. Thanks so much.
You are doing service to human kind in a way, thank you sir .
Thank you so very much, I really appreciate that.
Thank you very much! You have saved me a lot of time. I need to prepare 250 pdf documents. I will continue to learn from you, I love it!
For sure, you are very welcome, I am really glad I could help.
Excel For Freelancers:
Thank you SO much for your useful tutorial! First time tuning into your channel and have subscribed! This solution proves very useful as I am filling out multiple PDF forms for multiple individuals! Thank you again! Keep up the great work! Be Blessed
I am glad you got it working. Thanks very much.
Great tuts here Randy.
Btw, I was reading all the comments to find out whats the hot key for or the work around for Radio butttons with a yes, no and other options. Thanks Randy.
Hi Deither, usually its the spacebar to check/uncheck or select/unselect these options. (you can try it with your keyboard on your pdf)
You would then use an If Then statement within VBA to see if a check is necessary and if so use a space such as
If sheet1.range("A1").value = True then
Sendkeys " "
Sendkeys "{TAB}"
Else:
Sendkeys "{TAB}"
End If
Perhaps something like that. I hope that helps and thanks.
I know that this is an old video but it's new to me. Excellent. I've been using and programming apps on Excel for a while and I learned quite a few things on this video. I'm going to test this form right away.
Hi JG, Thanks so much. I was just thinking to redo this video next week but to add more 1) Start with a form that is not fillable, and also do it from scratch, starting with a blank worksheet. So it would go from: Static/Scanned in PDF > Fillable PDF with Fields > Automatically Add in Data from a table > Email, Print, Save the form
All from scratch. What are your thoughts?
this was one of the best tutorial I have ever seen. one question is that once all the data is created, how would you make the last row to be entered since all other rows are filled. a new customer comes and we want only create a file for the last customer
HI and thanks so much for a new customer you would assign the first available row, such as
CustRow = Sheet1.Range("A99999").end (xlup).row + 1
I hope this helps and thanks so much.
I just saw this video from five years ago and I can actually keep up. It would seem that Randy has gotten faster and faster over the years! 😂
Thanks so much, I appreciate that. It was one of my first. Hopefully not too fast. Thank you for your Likes, Shares & Comments. It really helps.
Great video, it helped me out so much. I have a question about the file if it already exists. What text would I replace "Kill" with to instead "Overwrite"?
H and thanks so much. You can use FileCopy OriginalPath, DestinationPath
The destination path would overwrite the existing file. Make sure the existing file is in a closed application and not open on your desktop.
I hope this helps and thanks so much.
I am thrilled by your teaching. Thanks for the valuable teaching
You are most welcome Bhai. Thank you for your Likes, Shares & Comments. It really helps.
Is there a good way to modify this so it combines the created forms together?
Hi and thanks for your comment. I am sure this can be completely customized for your requirements. If you need help with this, I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com
Thanks so much.
This is not exactly what I need it but gave me ideas to solve my issues. It worked. You're awesome! Thank You. (Liked & Subscribed)
Great, thanks so much and I am glad I could help and share
Very helpful and encouraging explanation. I have a question. Think that I have a PDF form that has checkbox or radio buttons (Like GENDER- Male / Female or EYECOLOR - Brown/Blue/Hazel /etc), how should I format related cells in excel without adding check-box or radio button in each cells for each record. If just enter "X" or any other character in related cell, how would it convert to a tick or X in pdf form?
Hi and thanks very much. The Spacebar is used to check radio buttons or checkboxes, so you can use something like this
If .range("M" & ContRow).value = True then 'Checks a condition to see if its true
SendKeys " ", True
SendKeys "{TAB}", True
Else 'Tabs through without checking
SendKeys "{TAB}", True
SendKeys "{TAB}", True
End IF
I have not tested this code but it would be something like that.
I hope this helps and thanks so much.
Thanks alot@@ExcelForFreelancers
I am having troubles with the first PDFTemplate macro you have here at 3:03 on my mac. When attempting to run this, I am receiving the message: "Run-time error '91': Object variable or With block variable not set". Any ideas how to resolve this?
also, when I click "Debug", it highlights the row that contains " .Title = "Select PDF file to attach" " in yellow.
HI and thanks. If you are trying to run this on a Mac, the browse for file is slightly different. You can find the code updates for that here www.macexcel.com/
If not, you can also post your issue in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 60,000 Members who would love to help you with this. Thanks so much.
This was very helpful! I saw your response to a comment below regarding check boxes. What do you recommend for radio buttons in the PDF form? If I am only using keys to fill out the form, it only switches between radio buttons using the left and right keys, so I am a little lost. Thanks!
Hi and thanks so much for your comment. You can use an If/Then statement, based on your data.
Something like
If .range("A" & CustRow).value = True then
SendKeys "{LEFT}" , True
Else
Sendkeys "{RIGHT}", True
End IF
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Thanks for sharing valuable knowledge.
I have a question I am preparing the invoice form in acrobat but I have the product list and there prices. I want to link with Excel file to pdf and when I update the prices than pdf form also update these prices of the product
Hi and thanks so much for your comment. You can print the invoice in PDF format and replace the existing one with a new one. I show you how to do that in this video ruclips.net/video/eF678YvQ93g/видео.html
I hope this helps and thanks so much.
I can't begin to explain how helpful this video has been!!! Thank you so much man!!! You are a gem! Kudos!!!!
However, I have one issue. I would be really really grateful if you could please share the coding for someone using Mac instead of Windows! PLEASE RESPOND. THANKS. I AM WILLING TO PAY TO CHANGE THE CODING FOR MAC
HI and thanks, I would hope Mac's would be the same, however since I do not have a Mac here to test on, I can't be sure. However there is no doubt we can help you with that.
Can you post your question in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 50,000 Members who would love to help you with this. Thanks so much.
Thanks for your response. I will post on the Facebook group then ✌️👍
learned alot on using the sendkey command. thanks
That is great to hear Vince. Thank you for your Likes, Shares & Comments. It really helps.
Thank you for saving 10 people 4 hours of their day!
For sure, you are very welcome and I am happy to help and share.
Hello, when i run OpenURL "" & PDFTemplateFile & "", Show_Maximized. (around 14:10) I keep getting: Compile error: Sub or Function not defined, for the OpenURL "" & PDFTemplateFile & "", Show_Maximized. ive tried different ways including ThisWorkbook.FollowHyperlink PDFTemplateFile but it still doesn't run correct and tells me method FollowHyperlink of object _workbook' failed. could it be im running it on exel office 365?
Hi and thanks for your comment. Instead of using OpenURL use ThisWorkbook.FollowHyperlink PDFTemplateFile.
I hope this helps and thanks so much.
While an older video, it is new to me and absolutely stunning! It helped me immensely! Is there a way to alter the code into a separate macro that would allow you to do the same thing but for an individual row based on a data validation drop down? Such as if this amazing program has already run, but you would update new/existing users into the table and would then only need to have it run for a specified user?
Yes sure, you can add an if/then statement based on your criteria to validate, as you loop through the data. I hope this helps and thanks so much.
Hello. Excellent tutorial. I have one question. Is it possible to specify which printer to use with VBA code? I want to use "Microsoft Print to PDF." If I've recently printed with my physical printer then it sets that physical printer as the default and I don't want to set print to PDF as the default for me entire computer. Thoughts? Thanks!
Hi Patrick, Thanks for your comment and question. You can print to a specific printer using some code such as this
Sub MyPrint()
Dim sCurrentPrinter As String
Const MyPrinter As String = "Lexmark E350d"
sCurrentPrinter = Application.ActivePrinter
Application.ActivePrinter = MyPrinter
ActiveSheet.PrintOut '
Application.ActivePrinter = sCurrentPrinter
End Sub
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi Sir, First of all a big thanks to making very powerful training videos for us. Sir request you to please release a short video for add and save a pdf file in vba excel. Thanks
Hi and thanks i have that coming up in next weeks video so make sure to stay tuned. Thank you for your Likes, Shares & Comments. It really helps.
very well explained, Awesome Video for the beginner. this is my first time coding on VBA but it went well with your help. i was able to create a different set of variables which works well on my new project. Thank you so much.
Thank you very much Mohammed I am really glad you liked the training.
Thank you so much for the tips and explanation. I'm having trouble with the line "OpenURL", it says its a compile error: sub or function not defined. Any work-around this?
HI and thanks so much. Instead of OpenURL, please use ThisWorkbook.FollowHyperlink pdftemplatefile
I hope this helps and thanks so much.
Thanks for your training. This is super helpful. I have one question- let’s say there are some checkboxes on the fillable PDF form, and I have yes/no on the excel template. What language should I use in this case?
Hi Helen, thanks so much for your message. In a PDF generally the space or spacebar is used to select a checkbox and a Tab is used to skip it. So you can add something like this
If .Range("N" & CustRow).value = "Yes" then Application.SendKeys " ",True Else Application.SendKeys "{Tab}", True
You can just adapt it for your workbook.
I hope this helps and thanks so much.
Really love your videos tutorials. very easy to follow even for a person without VBA knowledge like myself.
Thank you so much Panida, I am really glad you like it. Much appreciated.
@@ExcelForFreelancers Can I ask whether you have vba that can help me search and select existing data?
Excellent video explaining this, however I have a question. If a person updates an appointment date in the excel list can you set it up to only print the updated changes to the list or filter it to the changed date and then print the pdf?
Hi and thanks so much. Yes it is certainly possible if we know the field that was changed in the form. For example, if the 7th field was changed in the form, we can tab through the form 6 times and then on the final tab we can update the field. I hope this helps and thanks so much.
Please can you help me with the code for „NoSelection” and „NoSel” macro. Thanks for the help.
Hi and thanks for your comment. I did this training nearly 7 years ago so i am not sure of the code, however please post your detailed question in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 60,000 Members who would love to help you with this. Thanks so much.
14:16 Why this OpenURl function is not working in my Excel VBA environment? Can you help me to solve?
Hi and thanks. You do not need to use OpenURL, you can use ThisWorkbook.FollowHyperlink instead and it will work properly. (Please see instructions in the description above) I also have an updated video to show you how to do this here: ruclips.net/video/6fot1T_g1dM/видео.html
@@ExcelForFreelancers Yes, after researching few hours internet I found it and Foxit reader solved many issues. Thank you so much. You are a Great teacher ❤️
@@ExcelForFreelancers I want to ask one thing. Why when we enter%,(),- these symbols cant export to pdf form? Any special format do we need to set?
Thanks in advance 😊
Hi and thanks its best to replace any symbols that can't be used in a file link with an underscore
Something like
FileName = Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(FileName, "", "_"), ":", "_"), Chr(34), "_"), "/", "_"), "\", "_"), "|", "_"), "?", "_"), "*", "_")
I hope this helps and thanks.
@@ExcelForFreelancers Hi, really appreciate your replies. Yesterday I struggled with, how to export % symbol to pdf form. Then found a way. If we use {%} like this it will appear in pdf form without curly brackets.
Just to share my experience. Have a nice day.
The Newer Adobe Acrobat DC pro has an additional Save as Screen. If you use Ctrl+Shift+s it opens to a preview screen and you have to click on "Choose Another Folder" to actually get to the "Save As" dialog box. What would be the send command to go directly to the "Save As" dialog box?
I tried this method, but what happened is VBA sent command location without special characters ( ":" and "\") and it ended up becoming the file's name. i would like to hear this solution too.
HI Tina, thanks for your comment. Even with newer versions of Adobe there is still a keyboard process to achieve what you want to do. So first you want to map out all of the steps, before you code it in VBA. I walk you through the process in this newer video here: ruclips.net/video/6fot1T_g1dM/видео.html
I hope this helps and thanks.
HI Vibrol, you want to make sure to replace any special characters in the file name with perhaps an underscore. So use the replace command to do this such as
FileName = Replace(Replace(FileName,":","_"),"\","_")
This way you won't have any issues saving files when those file names contain those characters.
I hope this helps and thanks.
amazing description and walk-through process. highly recommended
Thank you so very much, I really appreciate that. Make sure you to catch my latest series "School Manager" in which I am creating an entire application from scratch in a multi-part series here: bit.ly/SchoolManagerSeries
@@ExcelForFreelancers thanks a lot. I am facing an issue with OpenURL function. It is giving an error when runnind it. Any advice on how to resolve this issue?
[OpenURL "" & PDFTemplateFile & "", Show_Maximized] this is how i am writing it. do i need to define this function.
Thanks a lot for your support
Hi and thanks. Do not use the Open URL but instead use: ActiveWorkbook.FollowHyperlink Address:="" & PDFTemplateFile & ""
You can find this solution in the downloaded workbook as well.
I hope this helps and thanks so much.
Hi! Thank you so much for the video. I am having some problems with OpenURL, it returns the error: Sub or function not defined. ¿Do you know which can be the problem?
Hi Sonia and thanks for your comment. You can replace OpenURL with ThisWorkbook.FollowHyperlink instead.
You can also download my sample workbook which has this as well using the links in the description. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi, is it possible to Auto populate the form with a selected row only? Not every row at the same time, just specific ones. Thank you for all this lesson! Really great for beginners.
Hi Beitriss, Thanks for your comment. You can run a For / Next Loop from the first row to the last row, then for each row you can use an If/ Then statement to see if a row meets your requirements. if it does you can fill the form, if it does not, you can skip it. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
This is one of the best tutorials I've ever seen. I ust have one question. The complier doesn't like the "Show_Maximized" on the OpenURL Line. Is there a way around that?
Hi and thanks, yes there is a great alternative I should have used.
You can use the ThisWorkbook.FollowHyperlink instead
I hope this helps and thanks so much.
This video has inspired me to learn VBA.
My only question is did the hyperlink popup module stop working? Trying to get rid of that sucker.
Hi and thanks. Once the hyperlinks are removed in cells, the pop-up should no longer appear. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
this is great, is there any I can have all in one merged pdf by automation. thank you
Hi and thanks very much. I will research it and do my best to find a solution for you. Thank you for your Likes, Shares & Comments. It really helps.
This is really nice but I have one question @ExcelForFreelancers. If the Excel file is constantly adding new info collected what would be the code? Is it possible to get the new added info only to PDF? Please I really need this
Hi and thanks so much. In any cell you can store the 'last row added' so that the next time the macro runs, it checks for new rows, and starts from the last row added + 1, this ensures that only new data is added.
I hope this helps and thanks so much.
Hi, I'm a complete newbie to VBA and getting a compile error: sub or function not defined error when we get to the initial test to open the PDF. It seems to not like the OpenURL function and was wondering if you could give me any pointers please. Thanks for a great video though
Hi and thanks very much. I am glad you liked the training. Actually, OpenURL was my fault, as this option does not work on every computer, and I should have gone with another statement.
Please try ThisWorkbook.FollowHyperlink PDFTemplateFile
This should work. Thank you for your Likes, Shares & Comments. It really helps.
Thanks for this incredible guide. Is there a code for using "save as" instead of "print"? I tried using "^+(s)" for coding "save as" and prompting acrobat to open the save as window but the rest of the code doesnt work propertly, sendkeys {enter} doesnt correctly work as it taks a while for the code to execute enter, then on the saving window where you choose the file destination, the rest of the codesending the destination folder and file name doesnt work. Hopefully you can aid me here.
Thanks again for this tutorial!
HI and thanks you will want to double check your shortcut keys and add in additional wait statements so you can follow what is going on in the code. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Thanks for the video. great job. I have a question tho. Is it possible to create a button for each row that creates a PDF file with just the information on that row, instead of making PDF files for all the rows in the worksheet?
Hi and thanks. Yes sure it is possible. You can duplicate the macro and instead of looping through the rows you can assign a variable to the selected row and use only that.
I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you for the reply. I'm really new to this and i have no idea how to do that. And i'm having no luck searching it online. Is there a video of yours that helps with this problem?
Hi and thanks so much. These are intermediate to advanced VBA techniques. You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBADiscount_Randy
Thank you for the great video ! Is this application show PDF form can run on mobile or Samsung tablet ?
Hi and thanks so much PDF"s can be opened in a mobile OS, however Excel with Macros only runs on Desktop versions of Windows and Mac.
I hope this helps and thanks so much.
Love the video overall! I did have a couple of questions though: 1) Do you have a video explaining the PDFTemplate and SavePDFFolder code? I can an error when copying and running it (double-checked and I don't have typos)? 2) On a Mac, I get an error when trying to insert a pdf as an object that says "Alert Cannot Insert Object", any idea what's going on? Thanks!
Hi Jay and thanks so much. Mac's are very limited when it comes to VBA and Excel, so it is always best to use a PC. Here are some workarounds when using a Mac
Https://www.macexcel.com/
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi,
very great tutorial, thank you so much! I have one question. Would it be possible to have VBA remove certain text directly from the PDF if a certain column value is empty?
Hi and thanks, most likely you can if it is a fillable pdf. If you can do it with your keyboard, then you can use Sendkeys to mimic the behavior of the keyboard. I hope this helps and thanks so much.
Great video!. How can I get the macro code that you have shared in the video?
Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
@@ExcelForFreelancers Thanks. So which of the package should I buy, if I need this particular Macro?
@@ExcelForFreelancers And also, if I have an image in Excel, can the image also get transferred to PDF form with this Macro?
Great Video! Is there a way to auto fill the checkbox? Could you please help?
HI and thanks, checkboxes are generally filled with a space or a spacebar command, You can use sendkeys with a " " which should fill in the checkbox. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi Thanks for this Tuto which seems to respond to my search on how to automate Filling PDF Form with VBA, I tried it but can't use OpenURL, maybe I need to reference a library I coudn't find ?
HI please use FollowHyperlink (See description above for details or download the free file using the links in the description) The downloaded file has the correction. FollowHyperlink will work without issue. Thanks very much.
@@ExcelForFreelancers Thanks, I received the files and tried to run the updated Excel, The FollowHyperlink works properly. But the fields are not filled correctly (City in Fisrt name, State in Las Name, ... Mail splitted between Address (John) and City (@gmail.com) ... . I wonder if there is a way to position the starting offset in an other manner than the fiste {TAB}. Thanks very much, JF Denes
HI Jean, thanks and I am glad its working. You will have to move step by step through the code and process so that you can test out each field.
Hello Sir. Thank you for a well put together tutorial. I am stuck at saving the individual files. How would you write the SendKeys for Ctrl+Shift+S? I am trying to bypass the printing to PDF section
Hi Mark, thanks for your email. You can write
SendKeys.Send("^+{S}")
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Thank you for your Likes, Shares & Comments. It really helps.
Great video. 👍
Is there a way to interupt or cancel the process whilst it's running?
Hi and thanks you can use Ctrl + Break or Esc to interrupt the code.
I hope this helps and thanks so much.
Hi I was able to get the vba code to work however I am needing to fill out 2 pdf pages. The code works perfectly on the first file but once the first loop finishes and the second one starts, the loop begins on page 2 instead of page 1. What code could I use to get the loop to start on page 1?
Hi Jasmine, thanks for your comment. You would have to determine the shortcut key to 'clear the form'. Almost all PDF applications have a clear form feature. Once you determine what that is, you will put it into the sendkeys. Once cleared, it should then start at the beginning of the form once again.
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Great video and tutorial. I used this to print the pdfs, now I would like to write a code to email each pdf that was created. Do you have a video that explains that? Thanks!
By the way, I've never heard of VBA before watching your video. I knew that I had a problem and knew that there had to be a solution. This video explained how I could accomplish that. I had to change a few things for my specific application, but the general guidelines that you provided allowed me to do that. When I told coworkers in IT what I was doing, they laughed and said good luck.
Hi and thanks so much. To email PDF's you can watch this video: ruclips.net/video/qeQmrADtFjw/видео.html
I hope this helps and thanks so much for your continued support
This is great, thank you so much! I have a question. Do you have a suggestion for doing this with data that comes from a web form that was submitted instead of the data being in the rows in the video?
Hi and thanks very much. It should not matter where the data comes from. As long as it is imported into your worksheet it should work fine. I hope this helps and thanks so much.
@ExcelForFreelancers how do I import it into the worksheet please?
Hi and thanks, I have a series on importing data that will help here: ruclips.net/p/PLIBeRriXvKzAFEKvn0PUTyYpnluDmeQTR
Thank you for your Likes, Shares & Comments. It really helps.
I have a question please. If I am putting 3 bits of data City, State, Zip into the same field in the PDF document, how do I write that in the VBA code?
Hi and thanks, assuming you want to put the address in Cell K8 and the address information is coming from columns D, E & F in a database sheet you could do something like this
Range("K8").Value = DBSht.Range("D" & RecRow).Value & ", " & DBSht.Range("E" & RecRow).Value & " " & DBSht.Range("F" & RecRow).Value 'Full Address
I hope this helps and thanks so much.
Great Tutorial. Please provide "Remove Pop-up Module" . Thanks a lot
Hi and thanks so much. I am glad you enjoyed. I will try to get that added in the near future.
Hello! Thanks for your training!
I have an Error with the OpenURL fuction.
What can i do to solve this problem?
Hi and thanks you can use FollowHyperlink instead of open URL. You can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
@@ExcelForFreelancers Thank you! I’ve already seen your last version of generate multiple PDF’s and now it works!
Thank you for your trainings
Thats great to hear, Thanks so much.
Amazing tutorial. Succinct and useful. I see you'd have to set you default printer beforehand, but that's easy enough to do when this is saving you so many keystrokes. Thanks for a great tutorial with downloads.
Thank you so very much, I really appreciate that.
Thank you for this guide. Every time I run the macro a new tab for pdfiller webpage opens. How do I fix this?
Hi and thanks you can step through the code using F8 to see which line of code is causing it. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Thank you, extremely usefull and enlightening. I am kindly asking for your help though. I want the vba code to fill my pdf form only from the selected row (not to E999). It's been days trying to tweak the code, but apparently I am missing something. Could you be so kind as to help me out? Thank you in advance!
Hi thanks for your message. I have been focused on creating some amazing Excel courses for all Excel enthusiasts so I am unable to offer any one on one support at this time, since I get literally hundreds of request for help per day. However, I have created a Facebook group with 30,000 Excel Experts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: bit.ly/groupexcel. This way we can get you the answers you need, fast.
@@ExcelForFreelancers Thank you very much for your quick answer to my inquiry. Very much appreciated! I will join your FB group, in the meanwhile keep up the wonderfull work you are doing!
Superb video. I throughly enjoyed it. I do, however have a question for you. Is there a way to be able to add in information, say for instance if I am creating a resume in word and I have a template set, would there be a way for a person to keep the current record and add to it automatically without having to create new code, like adding a new job history?
Yes for sure. I have a video specifically for that right here: ruclips.net/video/GYZO9ya-usw/видео.html
I hope this helps and thanks so much.
thank you sir, that was so helpful and interesting. all the best
I am so glad it was helpful and thanks so much.
Thank you for the video,
im trying to test the save function with the Macro idential to yours, it's giving me the compile error, "label not defined".
what am i doing wrong?
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@@ExcelForFreelancers thanks, just rqueted to join... also liked and subscribed thanks again and also kudos for taking the time to answer a comment on a video you posted 6 years ago, even tho its a new comment!!
Thank you so very much, I really appreciate your continued support
Hi Randy,
Thank you so much.
I do have a question.. sorry for the lack of vba knowledge
What if the all the data in excel Is in the same column compared to different Columns as in the video .
Which part of the code should I change?
Eg.
Column A = “all the headers as per the video”
Column B = “ add the data”
Please let me know.
Thank you as always... 🙏
Hi Avi, I have not memorized the code in each workbook so I would not know what you are referring to. Pleas make sure to create a post and upload all code screenshots in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel Thanks very much
THANKS!!! I searched about 3 Weeks for it, how to do this, I'm so happy that i now found itt!! :D
Excellent. I am so happy you found it. Before creating it, I also searched for it and could not find a solution that existed. :)
Did you think you can Help me with a little Problem that i have with my Project? ':D
HI Dr. Fail, I have create a group of over 1800 Excel experts to give advice and help on nearly any excel problem. So please join and post and we will do our best to help you. Here is the group link: bit.ly/groupexcel
Thank you for your very comprehensive programme. I am having a problem however where my pdf generated file cannot be opened in Adobe Acrobat Reader because it is not a supported file type or the file has been damaged. Can you please offer some advice?
Hi can you try the free Foxit Reader application. I love that one and its worked well for me in the past. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Thank you for your response. Just to let you know that I am very new to using vba, but discovered that if I opened Adobe prior to running your programme, then the pdf files that are generated can be read in Adobe Reader DC. Keep up your awesome work
Awesome tutorial! On SaveAs the "full" name is not entering in the address bar, it is trimming the directory location and part of the file name from the from of the address, and then the job fails. I can manually enter the address and the save as works fine, any help you can provide would be awesome.
Hi and thanks, please slow down the code by adding additional time to the Wait Now command. This will increase the time in which VBA adds to placing the full file path in the field. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@@ExcelForFreelancers I have a 20 second delay, and still have issues...and it is trimming the front of the string...not the end. I see in another reply that you said an API may be necessary. That would definitely take it out of my pay grade. :)
I figured out my issue, and thought I'd share. I was using the following send key:
Application.SendKeys "{Enter}", True
This uses the numeric enter key, and was not working for me.
I then tried:
Application.SendKeys "~", True
This uses the keyboard enter. One note, make sure to not use the brackets around the tilde as that doesn't work.
Wow! Incredible video. I can see many applications for your coding. With a few changes from patient information into financial modeling I can visualize an incredible for reporting potential profitable projects. Thank you very much for this invaluable lesson/tutorial.
Ruben
For sure you are very welcome Ruben, Happy to help.
In the sub Create PDFForms... you specified ''With Sheet1'' so you wouldn't have to reference if over and over again.. is there way to keep it simple in the macro's code if the table with the patient's information is on sheet 1 and the buttons for the macro on sheet 2?
Hi Oliver, thanks for your comment. There are several ways you can reference a sheet, you can also Dim and set a sheet such as
Dim Ws as workheet
Set Ws = ThisWorkbook.Sheets("Sheet1")
then you can just refer to Ws within the code.
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@@ExcelForFreelancers That helps a lot thank you!! I joined the facebook group and your videos officially got me interested in writing my own scripts in Excel!!:D Your explanations are much easier to follow and extrapolate than what I've read in books so far..! Cheers!
Thanks so much. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
Hi! My first time automatically filling in a pdf form using excel. I'm at the beginning when you put OpenURL "" & PDFTemplateFile & "", Show_Maximized....the show maximized does not come in a drop down item for me, when I click run I get an error Compile error variable not defined, when I click ok then the Sub CreatePDFForms() is highlighted. Am I missing an object under my reference and tools. Mind providing what reference tool objects are used for this? Thanks for your help!
Hi Cynthia, thanks for your comment. You can try this
ThisWorkbook.FollowHyperlink PDFTemplateFile
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@@ExcelForFreelancers That worked perfect, thanks so much for your help!
You are very welcome and I am happy to help Cynthia
Amazing! Thank youe very much for this video.
But i have a questions:
You made 10 records at once.
If, for example, I add a new data record every half an hour (another line, i.e. a new patient) and I want to print it out immediately afterwards. How can I solve this?
So I would like to expand the list steadily and print out the expansions one by one.
Thank you very much !
Hi and thanks very much. You can run a macro on a Worksheet Change event so that anytime a new record is added the macro will run and print. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Awesome video. As I was following along I went to test my open PDF line and it would only open in a certain PDF app. I tried changing the default app on my computer but it still only opens that one. Is there a way to designate which app is opens the PDF with? Thanks in advance!
Hi and thanks so much. I saw your post in our group and Rob commented correctly on how to change the default program to open PDFs. You may want to restart your machine for this change to take effect. I hope this helps and thanks so much.
Tank you for this video, it's quite helpful!
I'm just having a problem, I'd really appreciate if someone could help me out on this, (I'm too new to VBA):
When the loop continues to the second row it doesn't replace the new text, instead, it writes after the previous, how can I fix this?
Thanks for your time!
Hi Carlos, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
Also if you are new to VBA I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
Thanks so much for this useful guide!
I have one issue when trying out this method and I hope some folks might be able to help me out. In cases when I accidentally navigate myself to another window while the macro is still running, is there anyway that the macro can automatically break when it happens? There have been times where I accidentally click on another window with the macro still running, Sendkeys continues to mess up the contents of whichever windows I am at. Using the Ctrl+break shortcut wont work as it immediately registers the key in the Sendkeys, and also some of the devices I am using does not have a break button.
Does anyone has similar issues and have found a solution? Any suggestions would help! Thanks in advance.
I think you could perhaps check the active window and see if it is Excel and if it is not then exit the sub. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@@ExcelForFreelancers thank you for the suggestions, however I couldnt manage to find much useful information on how to determine whether the active windows is Acrobat reader or not, maybe you could give a an idea on which VBA property that I can use? Thanks in advance
First, thanks for this very helpful video!
Second, a question. I have customized what I need to and it runs perfectly, however I need it to save as a PDF (not print to PDF) because it is a fillable form that needs to remain fillable after being saved. I've adjusted the code to run a "Save as", and have gotten it to the point where the dialogue box opens and it needs to enter the file name, however, it does not change the filename from the template, so it does not go any further. Any ideas on how I can get that filename field to populate correctly?
Hi Ruth, thanks for your comment and question. For the PDF to remain a fillable form you will want to use the API associated with the PDF.
You can try this training which includes fillable PDF's as well: ruclips.net/video/6fot1T_g1dM/видео.html
Thank you for your wonderful video why + sign is not coming in pdf how to copy cell value and paste to pdf form.
i want to update blood group
Hi and thanks so much. Perhaps you can use the character equivalent in VBA which is Char(43) in the ASCII code
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel