Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan
Thank you, been searching for something at a beginner level for a while. Appreciate how slow the video goes. So many videos on RUclips move too quick and try to do too much.
Anupam, Sorry, I'm sooooo behind on my questions in my inbox, but I was able to film a new one for you on importing txt files straight to Excel with lots of side notes and helpful tips. Hope this helps you, should be ready tonight or tomorrow. Blessings, Dan
Love your videos!! It's possible to write a code in which can lookup through folders and subfolders the file names that has been added for example, today? Thanks a lot!!
Thank you so much dan that's a saving life tutorial. I have a quetion please! Can i add an automate fonctionality of the following list in row? 1-Creating file with a specified name from a cell data 2- saving file 3- opening the file Thanks in advance
Thanks a lot for video! One question, is it possible to make something like this but to transfer name of every excel sheet to the new word document page?
Hey!@ Thank you for this tutorial it has helped so much. Is there anyway to run this vba so that the information you want automatically transferred from excel sheet, goes to a preexisting word document that has a letterhead???
Hi. Is there a way to create several tables in excel and then import them into word using mail merge. So each table imported would be based on the page in mail merge?
Hello! I got an Excel function which ConvertNumToWords, May I exceute it in Word, so that I get the numbers in words right in the Word document? Thank you for share. Blessings!
i need to get something similar for Office 2001 for MAC. need EXCELL sheet converted to WORD for easy read. each row with many collums in excel has various txt data. i need each row to be converted into 1 word document so it’s easy to read. what would you charge? can you make that work in office 2011 for mac?
Great, I succeed. I like to apply this technic to my work. i have registration records in excel, and for each record I isseu a letter. how can I use my last record to my word document automaticly or can I make a drop down list related to excel file to select. if you have any idea.
hi there. hope you guys can help out. it's a similar situation in a userform in excel. i'd like to know how to add a text box wherein selected labels will appear with entered data in it. sort of like a summary of what you've entered to appear in a box in the same excel sheet. also, how do I add a time start-time start function button in excel userform. thanks a bunch.
it is a good information about export range from Excell to a Word. maybe you can show next step - how export many ranges with for example some view /as one page - from excell to a word. Anyway this wideo is really very good. Thanks for it.
Hello and thank you! I was just wondering, this would be useful to create letters in Word from Excel, so, how can I create spaces so that the content of other cells be inserted in the write place of the letter, for example; Date, Introduction, recipients name, and final comments, signature, thank you!
Hello , I have one question. I did a word file and I used developer and I want to use the protect form. Until here everything is OK but in my word file, there are some graphics. I want to enter some date into the graphic to change the figures (Sales Amounts) however because I used protect form , I am unable to change the graphics. " I can unprotect and change the graphic however my employee will use this form and thats why ı am protecting it. Is there any way you can help me ? I hope I express myself well. Thanks
I've done what you told. Unfortunately, my problem is way more complex. I've chaged the matrice so that the text is copied only If it has already been chosen by one of many CheckBoxes previously. The thing is, I cannot add 2 texts one after an other. The matrice stops at the second "Dim wApp As Word.Application" , meaning that this word application has already been launched, so I cannot ad anything to it. Could I put this line at last so that it opens only after every text is selected?
Wondering if anyone knows any way to speed up the process copy and paste paperwork? For work, I have forms that are a pape long that have to be created for around 30 different companies. The forms are all the same except for a few differences such as company names and addresses. The current way we do it is by having a template document and then typing or copy and paste in the needed information. This process can take a couple hours and I'm sure there's a better way to do it. The goal would be to have one document in excel that I could go in and list all the company's information and then it would automatically generate the needed documents. There's got to be a way to do it I just can't figure it out any help would be greatly appreciated.
What version of Excel are you using? I asked because of this error "Dim wrdApp As Word.Application" and I think its happens for this cause (version of Office. PS: I'm sorry for my english, I'm a brazilian!
Hey there! A quick question: Is there a way to save the file as docx, together with pdf? I want to have the pdf version of the document as well. Thanks!
First off let me say I am experienced with Excel but a real VBA newbie. I am playing with the function to add cell information to a Word document. Unfortunately I cannot get past the first "Set" to Create my Word Application Object. Since I am a newbie, I am sure I am missing something very simple. Dim wApp As Word.Application Dim wDoc As Word.Document Set wApp = CreateObject(Word.Application) wApp.Visible = True When I run this I get the following error: Run-time error '429': ActiveX component can't create object I would appreciate any help I can get. Thanks.
A little late but: CreateObject("Word.Application") (with quotation mark) should help or: Set wApp = New Word.Application (If you have the Microsoft Word reference added)
Hello! I have a Worksheet of Excel 2010 with several numbers (for example from A1 to A5) and a cell with the sum (A6) I want to link the number of the sum to Word 2010. I want to write, for example: "The sum of 2014 is " and add the information from excel. It could be as if I have a phrase with a field in the middle of it. The number of this field should change automatically if I change the numbers in Excel. Is it possible for you by VBA? I tried the "Past Special" But i can't "move" the pasted field as I want. Could you tell me what I should do for my goal? Thank you very much!
ExcelVbaIsFun Thank you very much. I think your work is very great. I must improve my english so I'll be able to understand your videos better (I'm italian). I think this programs are very powerful!
yes, I experimented. The mike must (for whatever reason) be up near my nose. It doesn't catch my nose sounds, just talking. nose sounds (lol). just sounds funny. Dan
Good, I want to write to word from excel but I want to create a table this time with data in it and further yet, I want to write to a word template rather than to fresh word document. is that possible?
I work for JP Morgan Chase accounts payable team and we daily come across lots of payment transactions. These transaction information come via email in .txt format as an attachment. Currently we open these emails manually and then copy paste the data into excel. Is there any way to import these transactions detail directly from my inbox in to excel. Regards Anupam M.
hello i have a company where we give some courses n certificate of attendance. its very time consuming do the certificate of attendance for hundred of participants, i copy n paste the names. Is there any other automatic ways i can do it faster? Thank you very much
well and what instruction or command to save the document as Word or PDF excel macro ??? that I have a macro that generates the Word document from a template and not save the document as generating :( can you help meeee pleaseeeeeee :'( ExcelVbaIsFun
Constructive criticism: It would be a good idea to practice and get the procedures down before making a RUclips video. It's awkward watching you struggle to remember how to do something.
Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan
Thank you, been searching for something at a beginner level for a while. Appreciate how slow the video goes. So many videos on RUclips move too quick and try to do too much.
Thank's Dan. Love all of your videos :)
Mzchkolate1,you're very welcome. Thx for the comments!!
I'm not certain, will have to look into this. Dan
Thanks Dan... EXACTLY what I needed to see. Was a tremendous help!
Thanks for the video. Very useful
You're so welcome. Thanks for the comment!
Maybe. What do you want to import specifically? Thanks, Dan
Thanks for the video!
i guess I am kinda randomly asking but does anyone know a good site to stream newly released series online ?
It's really fun, next time i should use this method to communicate between Excel and Word...
Anupam,
Sorry, I'm sooooo behind on my questions in my inbox, but I was able to film a new one for you on importing txt files straight to Excel with lots of side notes and helpful tips. Hope this helps you, should be ready tonight or tomorrow. Blessings, Dan
Love your videos!! It's possible to write a code in which can lookup through folders and subfolders the file names that has been added for example, today?
Thanks a lot!!
Thanks!!
Super cool! Thank you!
Thanks buddy for sharing this..can you please suggest how to paste the line in specific line
Thank you so much dan that's a saving life tutorial. I have a quetion please!
Can i add an automate fonctionality of the following list in row?
1-Creating file with a specified name from a cell data
2- saving file
3- opening the file
Thanks in advance
Thanks a lot for video! One question, is it possible to make something like this but to transfer name of every excel sheet to the new word document page?
Thank you so much
Nice job Dan. Sound quality much better now. Did you move your mic?
Thanks a lot for this great effort.
Thanks sobolev, I hope it's helpful! Dan
Thanks for the video,
Is there any why to insert a whole table instead of one cell?
I tried to use Range("A2:C5") after insertafter but I get errors.
I used something like "Worksheets("Sheet1").UsedRange.Copy"
I'm so damn excited !!
Thanks in advance Dan
You're very welcome, Sobolev514! Thank for watching and commenting!! Dan
What if I want to insert an entire table instead of just one cell? Range isn't working for table (A1:F20 kind of)
is there a way to insert data from pre-existing cells in Microsoft excel into certain cells of a pre-existing table in MS Word
Hey!@ Thank you for this tutorial it has helped so much. Is there anyway to run this vba so that the information you want automatically transferred from excel sheet, goes to a preexisting word document that has a letterhead???
I'm making you a video to answer some of these questions this evening. Hope you like! Dan
Thank you so much. It really helped me a lot
You're very welcome! prince zachariah more tips on my new ebook www.excelvbaisfun.com/free-ebook.html Blessings!,
Dan
Hi. Is there a way to create several tables in excel and then import them into word using mail merge. So each table imported would be based on the page in mail merge?
Cheers mate.I like your explanation.You build it from scratch. :)
Thanks very much cara
hi, how can you change insertafter range("a1") font style?
Hello! I got an Excel function which ConvertNumToWords, May I exceute it in Word, so that I get the numbers in words right in the Word document? Thank you for share. Blessings!
i need to get something similar for Office 2001 for MAC.
need EXCELL sheet converted to WORD for easy read.
each row with many collums in excel has various txt data.
i need each row to be converted into 1 word document so it’s easy to read.
what would you charge? can you make that work in office 2011 for mac?
Why mix early binding synthax with the late binding one?
Great, I succeed. I like to apply this technic to my work.
i have registration records in excel, and for each record I isseu a letter.
how can I use my last record to my word document automaticly or can I make a drop down list related to excel file to select. if you have any idea.
Is there a way to export a cell (from excel) as a string to a word document at a specific spot within a body of text in the word document.
Thank you.
hi there.
hope you guys can help out.
it's a similar situation in a userform in excel.
i'd like to know how to add a text box wherein selected labels will appear with entered data in it. sort of like a summary of what you've entered to appear in a box in the same excel sheet.
also, how do I add a time start-time start function button in excel userform.
thanks a bunch.
it is a good information about export range from Excell to a Word. maybe you can show next step - how export many ranges with for example some view /as one page - from excell to a word. Anyway this wideo is really very good. Thanks for it.
I'm making you a video to answer some of these questions this evening. Hope you like! Dan
Hello and thank you! I was just wondering, this would be useful to create letters in Word from Excel, so, how can I create spaces so that the content of other cells be inserted in the write place of the letter, for example; Date, Introduction, recipients name, and final comments, signature, thank you!
If i have a word form that i want to fill up using data in excel sheet.. can that be done?
Hello , I have one question. I did a word file and I used developer and I want to use the protect form. Until here everything is OK but in my word file, there are some graphics. I want to enter some date into the graphic to change the figures (Sales Amounts) however because I used protect form , I am unable to change the graphics. " I can unprotect and change the graphic however my employee will use this form and thats why ı am protecting it. Is there any way you can help me ? I hope I express myself well. Thanks
To do the trick you have to created a reference to the Word type library Go to Tools>References, scroll down to Microsoft Word, and check it.
Excel vba is not fun . You are the fun one.
Thank you so much!👍
can be used for 1 sheet
Good video!
Wow! Fun stuff! :) Snap! :) I love it! Thanks for sharing. :)
You're welcome. Thanks DatabaseDesigns4U
Nice. Thanks for the explanation.
thanks! I'm making a "Part 2" tonight about navigation and editing, as well as opening an existing Word Document.
Hello Again Dan,
Is there any way to import data from outlook to an Excel ?
This will help me alot !!
Thanks in advance.
Anupam
I've done what you told. Unfortunately, my problem is way more complex.
I've chaged the matrice so that the text is copied only If it has already been chosen by one of many CheckBoxes previously.
The thing is, I cannot add 2 texts one after an other. The matrice stops at the second
"Dim wApp As Word.Application" , meaning that this word application has already been launched, so I cannot ad anything to it.
Could I put this line at last so that it opens only after every text is selected?
Wondering if anyone knows any way to speed up the process copy and paste paperwork? For work, I have forms that are a pape long that have to be created for around 30 different companies. The forms are all the same except for a few differences such as company names and addresses. The current way we do it is by having a template document and then typing or copy and paste in the needed information. This process can take a couple hours and I'm sure there's a better way to do it. The goal would be to have one document in excel that I could go in and list all the company's information and then it would automatically generate the needed documents. There's got to be a way to do it I just can't figure it out any help would be greatly appreciated.
What version of Excel are you using?
I asked because of this error "Dim wrdApp As Word.Application" and I think its happens for this cause (version of Office. PS: I'm sorry for my english, I'm a brazilian!
Jorge Pereira I used 2010 in this vid but I now have 2013. Thanks, Dan
Hey there!
A quick question: Is there a way to save the file as docx, together with pdf? I want to have the pdf version of the document as well. Thanks!
Kadir 'Keleş I would think that this is very possible. You'll have to look at the syntax with which we save documents in word vba or excel to vba.
ExcelVbaIsFun Ill consider that, and thank you very much for these really useful tutorials!
Cool! You're so welcome!
uploading now, sir.
Dan
Hi, how can we edit the letter templete in excel using vba
How can i do for save the Document ?
First off let me say I am experienced with Excel but a real VBA newbie. I am playing with the function to add cell information to a Word document. Unfortunately I cannot get past the first "Set" to Create my Word Application Object. Since I am a newbie, I am sure I am missing something very simple.
Dim wApp As Word.Application
Dim wDoc As Word.Document
Set wApp = CreateObject(Word.Application)
wApp.Visible = True
When I run this I get the following error:
Run-time error '429': ActiveX component can't create object
I would appreciate any help I can get. Thanks.
A little late but:
CreateObject("Word.Application") (with quotation mark)
should help or:
Set wApp = New Word.Application (If you have the Microsoft Word reference added)
Very good
How can I get this example files...?
Hello! I have a Worksheet of Excel 2010 with several numbers (for example from A1 to A5) and a cell with the sum (A6) I want to link the number of the sum to Word 2010. I want to write, for example: "The sum of 2014 is " and add the information from excel. It could be as if I have a phrase with a field in the middle of it. The number of this field should change automatically if I change the numbers in Excel. Is it possible for you by VBA? I tried the "Past Special" But i can't "move" the pasted field as I want. Could you tell me what I should do for my goal?
Thank you very much!
making a video for you now on this topic of find and replace in excel vba to word, my friend.
Dan
Davide I video is here Excel to Word pt 3 Find AND Replace in Word from Excel VBA for you. Dan
ExcelVbaIsFun Thank you very much. I think your work is very great. I must improve my english so I'll be able to understand your videos better (I'm italian). I think this programs are very powerful!
yes, I experimented. The mike must (for whatever reason) be up near my nose. It doesn't catch my nose sounds, just talking. nose sounds (lol). just sounds funny. Dan
Good, I want to write to word from excel
but I want to create a table this time with data in it
and further yet, I want to write to a word template rather than to fresh word document.
is that possible?
I'm making you a video to answer some of these questions this evening. Hope you like! Dan
I'll be waiting Dan, thank you in advance
Mohammad Taha Excel In Excel Here it is once it's done uploading. ruclips.net/video/yJFVTou3QIg/видео.html
Highly appreciated Monsieur Dan, I am waiting for it, Merci
you're welcome. It's available now. here ruclips.net/video/yJFVTou3QIg/видео.html
can i have wirtten manual..
Anyone knows how to export /save all of Macros/Modules form a workbook (globally) into a word document without missing any VBA codes?
I work for JP Morgan Chase accounts payable team and we daily come across lots of payment transactions.
These transaction information come via email in .txt format as an attachment.
Currently we open these emails manually and then copy paste the data into excel.
Is there any way to import these transactions detail directly from my inbox in to excel.
Regards
Anupam M.
lol, thanks!
CreateObject function is not working MsOffice 2007
Nice
hello i have a company where we give some courses n certificate of attendance. its very time consuming do the certificate of attendance for hundred of participants, i copy n paste the names. Is there any other automatic ways i can do it faster?
Thank you very much
yes
well and what instruction or command to save the document as Word or PDF excel macro ??? that I have a macro that generates the Word document from a template and not save the document as generating :( can you help meeee pleaseeeeeee :'( ExcelVbaIsFun
did you get an answer for this? I am trying to do the same thing right now!
there is mistake, Hundred is coming two times, first should be lakh
Hi saini, Just rewatched the vid. I don't see hundred. Thanks
Constructive criticism: It would be a good idea to practice and get the procedures down before making a RUclips video. It's awkward watching you struggle to remember how to do something.
Check out part two of this Excel to Word series here: How to Open, Navigate and Edit Existing WORD Doc Using Excel VBA! Comprehensive guide