Randy Sir No Matter How Long Your Videos Are I always Download Them And Watch Them Carefully i m new to VBA But I Learn A lot Of Things From You. But I want A Teacher Like you to Learn Basic And Small things.. And You Are my inspiration...
Thanks so much. I really do appreciate that. There are so many great Excel gurus teaching the basics, so I tend to teach advanced application development. Thanks again.
Thanks so much. I always have some new ideas. I just finished a recording in which we create a Contact Manager using only a userform. Also starting Saturday, I will be creating a new, short, VBA For Beginners video each and every week. I hope this helps and thanks so much.
I’ve recently started watching your videos and they’re really amazing, thank you so much! All the steps worked great I’m just having trouble with the AppActivate.. I’m using PDF XChange Editor, and can’t figure out how to make it go back to it to fill out the second form.
Hi and thanks for your comment. The best way to approach this is to put away your mouse and determine what keystrokes are needed to go back to the 2nd form. Once you figure that out, you can then use those same keystrokes inside VBA using Sendkeys command. 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 and thanks, Yes of course. I do have an entire playlist of 'From Scratch' videos here: ruclips.net/p/PLIBeRriXvKzCHVxFYRSMTZu3PmnVn4ujb I hope this helps and thanks so much.
Every time your videos are excellent and explanation is awesome, sir i have a request however, please comment your variables and also explain why that variable is required before start of coding so that we can understand the logic better.
Thanks so much Sridhar, I will try to do that as much as possible. I also try to use longer variables so they are somewhere self-explanatory. Thanks again.
Loving this Randy. Same way - I am just looking the same in excel file. I am having a fillable template in Excel sheet and I have another table in next sheet. This tillable template in excel will fill from the data in next sheet in a table. It’s nearly 1000 data. I wish to create 1000 separate excel sheet in a folder. And same time - I am looking for a feature where I can review one single data and send an email directly. Please do let me know - if you have something like this in excel not PDF ?
HI Santos, thanks for the information. I do not have a specific training on that. There is no doubt we can help you with that. While I am unable to take on any projects 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.
It's so mesmerizing ! I used to use Excel intensively in my work, I know that VBA can do a lot of things but my lack of knowledge of all those functions ruins every tries... I can of course have a "good final result" but always have the feeling it must be easier to program a macro "your" way than my way :-) Congratulations Randy, seriously you remember my Access teacher... man he was soooo good too.
Thank you so very much, I really appreciate that. 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/
Loving this Randy, I’m adapting it as we go to build an automated Kanban Board using many of the techniques you are sharing...the checkbox completion will finish it off nicely. I am also using the colour coding for different team members, Thank you so much for your continued teaching and guidance once again 👍👍
Hello, I have developed Speed PDF application in vb net, which will fill all excel user information into PDF form. You can also extract PDF form field information into excel sheet. ruclips.net/video/OUKQOAK0BK0/видео.html
I gain allot from watching your videos but find I have to stop and go back allot because you speed through these tutorials. Otherwise, I appreciate your effort and commitment to teaching.
Thanks so much for your comment. I know it takes some time to learn and you are free to watch the videos as many times as you want. It's not always an easy balance as some people want me to move faster, while others want it slower. Thanks very much for your valuable feedback.
Thanks so much K D. I really think you are going to enjoy this one as it combines an application from scratch, creating a fillable PDF form from a static form, automating the filling in with Excel data on any pdf form, and then emailing those filled in templates to your contacts. You won't want to miss this one.
I happened to find this RUclips channel by accident & all I can say is "Wow"!! I am starting a consulting bussins and this would be great for my customers! One question: is it possible to and attachments to the email as well? I am a new subscriber and will be watching your channel going forward! Thank you!!!
HI and thanks so much. I have many videos in which I create attachments to emails. Feel free to search my channel for it and you will find a lot of examples. Thank you for your Likes, Shares & Comments. It really helps.
Thank you so much for sharing your knowledge which helps me so munch in understanding how macro works. I see it so helpful!! I have a question, can you also share a video about how to convert values in template to text (paragraph) by clicking a “submit” button? Is there a macro for that? If so, I would truly appreciate if you could share! Thank you 😊
HI and thanks very much. I have a few trainings that might help. Please check out this Excel to Word formatted letters training here: ruclips.net/video/c4WvVG6zESg/видео.html I hope this helps and thanks so much.
Thank you so much sir for your fantastic videos....we are learning a lot from your videos... Sir, I daily send 60 to 70 mails to our clients using Gmail account.plz make video for sending mails with attachments using Gmail directly using VBA code...It will save my Time...I will be very thankful to you...
Hi Randy, another great video that open horizons to people who seeks solutions to routine tasks. I have a question and two suggestions (solutions) for specific issue regarding Adobe Acrobat new interface First question: I have a PDF template that consist of 122 form fields in 3 pages (3rd page is the instruction page and nothing to do with Form Fields, no Fields at all). when I run the macro it runs with first record normally until the last Form Field in 2nd page and saves the template. But when it goes back to next person's record and starts filling the Form Fields it does not stars filling from the first Field of Page1 instead from the first Field on Page 2, then goes to the end field of Page 2 (that is also last Field of the template) and returns to the top filed on Page 1. So it fills Form Fields with data that are not related to the fields. I am looking for a command to control or send the cursor to the first Page and first Form Field (Like Page Up kind of thing) Solutions that I have found for some problems related to Adobe Acrobat Pro's new interface that maybe some of the followers of this channel encounter 1. When you try to Save As the document with CTRL+SHIFT+S, Adobe brings a interface where it says SAVE IN RECENT FOLDER and there are only CANCEL and CHOOSE A DIFFRENT FOLDER options (buttons) without any Short-Cut I tried the following and it worked
Application.Wait Now + 0.00001 Application.SendKeys "^+(s)", True 'Save As command Application.Wait Now + 0.00002 Application.SendKeys "~", True ' ENTER(it opens SaveAs window where you can see directory and files. Application.Wait Now + 0.00002 Application.SendKeys "%(n)" ' Now we go into File Name field Application.SendKeys NewPDFFile, True ' It enter the File Name as we defined in VBA (NewPDFFile) Application.Wait Now + 0.00003 Application.SendKeys "~", True ' Another ENTER to jump to Save Button Application.SendKeys "%(s)", True ' Save Application.Wait Now + 0.00003 2. New Adobe does not have old school Menu Bar, so you can not find Reset Form short cut as in other PDF programs (At least I couldn't). I found a solution and have a suggestion for Randy. How likely we can add a macro that asks user for "which PDF program will be used to fill the form" with options of know PDF programs (Like Nitro, Adobe etc.) and uses the short-cuts accordingly. Solution to Reset Form for Adobe Acrobat Pro that i tried and worked A. Make a Box in your form and place it on the top of the page somewhere that user will not go on it by mistake (like corner of the page), because it will be invisible B. Go in to Properties / General - Choose VISIBLE C. Properties / Appearance -Choose NO BORDER COLOR and NO FILL COLOR D. Properties / Position -Make it as small as can be E. Properties / Options -Choose Layout=Label Only, Behavior= None Last but not Least F. Properties / Actions - Select Trigger=ON FOCUS, Select Action= RESET A FORM (Choose all fields that you want to reset, in fact you have to choose all if you will fill the form with VBA) AND DON'T FORGET TO PUT THE BUTTON ON THE TOP OF TAB HIERARCHY
Hi and thanks so much. I am not familiar with the new interface, however the best way to go about something like this is to put away your mouse and map out all the steps using your keyboard shortcuts. Then, add them all in to VBA with Sendkeys and make sure to put lots of wait delays so the code runs slow. You should then be able to find any issues. 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
Hello. Great videos you have here. I am trying to make a fillable PDF registration form and I can't get monetary cells. Once the document is transformed into a PDF, the cells are fillable but I cannot make them monetary nor align them nicely. I saw the 'Create Word Documents & Emails From Any Excel Table, With Number Formatting, Without Mail Merge' video but I'd like to do all of this number formatting inside of a fillable PDF. Do you have another tutorial that shows how to make a fillable PDF with monetary cells?
HI and thanks for your comment. I do not have another however you can use the same method that I used with the Formatting word documents for the PDF as well. 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, Had a Question about once you create a PDF that you can edit? Can the areas that have subjects with Questions to then be answered, then link to say the botton of the PDF with a summary of each subject so you dont have to re type the information that has been say ticked and filed in on each subject?
HI and thanks so much. Once a PDF is created it cannot be edited. You may want to keep it in a Word Format so that you can edit it. You can however select options, checkboxes and drop down lists inside a PDF. 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
As usual THUMBS UP 👍🏼 👍🏼 👍🏼 with 1 question ☺️. Is it possible to change color of student’s name in the body message so the name will be in a different color in the sent email? I hope you got the point.
Hi Abdullah thanks for your message. Yes it is possible using an HTML formatted email. You can find a bit more information on how to create and send an HTML email here: ruclips.net/video/OkM18TD1fDI/видео.html Also look up some HTML code on font color change from google
Is there a way to do this one line at a time? Like if we select a check button or something in excel and it will only auto populate those lines into multiple pdf files?
Hi and thanks, yes you can run an If/Then statement and check for certain conditions if before filling out the link. 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 Randy, just completed this and it works amazing! I just have one question. Do you think there is a way to lock the pdf files after you've made them? i need to send out a few hundred and it would be nice if the receivers couldn't edit them. Thanks!
HI and thanks, yes i am sure there is a way. Depending upon the pdf software you are using, find a way to lock that pdf using your keyboard, and not mouse. Then you can use those same keystrokes using the sendkeys command within VBA 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, sir, for all that you have given us. the question: How can I extract and manipulate information from a DBF database? more success. Thank you.
Hi and thanks for your comment. I have not tried to extract data from a DBF database before however you may want to ask this in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 25,000 Members who would love to help you with this. Thanks so much.
Hi Randy, Your time and efforts are extremely appreciated and I am so thankful to you. I wonder if there is a way to change a picture of an existing image in a PDF file using vba? Have a great time
Hi and thanks. It may be possible if you can find a way to add a picture in a pdf without using your mouse, then you can probably do it using Sendkeys. Give it a try. Thanks so much.
Hi Master, I have an issue need your help and advice. How can code to get data from excel file when I input a Keyword, then I enter or click a button --> all remain fields in pdf will be automatically loaded depend on the Keyword. Thanks
Hi and thanks so much. You can check out this training to help you with that: ruclips.net/video/YuCrEWU2Tm0/видео.html Thank you for your Likes, Shares & Comments. It really helps.
Hello sir, Please make sure you at last show how this will be working out automatically. Which gives a quick glimpse of what we expected through this application and how it works.
Hallo, I have Excel for Mac and the programming does not work. The first mistake pops up at the point -.Title "select PDF Form"-. (Compile error: Invalid use of property) Any ideas? Thanks
Hi and thanks file browse is different for a Mac (I don't have a Mac to test on) however this site will help you modify the program www.macexcel.com/ Mac's have a limited feature set when programming for Excel, so PC's are generally the main choice for running and programming Excel VBA. Thank you for your Likes, Shares & Comments. It really helps.
Excuse Me Randy, please explain me or you can add last minute of this video how to automatic send (without sendkeys). Because i wanna use outlook (not gmail) Thank you for you attention
Hi Muhamad, thanks so much. I have about 20 videos here in RUclips that explains how to email via Outlook. You can just search my channel for "Email". I hope this helps and thanks so much.
Hi Randy, another great tutorial in the powerful Excel. Love Excel and the things you have taught me Excel can do. You use AutoHotKey in VBA, can you advise how we can install AHK in VBA? Keep up the great Videos, always look forward to Tuesdays!
HI Steve, thanks so much and I am glad you enjoy the video. The AutoHotkey is a free application in which you can download from the internet, My script to automate the code is given as a free bonus when you enroll in my Dashboard Masterclass here: www.excelforfreelancers.com/product/advanced-excel-reports-dashboard-masterclass I hope this helps and thanks
Sir your tutorial are just awesome. Is there any way that i can fill a excel form from another database just by entering a single number.( For eg i want to autofill a person's details in a form just by entering his Name)
I love all of your videos! I'm just getting started in the VBA world. I'm following allowing very slowly and going back over and over. But I'm getting an error message that's holding me back from moving forward. I just joined the Facebook Group but I also wanted to see if you could help me out here. On line .Filters.Add "PDF Type Files", "*.pdf", 1 I'm getting a "Run-time error '438': Object doesn't support this property or method error message. Any idea why I'd be getting this message? Thank you for your help and I look forward to diving into all your videos and joining your website.
Hi Derek, 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 50,000 Members who would love to help you with this. Thanks so much.
This is extremely helpful. I’m curious tho is there anyway to allow it to run without seeing it all happen? I noticed I cannot click anything else on my second monitor when this runs which is fine but does it have to show all the windows?
Hi Taylor, thanks very much. Since this particular method uses 'Sendkeys' it will take over the keyboard and now allow you to do anything else while its running. You can try this training for an alternate method: ruclips.net/video/wI6nFlq9CS8/видео.html I hope this helps and thanks so much.
This is great, thanks so much. Is this in your workbooks bundle? Is there a way to modify this to select multiple different forms (eg request for loan quotes from different banks) where we need to fill in the same standard details? ie a set of multiple forms, filled out for multiple customers
Hi and thanks very much. Feel free to download this and customize it however you like. 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.
Great video Randy. Why don't you use named ranges instead of absolute references? It's easier to read and if you have to move the cell you do not need to change the code.
Hi Pietro I do often use them in fact I have an entire video on Named Ranges. I will often alternate options when teaching to show the different possibilities. Thanks for the great suggestion.
Hi and thanks so much for the feedback Todd. You may like the Data Mapping Masterclass in which I take a slower approach and create the application from scratch: ruclips.net/video/7xzCdfrpBn0/видео.html I hope this helps and thanks so much.
Hi there, Great work. The big problem for me is that it cant fill the pdf with Greek Strings. It can be filled with dates or numbers but not with Greek strings. Any ideas ? Thanks in advance. BTW for Acrobat Reader you need to activate the filename and not the program itself (Acrobat) at thee end so you can close it after.
Thank you so very much, I really appreciate the feedback on the filename issue. On the Greek Strings, try the character equivalent. For example, the Checkmark is Chr(252) So for example you can use Sendkeys the Chr(252) you can find the character equivalent # when you use 'Insert Symbols' in Excel you can look for the # below. 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 so much for sharing all your knowledge with us, this is very appreciated. Your videos are great ! I would have a question for you please: if I'm not mistaking, I noticed you do not work with tables that much (I mean the predefined ones that you get from the Insert menu or by pressing Ctrl+T over some existing data). And I would love to know the pros of not using them (because I use them a lot :) ). But my Excel experience is not as advanced as yours, so I might be missing something .. Thank you so much :)
HI GL thanks for your comment. Tables are great and fast to use when you want a specific output in a few different formats, however I want data without any limitations and I find tables very limiting, especially with VBA. I want to control every part of my data and the way in which I work with it, without any limits. You can see more pro's and cons of using tables here: www.reddit.com/r/excel/comments/4u3036/tables_or_no_tables_whats_the_pros_cons_of_each/
Hi... I have another Question... I am getting Error Messages under PDF Marcos Modules - If Dir(NewPDFFile, VbDirectory) "" Then Kill (NewPDFFile) Also Under Create Email - I am not able to Add With Outmail - VBA Error Message states "This Action will reset project, proceed anyway?" Please help. Thanks!!
HI and thanks you will want to check the file path to make sure its accurate. Resetting the project is normal after a VBA error when you make corrections. There is a Free VBA basic course on my site which may help you here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/ Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy I was able to create the fillable PDF in PDFescapes just as you had instructed. My problem came when I tried to open it in EXCEL. I found the file and tried to open it in EXCEL but received the message "The file format and extension of "Work Order.pdf" don't match. The file could be corrupted or unsafe. Unless you trust it's source, don't open it. Do you want to open it anyway?" If I click yes then I get "The Text Wizard has determined that your data is Delimited. If this is correct, choose Next, or choose the data type that best describes your data" I can also choose "Fixed" width. Either way it opens the file in a lot of data and not as the form.
Hi Kevin, Thanks for your comment. There is a difference to opening a pdf 'With' Excel and opening up 'in' Excel. To open it up 'with' excel you can use Thisworkbook.followhyperlink PDFFileName (where PdfFileName is the long file name) 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 Maria, thanks so much. I have a new 'School Manager' series in which we add Student Picture here: Please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries
HI and thanks, you can set up your own shortcuts using a free software called AutoHotkey. You can see how that works here ruclips.net/video/gkmiNkbvpkE/видео.html I hope this helps and thanks so much.
Do you know of a way to validate the email addresses in excel? Validate meaning ensure the email address and domain are real, not just formatted correctly.
Hi and thanks. This can be done via an API. Sounds like an interesting idea and I have written it down for a future training. I have found some API's here: geekflare.com/email-verification-api/
Sir, i have foxit phantom ver 10.0 , my que. is that "is it compulsory to connect to internet when we want to create fillable pdf?" cause i dont have internet at my home so not ablw to connect internet while doing work on pc. also i am not able to see option like you in my foxit
Hi and thanks this application will allow you to fill PDF's without any internet connection. (You would not need that unless you want to send emails) Thank you for your Likes, Shares & Comments. It really helps.
Hi Devin, thanks for your comment. Make sure both variables contain whole numbers. 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 the great video...Is there a Short Cut for Adobe PDF or should I just use the same PDF software that you are using? I can not find the short cut keys to clear the form in Adobe PDF... as you may know , Adobe seems to be online in August 2020. Keep Up the Great Work & I look forward to your reply. WJA
For the new formatting rule part,is it possible for you to type it out in the comments area so it is easier to copy and paste as it is quite blurred in the video and i cant seem to move on from that point.Thank you!
Hi NG, thanks for your comment, you can download this file for free using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Hi Lars thanks so much for your suggestion and I am glad you like the training. There are so many great Excel gurus who are teaching Excel basics, so I tend to cover the more advanced application development. Thanks again.
Excel For Freelancers Sorry about my english... I dont mind advanced, but it would be great if you code and show, then its easier to understand the code. There is no turorial like yours and I have seen a lot!!!!
Hey Randy, I hope you are doing well. I wanted to create unique pdf from excel data, however, the pdf template remains the same and just the values in each excel cell are different. I don't want to mail the pdfs but want to store them in a local folder, is that possible?
HI and yes it is certainly possible. I have many videos here on RUclips to help you with that. 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 Randy I hope you're doing well...do you think this process would work with Adobe Acrobat Pro? Would the text fields there be compatible in the same way as text form fields from PDFEscape for example? Not keen on using PDFEscape.
Hi thanks this should work with nearly and PDF application with some slight variations. Give it a try and if you have any issues feel free to post them in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.
Thank you, sir, for greate tutorials. the question: When I fill out a PDF form in Cyrillic, I have a problem with two letters. These two letters are located on the keyboard in the character position [ ]. When any of these characters occur, the program stops further loading letters. Thanks in advance for the reply
HI and thanks for your comment. What you can do is find the character equivalent for that character, such as Char(252) this way the font wont be used but the character will be. You can search google for a ASCII Character Map. 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
Hello Randy! Thank you so much for such an amazing video. I am new to your channel. All that content is appealing to me for what was in my head to design. I am curious to know if we can use any code to fill in “radio buttons” and “check boxes”. Thanks
Hi and thanks, generally you can use the space bar to check, or uncheck options and generally option boxes too. Just try it a few times using your keyboard to see exactly which actions update the form and then translate that into sendkeys. I hope this helps and thanks.
Hi, thanks for the video tutorial, very useful. I had a problem, I had a column of data in excel that each cell contains WORDS, NUMBERS and SYMBOL, eg: One Thousand (1,000.00). However when I use the code: Application.SendKeys .Range("L" & CustRow).Value, True It does not fill in the ( ) in the PDF form. Instead, it only fill up: One Thousand 1,000.00. May I know how can I make it showing the ( ) in the PDF form? Anything to do with the vba code? Thanks in advance :)
Hi Xavier, thanks for your comment. You can send proper formats when you follow this video training: ruclips.net/video/c4WvVG6zESg/видео.html I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you so much Randy!!! I will go through the video tutorial shortly. Hope I can settle my problem on showing the ( ) from excel's cell onto the PDF form column.
You are always making amazing videos ✌️👌😁. But, I am currently struggling with Google sheet online in which I am trying to create a protection in the enter sheet only those cells and columns that has a specific word, so in a nutshell, I want to make automatic protection based on conditional. For instance, I have a data entry in which the team leaders fill it and I have a column to approve them, if I said yes then automatically lock these cells for them, and if it was no then leave it as it is. Thanks in advance. I have searched a lot but didn't find anything like this.
Hi Halkawt thanks so much for your comment. I focus on Excel only so I would not have the answers to your questions for Google Sheets. thanks for your understanding.
I was able to successfully create an excel program that fills PDF data fields, names and saves the completed PDF and then emails it. The problem I have is when I open the PDF created...most of the entered data does not appear until I highlight the page. Any ideas why this is happening?
Hi Tina, thanks for your comment. It is hard to know why as it depends on the application you are using to display and fill out your PDF's. I have always used the free Foxit PDF software. Give it a try as it may solve your issue. 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
hello sir hope so you are good sir i desing application using urs but there is an issue that the certificate that i mail someone using this methond is editable tell me how i can make the sending documnent read only
Hi Bilal, thanks so much for your comment. If you Print To PDF you can then send it as an un-editable document. 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 Lindsey, 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 50,000 Members who would love to help you with this. Thanks so much.
Hi and thanks very much. The forms can be completed on a cell phone, yes, however the Excel application can only be run from a desktop computer since it has macros. I hope this helps and thanks so much.
Debug: Method 'Range' of object '_Worksheet' failed Highlighted: .Cells(TempRow, TempCol).Value = .Range(.Cells(9, TempCol).Value).Value 'Bring down values from form into table I need help debugging! ***My values are in row 9 not 15
Hi and thanks please check your data mapping cells to make sure the are actual ranges in your worksheet (in row 9). 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
at 32:31 I'm getting a Run-time 1004 error: Method 'Range' of object '_worksheet' failed. I have tried re-entering the Macro and no luck, I'm not sure what i've done wrong. Hoping I dont need to redo all of this
Hi and thanks Dania, for sure you would not have to redo it. Make sure you save the application as an xlsm type file and also I would have to see the code that you are having an issue with it. Can you post it here, or even better in 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.
@@ExcelForFreelancers I am struggling once I get to 32:31 within the video. I copied it word for word, but its not working for me. I am getting the bug error. I checked the file and it is save as .xlsm as directed. Please see below: .Cells(TempRow, Tempcol).Value = .Range(.Cells(15, Tempcol).Value).Value 'Bring down values from form into table
Hi Dania, during the debug, make sure to check your variables TempRow and TempCol, these have to be whole #'s. Also check row 15. Make sure these have actual cells like B15 or A20 or whatever. 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
Dear sir, I have one query, Some times we are dealing with sensitive documents, lets say pay slip and we don't want the document to reach the wrong person via email. My query is, sending emails via Excel and vba is trustworthy ?
Hi Thamer, yes certainly it uses Outlook which is the main Email application for many years. Your code should be fully tested before implementing this of course. I hope this helps and thanks.
Hello, I have developed Speed PDF application in vb net, which will fill all excel user information into PDF form. You can also extract PDF form field information into excel sheet. ruclips.net/video/OUKQOAK0BK0/видео.html
HI Mishra, thanks so much. I have that on my list of applications to create and will do my best to get that done. Thank you for your Likes, Shares & Comments. It really helps.
Thanks sir.. Interesting for you tutorial, awesome.. 👍 I want to learn excel profesional, and then I can to actually for to easy work.. Feedback for me to solusion fast learn. 🙏
Hi thanks for your comment and I am glad you enjoyed the training. If you want to learn faster and create Excel applications in which you can sell you can join our Excel For Freelancers Mentorship Program here: bit.ly/MentorProgram_YTComment
Thank you Randy. Your training is spectacular. Do you have an option to lock or protect the user form without disabling the table so the user can only click on the fields to enter information, the buttons and the table? Thanks again.
Hi TK thanks very much. You can apply cell protection to those cells that should be locked and remove the protection for those cells that should not be. This way when you protect the sheet with a password, users cannot change what is in the table. Those cell should remain protected. Inside your code, when protecting the sheet, use xlUserInterfaceOnly. This allows VBA to make changes to cells that are protected, but not the user. I hope this helps and thanks.
Hi Diya , 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.
This video was very helpful. Thank you! However, I am running into a problem: After the macro completes and goes to the next row, it resets the PDF form successfully, but then starts on a random field towards the end of the PDF file rather than starting at the first field. Any ideas why this is happening? It seems that tabbing on the Foxit PDF Reader starts on the first tab position of the current page rather than returning to page 1 (my PDF form has two pages).
Hi Jim, 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 50,000 Members who would love to help you with this. Thanks so much.
@@ExcelForFreelancers I appreciate the quick response! I was able to figure out a fix for my issue. I added an additional step after saving the file: Application.SendKeys "^{PGUP}", True Since my PDF is two pages, this is all I needed. I suppose if you have a PDF form with x pages, you would want to duplicate the above step x-1 times before returning to the top of the main loop. Thank you again for a very helpful video!!
Thanks so much Said. I am really glad you enjoy the trainings and this one I think you will love as it combines lots of useful concepts into a single video and training.
![Learn How To Create This Yearly Activity Scheduler In Excel [FREE Download Inside]](http://i.ytimg.com/vi/_4Ew2LdAXMs/mqdefault.jpg)
![Learn How To Create This Yearly Activity Scheduler In Excel [FREE Download Inside]](/img/tr.png)
![Learn How To Create This Never Seen Before Drag & Drop Task Scheduler In Excel Today [Part 1]](http://i.ytimg.com/vi/8-IEk-pmfco/mqdefault.jpg)
🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
Randy Sir No Matter How Long Your Videos Are I always Download Them And Watch Them Carefully i m new to VBA But I Learn A lot Of Things From You. But I want A Teacher Like you to Learn Basic And Small things.. And You Are my inspiration...
Thanks so much. I really do appreciate that. There are so many great Excel gurus teaching the basics, so I tend to teach advanced application development. Thanks again.
Dear, You almost covered everything in thoses courses , I wonder what else you gonna teach us. Many Thanks 😅
Thanks so much. I always have some new ideas. I just finished a recording in which we create a Contact Manager using only a userform.
Also starting Saturday, I will be creating a new, short, VBA For Beginners video each and every week.
I hope this helps and thanks so much.
Thank you for sharing the knowledge. So helpful.
Glad it was helpful and thanks so much
Hi sir, i am waiting for every Tuesday , i like ur teaching method, very simple lines of code and easy to understand, thank you sir
So nice of you and thanks for your kind comments. I am glad you enjoy the training.
I’ve recently started watching your videos and they’re really amazing, thank you so much!
All the steps worked great I’m just having trouble with the AppActivate.. I’m using PDF XChange Editor, and can’t figure out how to make it go back to it to fill out the second form.
Hi and thanks for your comment. The best way to approach this is to put away your mouse and determine what keystrokes are needed to go back to the 2nd form. Once you figure that out, you can then use those same keystrokes inside VBA using Sendkeys command.
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! Can you do more training like this. Starting from the beginning this training was awesome
HI and thanks, Yes of course. I do have an entire playlist of 'From Scratch' videos here: ruclips.net/p/PLIBeRriXvKzCHVxFYRSMTZu3PmnVn4ujb
I hope this helps and thanks so much.
Every time your videos are excellent and explanation is awesome, sir i have a request however, please comment your variables and also explain why that variable is required before start of coding so that we can understand the logic better.
Thanks so much Sridhar, I will try to do that as much as possible. I also try to use longer variables so they are somewhere self-explanatory. Thanks again.
Phenomenal. Certainly a real-world project.
Thank you so much imran. I am so glad you enjoyed it.
Excellent tutorials - many thanks
Thank you so very much, I really appreciate that Ricky
Loving this Randy. Same way -
I am just looking the same in excel file. I am having a fillable template in Excel sheet and I have another table in next sheet. This tillable template in excel will fill from the data in next sheet in a table. It’s nearly 1000 data. I wish to create 1000 separate excel sheet in a folder. And same time - I am looking for a feature where I can review one single data and send an email directly. Please do let me know - if you have something like this in excel not PDF ?
HI Santos, thanks for the information. I do not have a specific training on that. There is no doubt we can help you with that. While I am unable to take on any projects 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.
Keep up the great video.. really helpfull for increasing skill in excel.
Regards from Indonesia
Thanks, will do De Van's. Much appreciated
It's so mesmerizing !
I used to use Excel intensively in my work, I know that VBA can do a lot of things but my lack of knowledge of all those functions ruins every tries...
I can of course have a "good final result" but always have the feeling it must be easier to program a macro "your" way than my way :-)
Congratulations Randy, seriously you remember my Access teacher... man he was soooo good too.
Thank you so very much, I really appreciate that. 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/
Sir i am big fan of yours. I learned alot from you. Thank you for your valuable informations and projects.
It's my pleasure and I am happy to help Panun
Once again, thank you Randy for these great videos you put out every Tuesday!
My pleasure Elmer. I am happy I could help.
your tutorials always outstanding and helpful ,keep it up .wonderful work
Thanks, will do Gulab. Much appreciated.
Loving this Randy, I’m adapting it as we go to build an automated Kanban Board using many of the techniques you are sharing...the checkbox completion will finish it off nicely. I am also using the colour coding for different team members,
Thank you so much for your continued teaching and guidance once again 👍👍
Thanks so much Richard. I always appreciate your kind words and I am happy to bring you these trainings and applications.
Hello,
I have developed Speed PDF application in vb net, which will fill all excel user information into PDF form.
You can also extract PDF form field information into excel sheet.
ruclips.net/video/OUKQOAK0BK0/видео.html
Beautiful video
Thank you so very much, I really appreciate that Shimu
I gain allot from watching your videos but find I have to stop and go back allot because you speed through these tutorials. Otherwise, I appreciate your effort and commitment to teaching.
Thanks so much for your comment. I know it takes some time to learn and you are free to watch the videos as many times as you want. It's not always an easy balance as some people want me to move faster, while others want it slower. Thanks very much for your valuable feedback.
Your tutorials are simply stunning. 🔆 👏 🌟 👍
Thanks so much K D. I really think you are going to enjoy this one as it combines an application from scratch, creating a fillable PDF form from a static form, automating the filling in with Excel data on any pdf form, and then emailing those filled in templates to your contacts. You won't want to miss this one.
Hi Sir, I share your Video every my friends.
So nice of you thanks so much for sharing.
I happened to find this RUclips channel by accident & all I can say is "Wow"!! I am starting a consulting bussins and this would be great for my customers! One question: is it possible to and attachments to the email as well? I am a new subscriber and will be watching your channel going forward! Thank you!!!
HI and thanks so much. I have many videos in which I create attachments to emails. Feel free to search my channel for it and you will find a lot of examples. Thank you for your Likes, Shares & Comments. It really helps.
Thank you so much for sharing your knowledge which helps me so munch in understanding how macro works. I see it so helpful!! I have a question, can you also share a video about how to convert values in template to text (paragraph) by clicking a “submit” button?
Is there a macro for that? If so, I would truly appreciate if you could share! Thank you 😊
HI and thanks very much. I have a few trainings that might help. Please check out this Excel to Word formatted letters training here: ruclips.net/video/c4WvVG6zESg/видео.html
I hope this helps and thanks so much.
Thank you so much sir. Excellent video.
For sure, you are very welcome Ashok, I am glad you enjoyed the video.
Thank you so much sir for your fantastic videos....we are learning a lot from your videos...
Sir, I daily send 60 to 70 mails to our clients using Gmail account.plz make video for sending mails with attachments using Gmail directly using VBA code...It will save my
Time...I will be very thankful to you...
HI thanks i have made this already, you can find that training here: ruclips.net/video/WoCuRFEuACg/видео.html
Thank you...
Awesome video!
Thank you so very much, I really appreciate that
Hi Randy, another great video that open horizons to people who seeks solutions to routine tasks.
I have a question and two suggestions (solutions) for specific issue regarding Adobe Acrobat new interface
First question: I have a PDF template that consist of 122 form fields in 3 pages (3rd page is the instruction page and nothing to do with Form Fields, no Fields at all). when I run the macro it runs with first record normally until the last Form Field in 2nd page and saves the template. But when it goes back to next person's record and starts filling the Form Fields it does not stars filling from the first Field of Page1 instead from the first Field on Page 2, then goes to the end field of Page 2 (that is also last Field of the template) and returns to the top filed on Page 1. So it fills Form Fields with data that are not related to the fields.
I am looking for a command to control or send the cursor to the first Page and first Form Field (Like Page Up kind of thing)
Solutions that I have found for some problems related to Adobe Acrobat Pro's new interface that maybe some of the followers of this channel encounter
1. When you try to Save As the document with CTRL+SHIFT+S, Adobe brings a interface where it says SAVE IN RECENT FOLDER and there are only CANCEL and CHOOSE A DIFFRENT FOLDER options (buttons) without any Short-Cut
I tried the following and it worked
Application.Wait Now + 0.00001
Application.SendKeys "^+(s)", True 'Save As command
Application.Wait Now + 0.00002
Application.SendKeys "~", True ' ENTER(it opens SaveAs window where you can see directory and files.
Application.Wait Now + 0.00002
Application.SendKeys "%(n)" ' Now we go into File Name field
Application.SendKeys NewPDFFile, True ' It enter the File Name as we defined in VBA (NewPDFFile)
Application.Wait Now + 0.00003
Application.SendKeys "~", True ' Another ENTER to jump to Save Button
Application.SendKeys "%(s)", True ' Save
Application.Wait Now + 0.00003
2. New Adobe does not have old school Menu Bar, so you can not find Reset Form short cut as in other PDF programs (At least I couldn't). I found a solution and have a suggestion for Randy. How likely we can add a macro that asks user for "which PDF program will be used to fill the form" with options of know PDF programs (Like Nitro, Adobe etc.) and uses the short-cuts accordingly.
Solution to Reset Form for Adobe Acrobat Pro that i tried and worked
A. Make a Box in your form and place it on the top of the page somewhere that user will not go on it by mistake (like corner of the page), because it will be invisible
B. Go in to Properties / General - Choose VISIBLE
C. Properties / Appearance -Choose NO BORDER COLOR and NO FILL COLOR
D. Properties / Position -Make it as small as can be
E. Properties / Options -Choose Layout=Label Only, Behavior= None
Last but not Least
F. Properties / Actions - Select Trigger=ON FOCUS, Select Action= RESET A FORM (Choose all fields that you want to reset, in fact you have to choose all if you will fill the form with VBA)
AND DON'T FORGET TO PUT THE BUTTON ON THE TOP OF TAB HIERARCHY
Hi and thanks so much. I am not familiar with the new interface, however the best way to go about something like this is to put away your mouse and map out all the steps using your keyboard shortcuts. Then, add them all in to VBA with Sendkeys and make sure to put lots of wait delays so the code runs slow. You should then be able to find any issues. 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
Hello. Great videos you have here.
I am trying to make a fillable PDF registration form and I can't get monetary cells. Once the document is transformed into a PDF, the cells are fillable but I cannot make them monetary nor align them nicely.
I saw the 'Create Word Documents & Emails From Any Excel Table, With Number Formatting, Without Mail Merge' video but I'd like to do all of this number formatting inside of a fillable PDF.
Do you have another tutorial that shows how to make a fillable PDF with monetary cells?
HI and thanks for your comment. I do not have another however you can use the same method that I used with the Formatting word documents for the PDF as well. 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
Very good video 💖💖
Thanks so much. Very kind of you Rofiqul
Hi, Had a Question about once you create a PDF that you can edit? Can the areas that have subjects with Questions to then be answered, then link to say the botton of the PDF with a summary of each subject so you dont have to re type the information that has been say ticked and filed in on each subject?
HI and thanks so much. Once a PDF is created it cannot be edited. You may want to keep it in a Word Format so that you can edit it. You can however select options, checkboxes and drop down lists inside a PDF. 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 Fantastic! Thank You Very Much For This Amazing Content And Training.
You are very welcome Jezreel, I am so glad you enjoyed it.
Well-Done Sir, thanks for the wonderful Tutorial.
You are most welcome Aimal, Thanks very much.
As usual THUMBS UP 👍🏼 👍🏼 👍🏼 with 1 question ☺️.
Is it possible to change color of student’s name in the body message so the name will be in a different color in the sent email? I hope you got the point.
Hi Abdullah thanks for your message. Yes it is possible using an HTML formatted email. You can find a bit more information on how to create and send an HTML email here: ruclips.net/video/OkM18TD1fDI/видео.html
Also look up some HTML code on font color change from google
No other word, Superb!
Thank you so very much, I really appreciate that.
Can't wait to watch this stuff
Thank you Sabir, I believe you will enjoy it.
Is there a way to do this one line at a time? Like if we select a check button or something in excel and it will only auto populate those lines into multiple pdf files?
Hi and thanks, yes you can run an If/Then statement and check for certain conditions if before filling out the link. 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 Randy, just completed this and it works amazing! I just have one question. Do you think there is a way to lock the pdf files after you've made them? i need to send out a few hundred and it would be nice if the receivers couldn't edit them. Thanks!
HI and thanks, yes i am sure there is a way. Depending upon the pdf software you are using, find a way to lock that pdf using your keyboard, and not mouse. Then you can use those same keystrokes using the sendkeys command within VBA
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, sir, for all that you have given us.
the question:
How can I extract and manipulate information from a DBF database?
more success.
Thank you.
Hi and thanks for your comment. I have not tried to extract data from a DBF database before however you may want to ask this in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 25,000 Members who would love to help you with this. Thanks so much.
Hi Randy,
Your time and efforts are extremely appreciated and I am so thankful to you.
I wonder if there is a way to change a picture of an existing image in a PDF file using vba?
Have a great time
Hi and thanks. It may be possible if you can find a way to add a picture in a pdf without using your mouse, then you can probably do it using Sendkeys. Give it a try. Thanks so much.
Hi Master, I have an issue need your help and advice.
How can code to get data from excel file when I input a Keyword, then I enter or click a button --> all remain fields in pdf will be automatically loaded depend on the Keyword.
Thanks
Hi and thanks so much. You can check out this training to help you with that: ruclips.net/video/YuCrEWU2Tm0/видео.html
Thank you for your Likes, Shares & Comments. It really helps.
Thank you so much you boosting our skills to a very high level.
For sure, you are very welcome Muhammad.
Great video. Tip: You often bounce against you mic this is a bit disturbing. Keep up this work!
Thanks for the tip I will keep it at a clear distance in the future.
Thank you.
You're welcome J. Redulfin.
Hello sir,
Please make sure you at last show how this will be working out automatically. Which gives a quick glimpse of what we expected through this application and how it works.
Hi thanks very much. I will do my best to make sure i do that. Thanks so much for your comment.
that was awesome! Thank you!
Glad you liked it and thanks so much.
Hallo, I have Excel for Mac and the programming does not work. The first mistake pops up at the point -.Title "select PDF Form"-. (Compile error: Invalid use of property) Any ideas? Thanks
Hi and thanks file browse is different for a Mac (I don't have a Mac to test on) however this site will help you modify the program
www.macexcel.com/
Mac's have a limited feature set when programming for Excel, so PC's are generally the main choice for running and programming Excel VBA.
Thank you for your Likes, Shares & Comments. It really helps.
Excuse Me Randy, please explain me or you can add last minute of this video how to automatic send (without sendkeys). Because i wanna use outlook (not gmail)
Thank you for you attention
Hi Muhamad, thanks so much. I have about 20 videos here in RUclips that explains how to email via Outlook. You can just search my channel for "Email". I hope this helps and thanks so much.
Do you have a tutorial on how to create a Mileage Tracker with mobile capabilities?
Hello, I do not however it is a nice idea so i will write it down on my Videos To Create list. Thanks so much.
Nice video
Thank you so very much, I really appreciate that Saiful
Hi Randy, another great tutorial in the powerful Excel. Love Excel and the things you have taught me Excel can do. You use AutoHotKey in VBA, can you advise how we can install AHK in VBA? Keep up the great Videos, always look forward to Tuesdays!
HI Steve, thanks so much and I am glad you enjoy the video. The AutoHotkey is a free application in which you can download from the internet, My script to automate the code is given as a free bonus when you enroll in my Dashboard Masterclass here: www.excelforfreelancers.com/product/advanced-excel-reports-dashboard-masterclass
I hope this helps and thanks
Hi Steve I recently created a training video & Download on Auto-hotkey right here: ruclips.net/video/gkmiNkbvpkE/видео.html
Sir your tutorial are just awesome. Is there any way that i can fill a excel form from another database just by entering a single number.( For eg i want to autofill a person's details in a form just by entering his Name)
HI and thanks, this video should help you here: ruclips.net/video/CJTUiPsacAQ/видео.html
@@ExcelForFreelancers thanks a lot sir for your kind reply
I love all of your videos! I'm just getting started in the VBA world. I'm following allowing very slowly and going back over and over. But I'm getting an error message that's holding me back from moving forward. I just joined the Facebook Group but I also wanted to see if you could help me out here. On line .Filters.Add "PDF Type Files", "*.pdf", 1 I'm getting a "Run-time error '438': Object doesn't support this property or method error message. Any idea why I'd be getting this message? Thank you for your help and I look forward to diving into all your videos and joining your website.
Hi Derek, 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 50,000 Members who would love to help you with this. Thanks so much.
Nice
Thank you so very much, I really appreciate that Soibe
This is extremely helpful. I’m curious tho is there anyway to allow it to run without seeing it all happen? I noticed I cannot click anything else on my second monitor when this runs which is fine but does it have to show all the windows?
Hi Taylor, thanks very much. Since this particular method uses 'Sendkeys' it will take over the keyboard and now allow you to do anything else while its running. You can try this training for an alternate method: ruclips.net/video/wI6nFlq9CS8/видео.html
I hope this helps and thanks so much.
Your contents are awesome
Thanks so much. I really appreciate that.
This is great, thanks so much. Is this in your workbooks bundle? Is there a way to modify this to select multiple different forms (eg request for loan quotes from different banks) where we need to fill in the same standard details? ie a set of multiple forms, filled out for multiple customers
Hi and thanks very much. Feel free to download this and customize it however you like. 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.
Great video Randy. Why don't you use named ranges instead of absolute references? It's easier to read and if you have to move the cell you do not need to change the code.
Hi Pietro I do often use them in fact I have an entire video on Named Ranges. I will often alternate options when teaching to show the different possibilities. Thanks for the great suggestion.
nice
Thank you so very much, I really appreciate that Momin
Slow down and complete your thought!
Hi and thanks so much for the feedback Todd. You may like the Data Mapping Masterclass in which I take a slower approach and create the application from scratch: ruclips.net/video/7xzCdfrpBn0/видео.html
I hope this helps and thanks so much.
Sir, How can we fill a PDF form with data from multiple rows of excel. Like data with specific dates or any condition.
Hi and thanks so much, you can run and advanced filter and then run a loop through the results.
I hope this helps and thanks so much.
Hi there, Great work. The big problem for me is that it cant fill the pdf with Greek Strings. It can be filled with dates or numbers but not with Greek strings. Any ideas ? Thanks in advance. BTW for Acrobat Reader you need to activate the filename and not the program itself (Acrobat) at thee end so you can close it after.
Thank you so very much, I really appreciate the feedback on the filename issue. On the Greek Strings, try the character equivalent. For example, the Checkmark is Chr(252)
So for example you can use Sendkeys the Chr(252) you can find the character equivalent # when you use 'Insert Symbols' in Excel you can look for the # below.
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
Hello Randy man, I like your videos but please can you make a video on how to create members' contribution in an association?
Hi you made this same comment yesterday already and I responded. I already wrote it down. Once is enough for sure. Thank you.
Your stuff is amazing!!!!! :)
Thank you so very much, I really appreciate that Cinthia :)
Thank you so much for sharing all your knowledge with us, this is very appreciated.
Your videos are great !
I would have a question for you please:
if I'm not mistaking, I noticed you do not work with tables that much (I mean the predefined ones that you get from the Insert menu or by pressing Ctrl+T over some existing data). And I would love to know the pros of not using them (because I use them a lot :) ). But my Excel experience is not as advanced as yours, so I might be missing something ..
Thank you so much :)
HI GL thanks for your comment. Tables are great and fast to use when you want a specific output in a few different formats, however I want data without any limitations and I find tables very limiting, especially with VBA. I want to control every part of my data and the way in which I work with it, without any limits. You can see more pro's and cons of using tables here:
www.reddit.com/r/excel/comments/4u3036/tables_or_no_tables_whats_the_pros_cons_of_each/
@@ExcelForFreelancers Thank you very much !!
Hi... I have another Question... I am getting Error Messages under PDF Marcos Modules - If Dir(NewPDFFile, VbDirectory) "" Then Kill (NewPDFFile) Also Under Create Email - I am not able to Add With Outmail - VBA Error Message states "This Action will reset project, proceed anyway?" Please help. Thanks!!
HI and thanks you will want to check the file path to make sure its accurate. Resetting the project is normal after a VBA error when you make corrections. There is a Free VBA basic course on my site which may help you here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy I was able to create the fillable PDF in PDFescapes just as you had instructed. My problem came when I tried to open it in EXCEL. I found the file and tried to open it in EXCEL but received the message "The file format and extension of "Work Order.pdf" don't match. The file could be corrupted or unsafe. Unless you trust it's source, don't open it. Do you want to open it anyway?" If I click yes then I get "The Text Wizard has determined that your data is Delimited. If this is correct, choose Next, or choose the data type that best describes your data" I can also choose "Fixed" width. Either way it opens the file in a lot of data and not as the form.
Hi Kevin, Thanks for your comment. There is a difference to opening a pdf 'With' Excel and opening up 'in' Excel. To open it up 'with' excel you can use Thisworkbook.followhyperlink PDFFileName (where PdfFileName is the long file name)
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 so much for this tutorial! Is there any way that for example you could add the students picture if needed?
HI Maria, thanks so much. I have a new 'School Manager' series in which we add Student Picture here: Please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries
sir what are the shortcuts for microsoft edge if we open pdf in microsoft edge?
HI and thanks, you can set up your own shortcuts using a free software called AutoHotkey. You can see how that works here ruclips.net/video/gkmiNkbvpkE/видео.html
I hope this helps and thanks so much.
Do you know of a way to validate the email addresses in excel? Validate meaning ensure the email address and domain are real, not just formatted correctly.
Hi and thanks. This can be done via an API. Sounds like an interesting idea and I have written it down for a future training. I have found some API's here: geekflare.com/email-verification-api/
Sir,
i have foxit phantom ver 10.0 , my que. is that "is it compulsory to connect to internet when we want to create fillable pdf?" cause i dont have internet at my home so not ablw to connect internet while doing work on pc. also i am not able to see option like you in my foxit
Hi and thanks this application will allow you to fill PDF's without any internet connection. (You would not need that unless you want to send emails) Thank you for your Likes, Shares & Comments. It really helps.
Nice Tutorial
Glad you think so and thanks so much Forontier Tech.
The .cells(temprow, tempcol isn’t working and giving me a 1004 error for save templates. Any help?
Hi Devin, thanks for your comment. Make sure both variables contain whole numbers. 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 the great video...Is there a Short Cut for Adobe PDF or should I just use the same PDF software that you are using? I can not find the short cut keys to clear the form in Adobe PDF... as you may know , Adobe seems to be online in August 2020. Keep Up the Great Work & I look forward to your reply. WJA
Thanks so much. Try Foxit. I really love it for PDF as well, its much smaller than Adobe and have found it excellent. Thanks for the kind words :)
For the new formatting rule part,is it possible for you to type it out in the comments area so it is easier to copy and paste as it is quite blurred in the video and i cant seem to move on from that point.Thank you!
Hi NG, thanks for your comment, you can download this file for free using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Super cool, i am waiting with exitement! I am having a similar requirement in my work and this will be really helpful!
Great to hear and I hope it was helpful. Thank you.
You are really amazing, but what about making an excelforfreelancers for dummies like me...??? I need small steps to understand and learn...
Hi Lars thanks so much for your suggestion and I am glad you like the training. There are so many great Excel gurus who are teaching Excel basics, so I tend to cover the more advanced application development. Thanks again.
Excel For Freelancers Sorry about my english... I dont mind advanced, but it would be great if you code and show, then its easier to understand the code. There is no turorial like yours and I have seen a lot!!!!
Hey Randy, I hope you are doing well. I wanted to create unique pdf from excel data, however, the pdf template remains the same and just the values in each excel cell are different. I don't want to mail the pdfs but want to store them in a local folder, is that possible?
HI and yes it is certainly possible. I have many videos here on RUclips to help you with that.
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!
Excited Sir
Thanks so much. I think you will really enjoy this one.
Hi Randy I hope you're doing well...do you think this process would work with Adobe Acrobat Pro? Would the text fields there be compatible in the same way as text form fields from PDFEscape for example? Not keen on using PDFEscape.
Hi thanks this should work with nearly and PDF application with some slight variations. Give it a try and if you have any issues feel free to post them in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 30,000 Members who would love to help you with this. Thanks so much.
Thank you, sir, for greate tutorials.
the question:
When I fill out a PDF form in Cyrillic, I have a problem with two letters. These two letters are located on the keyboard in the character position [ ]. When any of these characters occur, the program stops further loading letters. Thanks in advance for the reply
HI and thanks for your comment. What you can do is find the character equivalent for that character, such as Char(252) this way the font wont be used but the character will be. You can search google for a ASCII Character Map. 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
Hello Randy!
Thank you so much for such an amazing video. I am new to your channel. All that content is appealing to me for what was in my head to design. I am curious to know if we can use any code to fill in “radio buttons” and “check boxes”.
Thanks
Hi and thanks, generally you can use the space bar to check, or uncheck options and generally option boxes too. Just try it a few times using your keyboard to see exactly which actions update the form and then translate that into sendkeys. I hope this helps and thanks.
Hi, thanks for the video tutorial, very useful.
I had a problem, I had a column of data in excel that each cell contains WORDS, NUMBERS and SYMBOL, eg: One Thousand (1,000.00).
However when I use the code: Application.SendKeys .Range("L" & CustRow).Value, True
It does not fill in the ( ) in the PDF form. Instead, it only fill up: One Thousand 1,000.00.
May I know how can I make it showing the ( ) in the PDF form? Anything to do with the vba code?
Thanks in advance :)
Hi Xavier, thanks for your comment. You can send proper formats when you follow this video training: ruclips.net/video/c4WvVG6zESg/видео.html
I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you so much Randy!!! I will go through the video tutorial shortly. Hope I can settle my problem on showing the ( ) from excel's cell onto the PDF form column.
You are always making amazing videos ✌️👌😁. But, I am currently struggling with Google sheet online in which I am trying to create a protection in the enter sheet only those cells and columns that has a specific word, so in a nutshell, I want to make automatic protection based on conditional. For instance, I have a data entry in which the team leaders fill it and I have a column to approve them, if I said yes then automatically lock these cells for them, and if it was no then leave it as it is. Thanks in advance. I have searched a lot but didn't find anything like this.
Hi Halkawt thanks so much for your comment. I focus on Excel only so I would not have the answers to your questions for Google Sheets. thanks for your understanding.
I was able to successfully create an excel program that fills PDF data fields, names and saves the completed PDF and then emails it. The problem I have is when I open the PDF created...most of the entered data does not appear until I highlight the page. Any ideas why this is happening?
Hi Tina, thanks for your comment. It is hard to know why as it depends on the application you are using to display and fill out your PDF's. I have always used the free Foxit PDF software. Give it a try as it may solve your issue.
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 am pretty much tied to Adobe Pro DC. I am working on a Win7 Office 2010 system. Could Win10 Office 2016 make any difference.
hello sir hope so you are good sir i desing application using urs but there is an issue that the certificate that i mail someone using this methond is editable tell me how i can make the sending documnent read only
Hi Bilal, thanks so much for your comment. If you Print To PDF you can then send it as an un-editable document. 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 thanks for your response but can you please share the vba code of making an editable pdf to uneditable
Hi you can just search google for "Excel Print To PDF" to get the full code.
has anyone had this error and was able to fix it? "Object variable not set (Error 91)"
Hi Lindsey, 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 50,000 Members who would love to help you with this. Thanks so much.
Exited sir
Thanks so much Anand. :)
Can these forms be completed on a cell phone?
Hi and thanks very much. The forms can be completed on a cell phone, yes, however the Excel application can only be run from a desktop computer since it has macros.
I hope this helps and thanks so much.
Debug: Method 'Range' of object '_Worksheet' failed
Highlighted: .Cells(TempRow, TempCol).Value = .Range(.Cells(9, TempCol).Value).Value 'Bring down values from form into table
I need help debugging! ***My values are in row 9 not 15
Hi and thanks please check your data mapping cells to make sure the are actual ranges in your worksheet (in row 9).
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
at 32:31 I'm getting a Run-time 1004 error: Method 'Range' of object '_worksheet' failed.
I have tried re-entering the Macro and no luck, I'm not sure what i've done wrong. Hoping I dont need to redo all of this
Hi and thanks Dania, for sure you would not have to redo it. Make sure you save the application as an xlsm type file and also I would have to see the code that you are having an issue with it. Can you post it here, or even better in 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.
@@ExcelForFreelancers
I am struggling once I get to 32:31 within the video. I copied it word for word, but its not working for me. I am getting the bug error. I checked the file and it is save as .xlsm as directed. Please see below:
.Cells(TempRow, Tempcol).Value = .Range(.Cells(15, Tempcol).Value).Value 'Bring down values from form into table
Hi Dania, during the debug, make sure to check your variables TempRow and TempCol, these have to be whole #'s. Also check row 15. Make sure these have actual cells like B15 or A20 or whatever.
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
Dear sir,
I have one query, Some times we are dealing with sensitive documents, lets say pay slip and we don't want the document to reach the wrong person via email. My query is, sending emails via Excel and vba is trustworthy ?
Hi Thamer, yes certainly it uses Outlook which is the main Email application for many years. Your code should be fully tested before implementing this of course. I hope this helps and thanks.
Hello,
I have developed Speed PDF application in vb net, which will fill all excel user information into PDF form.
You can also extract PDF form field information into excel sheet.
ruclips.net/video/OUKQOAK0BK0/видео.html
Pl make a software for loan document management
HI Mishra, thanks so much. I have that on my list of applications to create and will do my best to get that done. Thank you for your Likes, Shares & Comments. It really helps.
Thanks sir..
Interesting for you tutorial, awesome.. 👍
I want to learn excel profesional, and then I can to actually for to easy work.. Feedback for me to solusion fast learn. 🙏
Hi thanks for your comment and I am glad you enjoyed the training. If you want to learn faster and create Excel applications in which you can sell you can join our Excel For Freelancers Mentorship Program here: bit.ly/MentorProgram_YTComment
@@ExcelForFreelancers Thanks master 🙏🙏
Thank you Randy. Your training is spectacular. Do you have an option to lock or protect the user form without disabling the table so the user can only click on the fields to enter information, the buttons and the table? Thanks again.
Hi TK thanks very much. You can apply cell protection to those cells that should be locked and remove the protection for those cells that should not be. This way when you protect the sheet with a password, users cannot change what is in the table. Those cell should remain protected. Inside your code, when protecting the sheet, use xlUserInterfaceOnly. This allows VBA to make changes to cells that are protected, but not the user. I hope this helps and thanks.
Excel hangs everytime I run the code. Could someone tell me why ?
Hi Diya , 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.
This video was very helpful. Thank you! However, I am running into a problem: After the macro completes and goes to the next row, it resets the PDF form successfully, but then starts on a random field towards the end of the PDF file rather than starting at the first field. Any ideas why this is happening? It seems that tabbing on the Foxit PDF Reader starts on the first tab position of the current page rather than returning to page 1 (my PDF form has two pages).
Hi Jim, 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 50,000 Members who would love to help you with this. Thanks so much.
@@ExcelForFreelancers I appreciate the quick response! I was able to figure out a fix for my issue. I added an additional step after saving the file:
Application.SendKeys "^{PGUP}", True
Since my PDF is two pages, this is all I needed. I suppose if you have a PDF form with x pages, you would want to duplicate the above step x-1 times before returning to the top of the main loop.
Thank you again for a very helpful video!!
Great video!
Thanks very much Alfred.
Can't wait to watch this stuff
Thanks so much Said. I am really glad you enjoy the trainings and this one I think you will love as it combines lots of useful concepts into a single video and training.