📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm
@hirukarucm1133
3 жыл бұрын
So many great tutorials. Now i have to find a way that excel create a word document in a specific folder (if column c = 2020 then foldee 2020) and giving the document a name with info in the spreadsheet table. And then placing a link to that document in the excel. (student tracking database) where lots of text needs to be written without losing track of it.. Any suggestions?
@ExcelForFreelancers
3 жыл бұрын
Hi and thanks so much. you can create a full file path and pace it in Word. I believe you can insert hyperlinks word document using the Hyperlinks.Add command. More info on that here: docs.microsoft.com/en-us/office/vba/api/Word.Hyperlinks.Add
@sachinshinde5997
4 жыл бұрын
This is very helpful... Sir is this possible using Gmail account instead of outlook account.. If yes please make video on it.... I will be very thankful to you...
@ExcelForFreelancers
4 жыл бұрын
Hi thanks yes you can use gmail. just search my channel for "Without Outlook" as I have a video on that. Thank you for your Likes, Shares & Comments. It really helps.
@mindtricky
3 жыл бұрын
In the loop that copies all the data, how do u send currency that formatted as currency in word?
@ExcelForFreelancers
3 жыл бұрын
Hi and thanks for your comment. I have another video that allows you to customize the formats for this here: kzitem.info/news/bejne/xGqN3Ip9b6x2hpw Thank you for your Likes, Shares & Comments. It really helps.
@langent4653
6 жыл бұрын
Randy, you are a genius at extending Excels capabilities far beyond what MS intended lol. I have been doing the very same for many years and always enjoyed the "Deer in the headlight" look from our desk side support and application architecture group. Keep those videos and incredibly valuable open source content coming. My hats off to you sir :)
@ExcelForFreelancers
6 жыл бұрын
Thank you so much for your comment and fantastic that you have the same approach. I just tell people when trying to come up with solutions "Don't think about Excel" , meaning figure out what solution you want, how you want it to look and THEN figure out a way how Excel can do that for you. Excel is our canvas in which we apply our art.
@samratsen6336
3 жыл бұрын
This macro code is successfully creating the Word Document, after adding MS Word Object Library in Tools>References. However, it's not creating the PDF document, when the PDF option is selected. Any suggestions?
@ExcelForFreelancers
3 жыл бұрын
Hi and thanks you so much. You can print to any pdf by using the ExportAsFixedFormat function in 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
@queenm5962
4 жыл бұрын
hello Sir i am trying to follow your cod to create a macro to import template but when i run the macro i get an error: "runtime error 438 OBJECT DOESN'T SUPPORT THIS PROPERTY " how can i fix it i do not know what that means i just started learning to code
@ExcelForFreelancers
4 жыл бұрын
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 30,000 Members who would love to help you with this. Thanks so much.
@kanishktuplondhe8501
5 жыл бұрын
Sir, Can you help me with the above code below With WordDoc.Content.Find .Text = TagName .Replace.Text = TagValue .Wrap = wdFindContinue .Execute Repalce:=wdReplaceAll ', Forward:=True, Wrap:=wdFindContinue End With From Above code wdfindcontinue and wdreplaceall do not update my value in word documents where I am wrong pls help me out
@ExcelForFreelancers
5 жыл бұрын
Hi Kanishk make sure you have selected the reference libraries in the tools menu. Its hard to know exactly the 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
@abhishekbaguldesign
4 жыл бұрын
I am not sure, but my document is closing before printing and also attachment is not working :( Although the document is huge with like 6000+ words
@ExcelForFreelancers
4 жыл бұрын
Hi it would be difficult to know why without seeing your code. Can you create a post in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel with all of the screenshots and code and your exact issue so we can help you. We have 25,000 developers in our group. Thanks so much.
@ayyoobtk4588
3 жыл бұрын
Hi sir, The print option not working for me , I choose default printer Microsoft pdf and adobe pdf also… Where will be the default pdf saved location..
@ExcelForFreelancers
3 жыл бұрын
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 40,000 Members who would love to help you with this. Thanks so much.
@DoraDing-i6w
Жыл бұрын
This super great tool! May I Know how to download the file, the above link is not working...Thank you!
@ExcelForFreelancers
Жыл бұрын
Hi and thanks very much. I have clicked the download link and it seemed to work fine for me, what was the issue you had? Which link did you click? Thanks again
@hassanjabali1587
3 жыл бұрын
Hi, what if I don't want to use outlook for emailing, is there a way to use a different program? and can I just save the word documents generated instead of going through the email option. I would like to go through the documents before sending them if they are for certain clients.
@ExcelForFreelancers
3 жыл бұрын
Hi and thanks so much. I have created a training just for that right here: kzitem.info/news/bejne/uKV524Z8fqdydpw I hope this helps and thanks so much.
@andrypetrus3637
2 жыл бұрын
hi sir, appreciated for ur really good video. if may i’m gona to ask why having error run it on office 2013, compile error at word apps
@ExcelForFreelancers
2 жыл бұрын
Hi and thanks Andry. You are probably missing a reference library. IN the VBA editor, reset any macros, and then go to Tools > References and look for any item such as Word library that might be missing. Then scroll down, find a similar one, and select it. This should prevent the bug. 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
@surveyreadyTX
2 жыл бұрын
I need this for work. I have 6 different letter templates that must be sent to parents pertaining to discipline when there is an infraction by a student. Do you have a template?
@ExcelForFreelancers
2 жыл бұрын
Hi Nicki, thanks so much. 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.
@azumahia
2 жыл бұрын
Could you demonstrate this in LibreOffice Calc 7.2 or lates version?
@ExcelForFreelancers
2 жыл бұрын
Hi and thanks for your comment. My training videos are only in Excel. I hope this helps and thanks so much.
@BobbyOrnelasSr
5 жыл бұрын
Hello sir. I was using your tutorial and get an error code for the following area: Dim WordContent As Word.Range
@ExcelForFreelancers
5 жыл бұрын
You are probably missing the Reference Library. IN your VBA Editor go to Tools > References and then check for anything MISSING. Make sure you scroll down and select a Microsoft Word Library. Also, i show you how in this newer video on the same subject here including how to format values that go into word here: kzitem.info/news/bejne/xGqN3Ip9b6x2hpw
@mealax
3 жыл бұрын
Un-believable, Thank you Sir, I am much happy to see this video, thankyou thankyou thankyou so much for sharing this one. I pray for you for your this effort
@ExcelForFreelancers
3 жыл бұрын
For sure, you are very welcome I am so glad you liked it.
@danielheumann
2 жыл бұрын
I used this for my job, and for some reason when I execute the code it will not go into the for next loop. Maybe you have an idea as to why?
@ExcelForFreelancers
2 жыл бұрын
Hi and thanks it would be difficult to know why, however if you step through the code using F8 you can follow along to see where the issue is. 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
@amadanes
3 жыл бұрын
how can I download this spreadsheet? is it available in any of your workbook packages?
@ExcelForFreelancers
3 жыл бұрын
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.
@hassanjabali1587
3 жыл бұрын
I can't find the word documents generated or able to email through outlook. what could be the problem?
@ExcelForFreelancers
3 жыл бұрын
Hi and thanks you can use the VBA Save command for word to save it in a specific location. Once you have that file location you can then add the attachment in an email. I hope this helps and thanks so much.
@SUR-NI-VARA
3 жыл бұрын
👍 Can you please have Gmail setup instead outlook, option to send or save as draft. Thank you
@ExcelForFreelancers
3 жыл бұрын
HI nd thanks for your comment. I do have that already right here: kzitem.info/news/bejne/zX6Klqlos3hzooY I hope this helps and thanks so much.
@faisalrazzaq7136
4 жыл бұрын
i have error on update template .......can't find project or library
@ExcelForFreelancers
4 жыл бұрын
Hi Faisal, You are probably missing the Microsoft Word Object Library. You can find this by first resetting any bugs in the VBA Editor, then also in the VBA Editor go to Tools > References and then searching down the list for any Microsoft Word Object Library. (Any #) Select this, and unselect any item that shows "MISSING". 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
@Moc2Talk
4 жыл бұрын
Dear Sir, This only work when i open Refeference --> Tool and check Microsoft Word X.x Object Library (In my computer X.x is 16.0). Is there anyway not have to check this box. Beside, when i try to delete the word-document, some time error "The action cant be completed because the file is open in Word 2016".
@Moc2Talk
4 жыл бұрын
the second issue is solved when i have the row : wordApp.quit (My mistake) but i still dont know how to solve the first Problem. Waitting for your reply sir.
@ExcelForFreelancers
4 жыл бұрын
HI and thanks you will want to research 'Late Binding' so that you can Dim the Work applications as objects and then set them later in the code. I hope this helps and thanks.
@tukez3785
Жыл бұрын
Hi! If you filter your data, how can you go through only visible rows?
@ExcelForFreelancers
Жыл бұрын
Hi and thanks, you can run a loop through vba and check if a row is hidden or not (Range("1:1").entirerow.hidden= true ? Then do something based on if it is true 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
@ME-pu1pp
Жыл бұрын
Hi sir. Thankyou for this. I have 1 question. Do you know how to import the data from another excel? I don't want to write the data one by one, instead I want to import it from another existed excel. Is it possible? Do you know any method to achieve this??
@ExcelForFreelancers
Жыл бұрын
Hi and yes sure its possible. I created a series called 'Import Manager' in which I show you how to do that. You can locate this series of videos in my Playlists. I hope this helps and thanks so much.
@ME-pu1pp
Жыл бұрын
@@ExcelForFreelancers waaaah thanks a lot sir. Your videos are the best👍🏻
@kingimad6243
4 жыл бұрын
Good morning all, I have a problem with (Dim WordContent As Word.Range) it makes error when i start the macro "compilation error"...Please help me😔
@ExcelForFreelancers
4 жыл бұрын
Hi King make sure you to into the VBA Editor into Tooks > References and look for the MISSING word library. Then scroll down and find the Word Library and select it. This will fix the issue.
@kingimad6243
4 жыл бұрын
@@ExcelForFreelancers Thank you so much for your help
@ravis3165
4 жыл бұрын
Sir if we add additional coloum report not generated. Kindly help us
@ExcelForFreelancers
4 жыл бұрын
Hi if you add any columns or rows the VBA code, formulas and perhaps the formats will also need to be updated accordingly. This required advanced VBA knowledge. If you try it and run into a specific problem feel free to upload your questions in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
@rahulk7738
2 жыл бұрын
Awesome! Is it possible to replace a phrase in the template with a paragraph.
@ExcelForFreelancers
2 жыл бұрын
Yes sure, you can create a table with the first column being phrases and the 2nd column being paragraphs. You can use an Index/Match formula to match them up and replace them. 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
@vikas3217
2 жыл бұрын
Is it possible that as soon as I update the following details in some headers in Excel, the data in multiple Microsoft Word files (attached to the Excel file) get updated automatically and also save all the updated Microsoft Word files in one folder? Does it, from the given unique number in Excel? Excel Header Detail A B C D 1 Name Unique Number Mobile Number Value 2 3 4 5 6
@ExcelForFreelancers
2 жыл бұрын
Hi and thanks, Yes i believe that it is possible however it is not something that can be answered here. Please post your detailed question, with screenshots 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.
@vikas3217
2 жыл бұрын
@@ExcelForFreelancers Request to join the group is pending approval, and the Post option is not available......???
@ExcelForFreelancers
2 жыл бұрын
HI and thanks, if you are still having issue to get added, or posting to the group, please check with our admin here shane@ExcelForFreelancers.com I hope this helps and thanks so much.
@אולגהגילשטיין
3 жыл бұрын
Hello and thanks for the tutorial. but i have a problem: i don't get any error messages, but only the word application is opening and not the word template... the template is stored in onedrive. may it be the problem?
@ExcelForFreelancers
3 жыл бұрын
Hi and thanks it could be the problem since OneDrive acts a bit different, Try moving the file to outside of OneDrive and see if you get the same 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
@אולגהגילשטיין
3 жыл бұрын
@@ExcelForFreelancers thanks. didn't help. joined the group. thanks for invite.
@rajughimire6317
3 жыл бұрын
Are these codes same for Office 365. And why it is showing Compile error "user-defined type not defined". Need your help
@ExcelForFreelancers
3 жыл бұрын
Hi Raju, 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.
@rajughimire6317
3 жыл бұрын
Hi thanks for this wonderful codes & tutorial. I made it work but could you guide a bit more; if I want to send email, say a confirmation letter using template & a customer ledger together. What vba code I need to use if I want to send 2 files per Customer at same time.
@tgmcnaughton
4 жыл бұрын
Hi Rick, I bought the "150 Workbooks" product and have extracted it. I am interested in this lesson - the "Custom Letter Creator." I can open and view the file, but no Word Templates are included. Am I missing something? Shall I make my own? Would be nice to have your templates to work from. I have an Office365 subscription. Thanks, Tim McNaughton
@tgmcnaughton
4 жыл бұрын
no problem - was very easy to make my own. Thanks.
@ExcelForFreelancers
4 жыл бұрын
HI Tim, thanks so much for your purchase. I really appreciate it. You can use any Word document you want, or just create your own templates in just a few minutes. Any Word document at all would work just fine.
@tgmcnaughton
4 жыл бұрын
@@ExcelForFreelancers thanks much. Your materials really helped me solve a big challenge.
@rabinshrestha9335
Жыл бұрын
"Cannot run the macro... the macro may not be available in this workbook." I am getting this Warning Sign an couldnt Enale Macro. Please help.
@ExcelForFreelancers
Жыл бұрын
Hi and thanks for your email. Microsoft has some new security, blocking macros for downloaded Excel files. I show you how to fix this once and for all for any of my downloaded files here: www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
@rabinshrestha9335
Жыл бұрын
Thank You. I think would be more customizable, if there was option whether to save only option along with print and email.
@ExcelForFreelancers
Жыл бұрын
HI and thanks, you are welcome to download and customize this template however you like. I hope this helps and thanks so much.
@monicaxix
4 жыл бұрын
@11:23, what does DocTemplate refer to please?
@ExcelForFreelancers
4 жыл бұрын
HI Monica that refers to a Word Document. Thanks very much for your comment.
@altostrata7018
3 жыл бұрын
What versions of Excel and Word are required to do this?
@ExcelForFreelancers
3 жыл бұрын
HI Alto, you can use any version of Excel. I used 2010 to create this. I hope this helps and thanks so much.
@91alezander
4 жыл бұрын
Hello Sir, can we increase the excel 255 character limit?
@ExcelForFreelancers
4 жыл бұрын
HI and thanks for your comment. There are some possible solutions to this limit discussed here: stackoverflow.com/questions/12386414/excel-use-formula-longer-that-255-characters
@sandriduplessis9345
3 жыл бұрын
Can I change it to throw all the docs into a folder and not email them?
@ExcelForFreelancers
3 жыл бұрын
HI Sandri, thanks so much for your comment. Yes you can. You can use Excel's 'Export To PDF' feature which will save the PDF in a folder within your computer. Just check to make sure you don't already have a file by that name within that folder. 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
@sijusivan77
3 жыл бұрын
Hi, Is it possible to set a password on the generated PDF file automatically ?
@ExcelForFreelancers
3 жыл бұрын
Hi and thanks It may be possible but its based on your PDF software. Put your mouse away and learn how to add a password using your keyboard only inside your PDF software. If that works then write out all the steps and put that into Sendkeys. You can also try a PDF API, there are a few in Integromat which may help you do this from Excel. 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
@sijusivan77
3 жыл бұрын
@@ExcelForFreelancers Thank you so much for the response!
@betopalou7772
2 жыл бұрын
Fantastic work, really useful. But I have a problem trying to run the macro whit "Set WordTempLoc = Application.FileDialog(msoFileDialogFilePicker)". WordTempLoc is Nothing. Could you help me?
@ExcelForFreelancers
2 жыл бұрын
Thank you so very much, I really appreciate that. This issue could happen on a Mac computer which uses different code in which you can find here 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
@betopalou7772
2 жыл бұрын
Many thanks!! Is it possible to format the targets written in the Word document?
@ExcelForFreelancers
2 жыл бұрын
Yes Beto, it is. In fact I created an updated video on exactly how to do this here: kzitem.info/news/bejne/xGqN3Ip9b6x2hpw I hope this helps and thanks so much.
@betopalou7772
2 жыл бұрын
@@ExcelForFreelancers Great Macro!! I’ve seen it and it’s really useful. I only have another question, if I may. I’ve tried with number format where miles separator is “.” and “,” is for decimals, but it seems that it’s not working despite my excel has that configuration. Do you know how to fix it?
@LuxmeInternational
4 жыл бұрын
Very informative video. I tried flowing along, but the workbook doesn't work. I cannot add a template.
@ExcelForFreelancers
4 жыл бұрын
Hi I am glad you like the video. Make sure you download the free sample 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
@JoeWard101
2 жыл бұрын
do you have an example file such as the one in the video?
@ExcelForFreelancers
2 жыл бұрын
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.
@sunil9866195443
6 жыл бұрын
When we try to check the code.. there is an error appearing for "WordContent As Word.Range".. the message appears as "Compile Error: User-defined type not defined".. Can you help me on this..
@ExcelForFreelancers
6 жыл бұрын
Hi you are probably missing a Library. in the VBA Editor go to Tools, then References and add Microsoft Office Word Library. If you have specific questions on this please join our Facebook group and post your questions here: Http://bit.ly/groupexcel
@danielchacreton2401
5 жыл бұрын
I had the same issue. That fixed it. Thanks. This video is amazing. You have saved me and my staff hours of work!!@@ExcelForFreelancers
@fuzzyfernie
5 жыл бұрын
Does anyone know how to add a field which depending on the world selected would turn into checkboxes? For example have a with either clickedbox or emptybox as the criteria. If the word clickedbox is in the list a checkedbox would show up on the pdf and if empty box then an unchecked box would show up on the pdf.
@ExcelForFreelancers
5 жыл бұрын
Generally in PDF's you can check a box using the space bar, and if you want to skip the checkbox, without checking it use tab. So if in Excel you have a True/ False option to check the pdf you could do something like: If Sheet1.Range("A1").value = True then 'Check SendKeys " " SendKeys "{TAB}" Else: SendKeys "{TAB}" End If Something like that would work as we are using the space to check, then tabbing, or tabbing without space. 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
@91alezander
4 жыл бұрын
It is possible to generate a word template from every excel row individually. In excel I need a button to appear on every new row I populate with data and the button must open the word template that was fill with the data that I populate the row. And also i need the autofill word template to be save in a specified location. Thank you!
@ExcelForFreelancers
4 жыл бұрын
Hello Alex, yes that is certainly possible. You can add a single button on your sheet which will change positions as you select a row (See my video on in-line row controls here: kzitem.info/news/bejne/2YWNsH2igGqJeHo ) You can then auto-fill, format the word document and save it with a custom name in a a specific location using this training here: kzitem.info/news/bejne/xGqN3Ip9b6x2hpw I hope this helps and thanks.
@91alezander
4 жыл бұрын
@@ExcelForFreelancers Can you tel me what line of code to use to open and save de pdf. file that is atash to the email? Thank you so much for your answer and keep up the good work.
@ExcelForFreelancers
4 жыл бұрын
Hi Alex, I have a video coming out tomorrow that will answer all of these questions. Here is the link so when it is released tomorrow make sure you watch it: kzitem.info/news/bejne/l5yl2mWKmJlil4I
@ankitvasudev2008
4 жыл бұрын
Can i get the VBA coding for the same..
@ExcelForFreelancers
4 жыл бұрын
Hi Ankit, 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.
@madamemonsieurhartnell8725
2 жыл бұрын
This is an incredible resource and has helped us to create individual login information pages for our students, with all of their login information for different sites we use in the classroom. I'd like to use this to now make some custom cards that we can use in the classroom. I'd like to use a PowerPoint template instead of a Word Template. How do I change the VBA to PowerPoint values? Thank you!
@ExcelForFreelancers
2 жыл бұрын
Hi and thanks so much. I would be unable to write the code for that in a KZitem comment however if you would like some help, I would be happy to refer you to a qualified developer. Please feel free to email me your detailed specifications here; kzitem.info
@vijayrawat5
6 ай бұрын
Excellent video. With this video i built a project in my previous job too helpful for the organization.
@ExcelForFreelancers
6 ай бұрын
wow that is great to hear and I am happy to help and share
@MrDannySanders
4 жыл бұрын
I read somewhere that Dim WordDoc, WordApp, Outmail as Object . Wil only declare the last one (Outmail) as Object and the others as Variant..
@ExcelForFreelancers
4 жыл бұрын
Hi Danny, you are correct. I had read that too. In any of my newer videos I declare each variable separately. I used to try to save space however theoretically this could cause errors in some applications, so you will see now in the newer videos I will declare each one. Thanks for the comment. Much appreciated.
@michalfrankowski5328
5 жыл бұрын
Just need some help. I have used your method to create PDF, but I cannot open it. I have msg: "the document is damaged and cannot be repaired. Adobe Reader could not open because it is either not a supported file type or because the file has been damaged (for example, it was sent as an email attachment and wasn't correctly decoded)." I cannot find the solution, any advise ?
@ExcelForFreelancers
5 жыл бұрын
Hi thanks for your comment. I have not had that issue with PDF's so it would be difficult for me to determine a solution. Perhaps a Google search of the error might be helpful.
@AnhTran-vf1pj
2 жыл бұрын
How to use data from multiple rows for 1 email?
@ExcelForFreelancers
2 жыл бұрын
HI and thanks very much. You can run and advanced filter and then loop through all of the associated rows. I hope this helps and thanks so much.
@shubhasis85
4 жыл бұрын
This is an excellent tutorial and excellent materials.However when i am trying to execute your code(2nd Part) creat word docs it is giving me compiling error like:Invalid outside procedure and Highlighting on with sheet 1 which is in 6th line.Can you please help me.
@ExcelForFreelancers
4 жыл бұрын
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 30,000 Members who would love to help you with this. Thanks so much.
@saraducky
4 жыл бұрын
How would you do this exact same activity but with more than one database information.... example if you often write to particular medical providers, but then you also need to select a particular person or claimant in which has different set of data... example address, dob, date of accident, client name,email or mail specifications based on clients preference
@ExcelForFreelancers
4 жыл бұрын
Hi Sara, you can download my application and customize it for multiple databases, however if you need help with customizing this I can refer you to a a developer who can take care of this for you. Please feel free to email me a detailed scope of your project here: Randy@ExcelForFreelancers.com
@tylerwade9123
4 жыл бұрын
I get my Word Application running but the Document itself doesn't open. Nor is it saving anywhere
@ExcelForFreelancers
4 жыл бұрын
HI Tyler, thanks for your comment. We would have to see your code and pictures of your sheet. Can you upload them in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel so that our members can help you out with that? Thanks very much.
@wasabeiwant
6 жыл бұрын
it is showing me an error with the "Dim WordContent as Word.Range" highlighting Word.Range, saying it is not defined, do I have to add something? Great video.
@ExcelForFreelancers
6 жыл бұрын
Hi Bruno, Thanks for posting your question in our group. I was able to answer your question there with the screenshot on your missing libraries. I am happy its working now. (For others feel free to join our facebook group here: bit.ly/groupexcel )
@meetadii
5 жыл бұрын
@@ExcelForFreelancers ... I am facing error 438 i.e Object doesn't support this property or method. Thanks for video
@kingimad6243
4 жыл бұрын
Did you fix it?? I have the same problem when i created my own workbook but on his workbook it works fine with the same code, I can't understand why
@noahluck1504
5 жыл бұрын
If the text I want to replace the placeholder with has multiple line breaks but I don't want to split it onto different cells, is there a way to make Word recognize these line breaks and fill in the text accordingly? Thanks.
@ExcelForFreelancers
5 жыл бұрын
Hi Noah, yes I believe there is a way to recognize line breaks in Excel, you can use the Replace command and look for Char(10) then replace with is with perhaps VbCr. I did this in one of my videos however I am not sure which one. 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
@silverfunnel6819
4 жыл бұрын
This will save me so much time. Many thanks! LIKEd and SUBSCRIBEd.
@ExcelForFreelancers
4 жыл бұрын
Glad it helped and thanks so much.
@ericrichardson2923
4 жыл бұрын
What if one of my fields will contain a list of names greater than 256k? How can I modify the VBA for this?
@ExcelForFreelancers
4 жыл бұрын
Hi you will want to limit it within 256 Characters to break it up into multiple fields either with VBA or formulas. 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
@alencherian
4 жыл бұрын
Hai... am newbie to excel.. Pls help me in adding template... when i click on add template.. it shows "compile error cant find project or library"
@ExcelForFreelancers
4 жыл бұрын
Hi Juan, In your VBA Editor, make sure to reset any bugs and then go to Tools, References and scroll down and select the Microsoft Word Object Library, this will fix that 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
@chrisllabres916
4 жыл бұрын
Hi - this is great. I've replicated this process and am trying to have more text inserted to a field in word, . The text I have is a rather long description. Every other field i have is relatively short and populates with ease. However these will not populate. Any suggestions?
@ExcelForFreelancers
4 жыл бұрын
Hi Rant, there is a 256 character limit when adding string variables so you may want to separate them if they are larger. 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
@simonleipold3072
3 жыл бұрын
Great work ☝️👍👍👍 can you show us the code how can I transfer pictures from excel to word? Vba
@ExcelForFreelancers
3 жыл бұрын
Thank you Simon. I will do my best to get that done for you. Much appreciated.
@madscientist2577
2 жыл бұрын
you are awesome. This is a great tutorial
@ExcelForFreelancers
2 жыл бұрын
Thank you so very much, I really appreciate that.
@eurikamerleau
5 жыл бұрын
I'm curious if this could also be applied to InDesign templates?
@ExcelForFreelancers
5 жыл бұрын
I believe it is possible and for Adobe products we do have the ability to add data to fillable PDF's (using pdfs created by Adobe InDesign) You can see more in this video: kzitem.info/news/bejne/1otrm3p5m4J5dn4
@khrikette
3 жыл бұрын
Hello! Just came across your video. This is the closest dream letter creator I could find. My question to you is, is there away to keep a continuous tracking system of what was mailed/emailed? I'm working on a large file for my employer and would like to be able to automate that tracking as well. I appreciate your time!
@ExcelForFreelancers
3 жыл бұрын
HI and thanks so much. Certainly you can keep an email log. On a separate sheet determine what information you want saved and then for each email created add a new line to that log. I hope this helps and thanks so much. 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
@jamespearson3378
4 жыл бұрын
I have a question around the template you're using, "Customizable Letter Creator". Did you create this yourself, or is it available somewhere for download? I can't seem to find it anywhere.
@ExcelForFreelancers
4 жыл бұрын
Hi James thanks very much. This is just a simple letter I created in Word. You can create your own in just a few minutes. As far as the Excel application you can download a free copy of that using the links in the description. Thank you for your Likes, Shares & Comments. It really helps.
@juliank4835
5 жыл бұрын
Thank you for this really nice Video! I tried to replace a part of the header (Section 4 in the Word Template) but it doesn`t work. Can you help me, how i can integrate this into the replacement sector?
@ExcelForFreelancers
5 жыл бұрын
Hi you may want to download my sample to help you follow along. 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
@syvqcool3095
4 жыл бұрын
hello i have a question. I try this coding but for when i click the create new for word it didnt function, why?
@ExcelForFreelancers
4 жыл бұрын
Please keep in mind that this requires advanced VBA knowledge to customize. Please feel free to upload your question in our Excel For Freelancers group here: bit.ly/groupexcel
@netrubha
4 жыл бұрын
Thank You for Your Video Tutorial.. Is it possible to get an output as ZIP file (containing multiple different unique Word templates) or directly save multiple word files based on a selection.. This will reduce a lot more time taken for generating each and every template document for a given. I am planning to use this for generating a set of documents for a given record, which needs to used for documentation in finance sector.
@ExcelForFreelancers
4 жыл бұрын
Yes certainly it is possible. This video I created on Zipping files should help you out: kzitem.info/news/bejne/0JuJr3ZrfXWYjaA
@deomanchinchole5393
3 жыл бұрын
It's nice but can we add attachment to it?
@ExcelForFreelancers
3 жыл бұрын
Hi Deoman, thanks so much, yes sure you can. You can search my channel for "Attachments" and find a few lessons on the subject. I hope this helps and thanks so much.
@xikopakau6672
3 жыл бұрын
Hello... Thanks for this video!!!! However, can we do the link from excel cells to the word document on the Header and/or Footer?
@ExcelForFreelancers
3 жыл бұрын
Hi and thanks yes you can also customize the header and footer within VBA. Here is a link on how to do that. docs.microsoft.com/en-us/office/vba/api/word.headerfooter
@KhanhLinh-zc9ln
4 жыл бұрын
I have heard that this method is applied for word document that less then 255 letters. Is that true? If true what about doc more than 255 letters?. Tks
@ExcelForFreelancers
4 жыл бұрын
Hi Khanh thanks for your comment. I will want to limit your text to 255 characters to apply this type of solution, otherwise you would need VBA or formulas to parse the text into different cells. 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
@RussCrowley
3 жыл бұрын
Your work is superlative, Randy. I'm v. good with Word, but this is Excel-eye-opening.
@ExcelForFreelancers
3 жыл бұрын
Thank you so very much, I really appreciate that Russ.
@noelcardona2057
4 жыл бұрын
Hi there, I bought this but it is not working. Saying "Error in loading DLL" and also not finding library.
@ExcelForFreelancers
4 жыл бұрын
Hello Noel, thanks for your comment. I also answered your email, so check your inbox for detailed instructions. Basically its a very easy fix, You are missing a Microsoft Word Library that you can select within the VBA Editor go to Tools > References and scroll down to find any Microsoft Word Library. Also unselect any item that might show MISSING. Also feel free to search google for 'Excel VBA Missing Library. 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
@gagandeepnagi3354
4 жыл бұрын
Hi Team, is there a possibility to add password for the PDF file generated via this tool. It would be really helpful. Regards Gagan
@ExcelForFreelancers
4 жыл бұрын
Hi thanks it all depends on the PDF application you are using. Thank you for your Likes, Shares & Comments. It really helps.
@gagandeepnagi3354
4 жыл бұрын
Excel For Freelancers i am using acrobat reader dc, do i need a specific pdf application to get the password applied via the vba code.
@ExcelForFreelancers
4 жыл бұрын
You can use anyone you like. My favorite is Foxit PDF Reader. Thanks for your feedback and question.
@gagandeepnagi3354
4 жыл бұрын
@@ExcelForFreelancers i am struggling to write the macro code to save the PDF with a password..any leads or code would be appreciated. Thank you.
@abdulhamidalhaddadi2255
Жыл бұрын
Thank you, it is a bit hard for me😓
@ExcelForFreelancers
Жыл бұрын
For sure, you are very welcome, these things take time to learn, so please be patient
@sonigaurav22
6 жыл бұрын
How to save each word file ina folder matching criteria....
@ExcelForFreelancers
6 жыл бұрын
Hi there are a few ways using SendKeys and VBA using Save As, depending upon your criteria. You can also create dynamic folders as well like i have shown in this Attachments Video: kzitem.info/news/bejne/2ppouaJsbZqZpHY 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 with code screenshots here:bit.ly/groupexcel
@jawadkhan4786
4 жыл бұрын
When I click on the button, a glitch appears on the word icon but word document is not opening. Anyone help me with this please
@ExcelForFreelancers
4 жыл бұрын
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 30,000 Members who would love to help you with this. Thanks so much.
@felixbianchidicarcano4821
4 жыл бұрын
Hello! I tried modifing the code for it to save a pdf file instead of sending it, yet when I try to open the created PDF file it does not open since it is corrupted. Any idea why this could happen?
@ExcelForFreelancers
4 жыл бұрын
Hi Felix the PDF may not have been saved properly as a pdf. You would want to make sure to export as pdf or print to 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
@sarahuntington7749
4 жыл бұрын
Hi Randy! First off you are awesome! Thank you for posting this tutorial. I have a question regarding the Word Letter name/address fields. I have coded for 2 names...but there's not always a 2nd person. Same for address. I have the address set up as mailing address 1, mailing address 2 (apartment number, etc.) and mailing city, state, and zip. Sometimes there's no 2nd person or mailing address 2 and then I have a blank spot in my name/address area in the word doc. What would be the simplest way to remove the blank spots in the address without having to manually format each word letter? Thank you in advance!
@ExcelForFreelancers
4 жыл бұрын
Hi Sara, Thanks for your comment and I am glad you enjoyed the training. You can wrap the replacement statement in an If/Then statement to run a test in Excel first to see if there is a value, if not, then remove the inside Word and replace it with nothing, otherwise replace it with the 2nd name. I hope this helps and thanks.
@SayaWRT
5 жыл бұрын
hello Randy. glad to be able to get this valuable info. because I've also been looking for a tutorial like this for a long time. I hope you can read my comments and give me an explanation.
@SayaWRT
5 жыл бұрын
I just want to use one filter to export documents. So it's only L3. then after that print. How do I delete N3 code in VBA?
@SayaWRT
5 жыл бұрын
Or if I replace it with an ID code for print, suppose I replace the daysince in column M. Become the ID in column E ...? Can it.?
@ExcelForFreelancers
5 жыл бұрын
HI Rifki, make sure you download my sample from the description. You can then replace any columns with any data you like, or add new columns. You will have to make updates the variables according to my training. Since I can't see your actual application it is hard to give you advice on that however 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
@SayaWRT
5 жыл бұрын
@@ExcelForFreelancers thank you Randy, this indeed requires high accuracy and must also be focused. I was finally able to create a database for the school where I worked, which I usually make with manual letters this time easily just by making a template. if you want to see the database that I have created based on this video tutorial. You can check on my IG @SayaWRT. thanks. maybe I will often watch your other videos then I learn. the knowledge you give is very valuable. I'm using google translate
@devesh938
6 ай бұрын
Fantastic session, To the point and very helpful. I saw the whole video and I do have a question related to it. what to do if we need to create a single word document for a customer having multiple line items or multiple details. Will storing unique items in VBA dictionary work ?
@ExcelForFreelancers
6 ай бұрын
HI and thanks yes you can do that for sure, however you can also use VBA to loop through the related customer data. For example lets say you have a Customer Table and you need information from that customer table, and you also have an Invoice Table with customer details. You would extract information from that customer, and then also you would use the customer iD to run and advanced filter using the customer id or perhaps the invoice id and extract the results of the data to add to your letter. I hope this helps and thanks so much.
@devesh938
6 ай бұрын
@@ExcelForFreelancers thank you so much. it worked perfectly as expected.🙌
@ExcelForFreelancers
6 ай бұрын
Ok great, I am happy to help
@devesh938
6 ай бұрын
Hi @@ExcelForFreelancers , would you be kind to assist as every time i use the storage or loop it only work for one particular tag name. same details are updated in every tag name. to understand what i'm trying to do we can change the first and last name with the entities name and in place of last appt. date we can have account numbers. so i need to create unique word document basis the template i have. End result should be only one document saved for unique entity name and document should contain all the account number provided in the data against unique entity. so if an entity appear in data 5 times then only one document should be created and since all details except account number are same they will be updated as they are only once and for account number if it appears 5 different types then it should update the tag name as (a/c1 & a/c2 & a/c3 and so on). would be a great help if you can spare some time and help me out. 🙌
@ExcelForFreelancers
6 ай бұрын
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.
@debarnobsarkar9025
3 жыл бұрын
Hi! Thanks a lot for this video. Is there any way that I can copy the value from Excel to word in the same format as it was in the Excel? Your help will be highly appreciated!
@ExcelForFreelancers
3 жыл бұрын
Hi and yes you can use this video training here to do that: kzitem.info/news/bejne/xGqN3Ip9b6x2hpw
@akashdhobale540
4 жыл бұрын
how can we change the mail client from outlook to chrome? Or say default mail client.
@ExcelForFreelancers
4 жыл бұрын
Hi Akash the default mail client is handled by your computer so that when clicking on an email client, the application will look to the default client within windows. Thank you for your Likes, Shares & Comments. It really helps.
@akashdhobale540
4 жыл бұрын
Actually I was asking in relevance with this VBA code. It opens in Outlook as we have written in VBA. My default mail client is set to chrome >handlers>Gmail. Is there any way I could use chrome instead of outlook
@ExcelForFreelancers
4 жыл бұрын
I also have Gmail too, so just use Outlook to send Gmail, and not use it for anything else. Its much easier and works great. No need to make it more difficult, however i do have training that sends emails without Outlook here: kzitem.info/news/bejne/uKV524Z8fqdydpw
@snehamishra7269
3 жыл бұрын
🤗🤗🥰😃
@ExcelForFreelancers
3 жыл бұрын
Thank you very much. I do appreciate that.
@nrbrtmuller
4 жыл бұрын
Awesome tutorial, this could help me a lot. But I tried to add word template and get a runtime error 91, Object variable or with block not set. How can I fix that?
@ExcelForFreelancers
4 жыл бұрын
Hi Norbert check to make sure you have specified a sheet such as "With Sheet1" it would be hard to know the exact cause of the issue without seeing it. Can you upload screenshots of your code and application in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel Thanks so much.
@PedroAlves-hn4cp
5 жыл бұрын
I applied in a similar implementation with just Word creation but the altered Word file isn't generated. Any tips?
@ExcelForFreelancers
5 жыл бұрын
Hi thanks for your comment. It would be difficult to know the cause of the issue unless we see your application. Can you please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel and post your workbook and detailed issue with screenshots so we can help you with that. Thanks so much.
@PiNgPoNgLaDd10
4 жыл бұрын
Which video explains the "browse file dialog"? I cant get my code to work
@ExcelForFreelancers
4 жыл бұрын
Hi there are different procedures based on if you have a PC or Mac. If you have a mac there is a great site here: www.rondebruin.nl/mac/section3.htm If you have a PC you can search google or youtube for "Excel VBA Browse File or Folder" for detailed instructions.T Thanks very much.
@waqar918
3 жыл бұрын
dear sir, I want to create a marks sheet in MS Excel that will automatically creat a word file and then send it via WhatsApp please guide me
@ExcelForFreelancers
3 жыл бұрын
Hi and thanks for your comment. You will have to find a functioning API in order to send to Whatsapp. 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
@waqar918
3 жыл бұрын
@@ExcelForFreelancers dear sir i want some additional columns in the said sheet
@ExcelForFreelancers
3 жыл бұрын
You are welcome to customize the application however you like.
@ExcelForFreelancers
Жыл бұрын
Hello! I am very happy to share the news that I have created this training for you and it will be premiered this Tuesday September 12th. Please make sure to Like & Share it here: kzitem.info/news/bejne/tJmLqIecfqOUpY4
@brandonzayid3147
5 жыл бұрын
Can you possibly show/tell me how I might be able to add an attachment to the document that was created? I would like to add a tab on the excel workbook with a list of forms and have that list/table be put on the second page of the word document created.
@ExcelForFreelancers
5 жыл бұрын
Hi Brandon, thanks for your comment. I have created an Attachment Series (2 Parts) that I think you will find helpful here: kzitem.info/news/bejne/2ppouaJsbZqZpHY
@lamsontai
4 жыл бұрын
Could you please fix in case the length of the replacement text is over the limit ?
@ExcelForFreelancers
4 жыл бұрын
Hi thanks I you will want to split cells over the character limit. I hope this helps. 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
@lamsontai
4 жыл бұрын
@@ExcelForFreelancers thank you. Please accept my request for joining the group. Thanks.
@ExcelForFreelancers
4 жыл бұрын
Thanks hopefully my admins have accepted you. If not, please email angeli@ExcelForFreelancers.com Thank you.
@Dedalus94
2 жыл бұрын
Great tutorial! I know I'm late to the party here, but I had a couple questions if you had the time. Most importantly, how would one have the find and replace find and replace text in headers? Word has an option in advanced called "Search" and the drop-down "All" allows the f+r to search for text in headers but I don't know how to translate that to the code. Secondly, is it possible to have an option that just saves the letter (as a docx) rather than email or print it?
@ExcelForFreelancers
2 жыл бұрын
Hi and thanks. I have not tried using Find & replace with the headers, however with some research, I am sure you can find a way. You can save the word document through VBA certainly. 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
@SkyGenesis13
3 жыл бұрын
HOW TO INSERT THE TEMPLATE
@ExcelForFreelancers
3 жыл бұрын
Hi and thanks you just need the file path of the Word template. 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
@ds3417
4 жыл бұрын
Hi, i signed up for the free workbook "letter creator" but i still recieved anything, is it free?
@ExcelForFreelancers
4 жыл бұрын
Hi Dave, sorry about that. I think our email provider had a site issue for a few hours the other day this could have caused it. Can you email angeli@ExcelForFreelancers.com with the email you signed up with along with the workbook you are requesting and we will get that out to you. Thanks so much for your patience.
@kushkaushik6103
5 жыл бұрын
This is really a very powerful tool and that too for free and this is extremely customisable. Thanks for this
@ExcelForFreelancers
5 жыл бұрын
For sure, you are very welcome Kush. I am glad you liked it.
@DustinAldridgeBond
5 жыл бұрын
Can you share the code?
@ExcelForFreelancers
5 жыл бұрын
H Dustin, 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.
@Rain_theGamer
5 жыл бұрын
You structure your explanations really well I look forward to more videos
@ExcelForFreelancers
5 жыл бұрын
Thanks so much Erika, each and every Tuesday I have new videos. I really appreciate your kind words
@Otonieljn18
5 жыл бұрын
What if insted of using condiction i want to call the custom template with an ID Number? I would love to apply this an With an userform.
@ExcelForFreelancers
5 жыл бұрын
Hi Otoniel, You would just need to tie the Long File Name of the Word Document with the ID # so that when an ID # is selected the Word Document can be opened.
@chandantiwary5945
3 жыл бұрын
Dim wordcontent as word.range here i get a compile error why .pls help
@ExcelForFreelancers
3 жыл бұрын
HI and thanks for your comment. You will want to add a Word Library. IN your VBA Editor, reset any bugs, then go to Tools > References, then search for any "Microsoft Word Object Library" and add it. You can then rerun the code without the error. 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
@chandantiwary5945
3 жыл бұрын
@@ExcelForFreelancers thanks for quick reply, i did this step, error still occurred,how to clear bug
@ExcelForFreelancers
3 жыл бұрын
Hi Chandan, 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 30,000 Members who would love to help you with this. Thanks so much.
@vikashooda6146
4 жыл бұрын
Hi can i add columns in the excel sheet for changing more fields in excel templates.
@ExcelForFreelancers
4 жыл бұрын
Hi Vikas, thanks for your message and comment. You are free to add or remove columns or customize the application as you wish. Please keep in mind that changes within the worksheet will also require updates to the VBA 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
@CDA8615
2 жыл бұрын
This has to be the best instructional I have seen to date. I have seen a lot of good ones too. I am a beginner intermediate VBA user. The one thing I will point out though is you do have to go into VBA Editor and select Tools from the Menu and from References make sure that 'Microsoft Word Object Library is checked off for the DIm Word Content As Word.Range to work. I am sure this was mentioned in other lectures. I can't wait to see more Excel For Freelancers tutorials!
@ExcelForFreelancers
2 жыл бұрын
Hi Thomas, thanks so much for your comment. Yes, very true, however I try to use late binding whenever possible so that reference libraries are not required. I have an updated video on this in which you can also apply formats such as date and amounts here: kzitem.info/news/bejne/xGqN3Ip9b6x2hpw
@lifelessons9139
5 жыл бұрын
Brilliant work Mr. Randy Austin. Two Thumbs up for the amazing tips throughout the video. However i get stuck at the TagName and TagValue stage, when running the macro. Run-time Error '438' : Object doesn't support this property or method. Getting the variables correctly printed in immediate window, but Stuck when Replacing variables in WordDoc. --> Template Name: F:\Templates\CoverLetter-Story2.dotx --> SaveAsTemplName: F:\CoverLetterDir\2191_Story2_2019-05-16-15-45-04.pdf Any further help is appreciated. .
@ExcelForFreelancers
5 жыл бұрын
HI Life Lessons, thanks so much for your comment. I am glad you enjoy the training. It is hard to know the exact cause of your issue since I cannot see the code. Can you please upload a screenshot of your code and application in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel we have 18,000 members who can help you with this. Thanks so much.
Пікірлер: 591