Man, I have no words, your video is the best guide of VBA I've ever seen, you're a great teacher! Thank you so much
@WiseOwlTutorials2 жыл бұрын
Ah thank you Bruno, I really appreciate that!
@fekrabusinesssolutions2 жыл бұрын
Thank you sir, this is very helpful. Even after getting my answers, I wanted to continue watching because it is a valuable content.
@WiseOwlTutorials2 жыл бұрын
Happy to hear that you enjoyed it, thanks for watching!
@musimuvi19168 жыл бұрын
Excellent video. I normally don't "like" any videos on youtube but I HAD to like, comment and subscribe to this one. You mastery of VBA is great, you presentation skills are on point and the content is super relevant. Well done!
@jam92es6 жыл бұрын
This is absolutely brilliant! Thank you so much for the video, you walked through everything so well and covered so many great scenarios. Thank you!
@m.mohtashim20003 жыл бұрын
I really appreciate your tutorials Andrew, they helped me learn a lot. One thing I would advise you to do is that get the different sections inside the description box and youtube will create navigation panes for the video and that way it will be easier to navigate to specific sections of tutorials.
@WiseOwlTutorials3 жыл бұрын
Thanks yes, we've been adding chapters to all of the videos we release for the past six months or so. We haven't had the time to go back to the hundreds of older videos to do the same yet! I'm happy to hear that you found the video useful anyway, thank you for watching and for sharing that tip!
@m.mohtashim20003 жыл бұрын
@@WiseOwlTutorialsOhh I see, I understand it will take quite a long time to do that for each video. Much Appreciated😊
@WiseOwlTutorials3 жыл бұрын
@@m.mohtashim2000 Indeed it will - I wish we hadn't made so many videos now!
@m.mohtashim20003 жыл бұрын
@@WiseOwlTutorials Can I make a request to you. Can you please make an in-depth tutorial on word macros as well.
@WiseOwlTutorials3 жыл бұрын
@@m.mohtashim2000 Hi there! I don't think it's very likely that we'll have an entire series on Word macros although we will probably have the occasional video involving Word.
@Piplodocus6 жыл бұрын
I needed to know what was in the title of the video. The last few days and in future though I've needed to know all the tons of other useful stuff in here too! Great vid. :)
@oz70757 жыл бұрын
What a great video, just as the rest of them on your channel. I'd like to thank you for sharing your knowledge and give thorough explanations which is what I usually look for, not simply being given the right instructions to use. One of the things I struggled most with was the use of the CreateObject or Set...New. I saw them used many times but I couldn't tell the difference. Now it's pretty clear what they're for and the advantages and disadvantages of using one option or the other. Superb work :)
@itsdaj2 жыл бұрын
I would give this 5 likes if I could. Not only is this great material, but it is also worth studying. There are so many tips and answers here. Your level of explanation is perfect.
@WiseOwlTutorials2 жыл бұрын
Thanks so much!
@MrDontuknowme5 жыл бұрын
This is a beautifully made tutorial. You are amazingly knowledgeable and are fantastic at conveying that knowledge. Thank YOU!
@WiseOwlTutorials5 жыл бұрын
Thank you! Happy to hear that you enjoyed the video and thank you for taking the time to leave such a nice comment!
@lietus05 жыл бұрын
For someone in future, if you are looking to copy embedded chart you should use something like this in your code: Dim MyChart As ChartObject Set MyChart = ThisWorkbook.Sheets("DOC").ChartObjects("Chart 1") MyChart.Chart.ChartArea.Copy .Selection.GoTo what:=-1, Name:="ChartLocation" .Selection.Paste
@WiseOwlTutorials5 жыл бұрын
Hi Matiss, thanks for this, we do cover referencing ChartObjects in a separate video kzbin.info/www/bejne/mKa1qKewi9xqi7M but it's always useful to have tips like this around to help remind people. Thanks for taking the time to add it and for watching!
@glennlaanekorb91684 жыл бұрын
Well explained video and was super easy to follow. How would you take cells out of the excel table and insert into word document in a custom table that is created with VBA code?
@scotolivera82075 жыл бұрын
thank you, sir for this well-designed tutorial, What about MS access, are you planning for making a tutorial for it too?
@farahadibah69583 жыл бұрын
Hai, ur video is wonderful.. i need help.. now this tutorial teaches how to copy the whole table data but how can i only copy a selected data from the table to the assigned bookmark in word? For example if i have 100 ppl i just want to transfer 1 person data from the worksheet by assigning condition like i will enter a siri no. at “E3”cell so if the siri no. in E3 is equal to the siri no. of that 1 person in the table then i want to transfer the whole data of of that person only into word. Not the whole table. How to write vba code for that? Thank you in advance
@WiseOwlTutorials3 жыл бұрын
Thank you Farah! I think that you might find this video on the Find method useful kzbin.info/www/bejne/lYu5hIlvjpyHfdk You can search for the "siri no." using the value of E3 and then copy the row that you find. I hope it helps!
@nurlankalybekov73368 жыл бұрын
Hardworking in commenting and Simple. My raise hand. Thank you
@CallipygianMoose4 жыл бұрын
great video and it works perfectly so thanks! I would like to add something else to this but I'm not sure how....> my table that I am importing to word has some cells that contain formulas that are returning null-strings. Unfortunately when the table is imported to word it imports the blank rows. I could of course just delete them after they have been imported, however I thought Id ask if there was a way using VBA code when selecting the columns to be sent to word, to ignore all cells containing null-strings? currently i could have values on row a, nothing on row b, values on row c etc in any order. I only want VBA to take data from the table of values that contains a value, and I do not want gaps between. I dont necesarily want to remove the formula or the null-string from the Excel document its self, I just want it to ignore those cells when exporting and sort it in such a way that there are no gaps where nullstrings would have been.
@arkadyvoloshin64134 жыл бұрын
Great tutorial, best I was able to find.
@WiseOwlTutorials4 жыл бұрын
Thank you Arkady!
@divyal58528 жыл бұрын
Hi Andrew, thank you so much! Amazing video seen so far!
@ssa16324 жыл бұрын
Thank you so much! Superb! Would u please guide me the code for making two pages in word documents for two separate ranges in Excel!
@CyrusPieris4 жыл бұрын
You are just amazing. I am actually learning computer programming via all the courses you are presenting. I will be making a donation as you are really helping me out in my career! thank you so much Andrew. Also the book you have written is amazing. I think it is the go to guide for VBA.
@KM-co5mx2 жыл бұрын
This is Awesome! and You're Awesome! 🙇♂
@WiseOwlTutorials2 жыл бұрын
Ahh thanks! 😀
@MrRusseltjj10 жыл бұрын
Thank you so much, my code works perfectly now!
@СтепураАндрій10 ай бұрын
Great work! Thank you for this greate tutorial!
@WiseOwlTutorials10 ай бұрын
Thank you so much for watching!
@KawanExcel3 жыл бұрын
This is so much.... Thanks Andrew
@WiseOwlTutorials3 жыл бұрын
You're very welcome! Glad you enjoyed this video too and thank you for watching!
@danielb.stelzer46439 жыл бұрын
Hi Andrew, First of all, thank you very much for this tutorial and all others. I can say without a doubt that you've taught me how to write VBA. I'm experiencing a problem with the VBA code I've written, though. When I change the code from "early binding" to "late binding", all the formatting I've done in the word document is lost. So all works well when I write the code, but when I change the method from Early Binding to Late Binding, my new generated files won't come formatted :( The stretch of the code I'm having trouble with: Sub GenerateWord() Dim wdApp As Object Set wdApp = CreateObject("Word.Application") With wdApp .Visible = True .Activate .Documents.Add With .Selection .ParagraphFormat.Alignment = wdAlignParagraphCenter .ParagraphFormat.Alignment = wdAlignParagraphCenter .BoldRun
@danielb.stelzer46439 жыл бұрын
Thank you very much Andrew! You're awesome!
@VictorKap Жыл бұрын
Brilliant, love your work. Thank you
@WiseOwlTutorials Жыл бұрын
Thanks Victor!
@kapibara2440 Жыл бұрын
This is a brilliant video! Thank you Wise Owl ❤
@WiseOwlTutorials Жыл бұрын
Thanks for watching!
@renayi28425 жыл бұрын
Absolutely wonderful! Simple, informative, easy to follow. Thank you!!
@duanedonaldson22624 жыл бұрын
WiseOwl, can you please help me to give my FileName that I previously copied to my clipboard, ActiveDocument.SaveAs2 FileName:= _ "Tom Wulf ; Running Java From the Windows CMD LINE.docx", FileFormat:= _ I dont want to paste a name here manually in the code between the double quotes please, before running my Word 15 VBA macro. I can paste all my code if needed.
@totalzack50007 жыл бұрын
Hi, I want to thank you for all of your great videos on vba. I've got a lot of help over the last years from you and, I LOVE the way you say "reference". Please throw more references in there and keep up the good work
@kristiandadhley9777 жыл бұрын
Great Vid! Would a similar thing be done if you wanted to populate a word report with data from excel. i.e. you had a standard MS word report that said something like. "Since the last report X people have signed up with the company and Y people have retired" where you want to populate the X and Y with values from an excel sheet?
@jopinfuyiro55702 жыл бұрын
дядька просто лучший
@WiseOwlTutorials2 жыл бұрын
Thanks!
@krloskrloncho4 жыл бұрын
Hi. I have a question if anyone can help me out. I'm trying to locate a bookmark inside a textbox (in my Word Document), but when I run the code in excel VBA says error 5678: Word can't find the specified bookmark. Any help will be appreciated.
@abdullahquhtani42476 жыл бұрын
One more question plz, what if I want to save the document as PDF instead of .doc or .docx? Thank you.
@MonikaR20065 жыл бұрын
Thank you very much for this very well explained tutorial. I seem to have an issue with selecting the range I want to use. Copying your example, I get an error message and nothing is displayed (Range("A2", Range("A2").End(x1Down).End(x1ToRight)).Copy). In fact in may case, I would like to have the range start at A2 - down - to I and down. Perhaps this is not something to be solved just via this message?
@fakename63004 жыл бұрын
Syntax should be; Range("A2", Range("A2").End(xlDown).End(xlToRight)).Copy 1's should be l's
@Trucpq3 ай бұрын
So helpful and excelent explanation !
@WiseOwlTutorials2 ай бұрын
Thanks! Glad you found it useful, thank you for watching!
@tajsay4 жыл бұрын
You are simply brilliant Andrew. I haven't left with any words to thank you. I am just addicted to your videos.
@alsoness9 жыл бұрын
When I try to paste my range from Excel to Word I get run-time error 1004: method 'copy' of object 'range' failed.?? Do you know what causes this error? I am running office 2004 on mac, and one of the cells in my copied range contains a formula, could this by why the paste fails?
@ravibabu22534 жыл бұрын
I could not done Mail merge with Excel XLSM FILE Plese tell me how can i do this
@chathurathilakarathne22055 жыл бұрын
That's bloody beautiful
@WiseOwlTutorials5 жыл бұрын
Thanks, glad you liked it!
@mickcarroll19 жыл бұрын
Hi Andrew, yours are the best delivered tutorials on KZbin bar none. I'm less than a newbie in VBA and may have missed this but is there a way of personalising each email - e.g. "Hi ,"? while still adding attachments?
@singhdevprashant4 жыл бұрын
Pls suggest VBA code to copy specific selections from one Word file to another, by opening data from one file and copying it to other using VBA. Thanks a lot in advance.
@DavidAYork6 жыл бұрын
Thank you for all the videos you've produced. They have taken me a long way from "novice" to producing outstanding content in a very short period of time. I like the speed you go at (I can always step back if I need to) because the amount of information is incredible. I LEARN from your videos. Thank you!
@faiz.ahmad654 жыл бұрын
While pasting charts in word doc, getting error code 4198 command failed. Please suggest
@chrisgray8774 Жыл бұрын
Even my Word 2016 is outdated by now, but your techniques still apply. Thank you for your help.
@WiseOwlTutorials Жыл бұрын
Thanks Chris, happy to hear you found it useful!
@88Nateg9 жыл бұрын
Brilliant tutorial thanks! I keep referring back to this vid and it's always a huge help!
@91alezander4 жыл бұрын
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!
@pyerenee1 Жыл бұрын
I have question. In the Outlook application, I have a french signature and also an english one. Both of them have images (logo.png) and they do not appear in the message, only a square box with a red X. Can you help me solve that situation?
@WiseOwlTutorials Жыл бұрын
I wonder if these might help? stackoverflow.com/questions/47285959/send-email-with-signature-images-outlook-2016-vba stackoverflow.com/questions/60393319/problem-with-my-outlook-signature-outlook-with-vba
@germanperez20107 жыл бұрын
Hi- great videos. Question. I can't get the macro to automatically save the document. Instead, the word app open s the save as window and forces me to save it manually. Any reasons this could be happening? For ref, i am using office 2016. Thanks.
@DavidAYork6 жыл бұрын
WiseOwlTutorials I'm having the same issue in 2007. I have found out that this is a compatibility issue between a 32- bit installation of office on a 64- bit system. I don't know how to fix it but that seems to be the problem.
@pyerenee1 Жыл бұрын
Thank you so much! Exactly what I was looking for. Moreover, the entire series of videos is very interesting and useful. Also, you are a very good teacher. Thanks again!
@WiseOwlTutorials Жыл бұрын
Happy to hear that you found it useful, thanks for watching!
@cullenharris18374 жыл бұрын
Is anyone else getting an error in the SaveAs2 line at the 29:30 mark? It says to check the path or select a file from the list.... any advice is greatly appreciated!
@kamalakotagiri71744 жыл бұрын
Can we copy an image from a perticular page of word doc and paste in PPT with VBA? Please help.
@abdullahquhtani42476 жыл бұрын
Great. I paid a developer about $50 to make a vba code the serves my need. That developer died in a car accident a year a go. I need someone to do some modification for me and I'll pay for that. Can you do that plz?
@menaeem6 жыл бұрын
Let me know the details.
@fabianreurekas99963 жыл бұрын
Thank you very much!
@WiseOwlTutorials3 жыл бұрын
You're very welcome Fabian, thank you for watching!
@mytedico2 жыл бұрын
Sir, From the start, to end this video is really worthful to watch, thank you for such an excellent video.
@WiseOwlTutorials2 жыл бұрын
You're very welcome, thank you for the comment!
@nishchaynagpal60517 жыл бұрын
Hi, I had a query. If we use late binding in vba then there is no need for word,outlook,etc. library but when i did that the actions(object.action) that you use in this video gave an error as variable not defined which should not happen, as you said that people tend to program using early binding and then convert later to late binding. The line that gave me the error was '.ParagraphFormat.Alignment = wdAlignParagraphCenter'.
@nishchaynagpal60517 жыл бұрын
WiseOwlTutorials I got confused since it was not working. Thanks :)
@jmathew69883 жыл бұрын
This tutorial stands out among all other KZbin videos discussing the topic Excel VBA - Word. Thanks Andrew.
@WiseOwlTutorials3 жыл бұрын
Thank you for the kind words!
@dksuthar31 Жыл бұрын
thank you wise owl
@WiseOwlTutorials Жыл бұрын
You're welcome Deepak, thanks for watching!
@watcherRA8 жыл бұрын
Another smashing hit! Your videos are top quality, your explanations are clear, your examples are focused, and your coverage of the issues is comprehensive. Your KZbin channel is a treasure trove, nothing less. Thank you for doing this!
@samouhi6 жыл бұрын
I second watcherRA. Thank you so much for the effort you put into these tutorials and being so generous with your tips and details.
@yacinelimane20112 жыл бұрын
Exactly what I was looking for, you are amazing, and a great teacher as well, God bless you.
@WiseOwlTutorials2 жыл бұрын
Thank you so much, I'm glad that you found the video useful!
@ousmanetall12867 ай бұрын
thank andy, but so far, what you have done with word only covers read and append to it, what about reading from in it: with wdApp.documents.open(filepah & "\" & filename.docx)
@WiseOwlTutorials7 ай бұрын
Hi! This is a topic that has been on my list for a long time. One day I may get chance to actually create the video!
@Joni67sinix6 жыл бұрын
best tutorial i ever seen in my life. congrats bro!!!!
@thestuefi2 жыл бұрын
wow, thanks. thats what i was looking for. working through it. sadly somehow i cant save the file as .docx i got a runtime error 6294. when using .doc it works. using word15. can you please help me to remove this error? thanks
@WiseOwlTutorials2 жыл бұрын
Hi Stuefi! The easiest thing to do is omit the file name extension and set the file type using the FileFormat parameter of the SaveAs2 method: wd.ActiveDocument.SaveAs2 "C:\My Folder\My Doc", wdFormatXMLDocument I hope it helps!
@arvindkumarauro97313 жыл бұрын
Thanks a ton sir 😘
@WiseOwlTutorials3 жыл бұрын
You're very welcome Arvind!
@kirayamatofication10 жыл бұрын
This is really a big help explaining pulling a microsoft application from another. But do you have videos running VBA with outlook as the main application and running excel then after using outlook codes?
@kirayamatofication10 жыл бұрын
Ah... This will come handy. Thanks a bunch!
@IanGeery Жыл бұрын
"Check this box and now this particular workbook knows all about Microsoft Word". What box do I check to get that effect for myself?
@WiseOwlTutorials Жыл бұрын
:D if I knew I would have checked it myself!
@abheetkansal37902 жыл бұрын
Great walkthrough! I wanted to ask what if I have an excel sheet and want to generate a word document which is a form but want somethings autofilled from that excel row. The main issue I am facing is how to fit that excel data in that row from cells to particular places in my form Any ideas??
@WiseOwlTutorials2 жыл бұрын
Hi! You can use bookmarks in the Word document and apply the GoTo method to select them docs.microsoft.com/en-us/office/vba/api/word.selection.goto There's some basic sample code here stackoverflow.com/questions/2725550/how-to-jump-to-a-bookmark-in-word-vba-and-insert-text I hope it helps!
@colerees396510 жыл бұрын
I was having some difficulties using the Format function for the date -- (compile error: Wrong number of args...). I solved by writing in: VBA.Format(arguments). There is another function in the intellisense called: format (with a lowercase f). Do you have any idea where this function comes from?
@TheFikaky9 жыл бұрын
Hi Andrew, thanks for another great video..I copied your code, but it doesn't work if I enter numbers with the if statement (if .version
@matthoward1238 жыл бұрын
Another great video. As a personal mini-rant, doesn't it just drive you nuts when you have to program around people who are using software that is 10+ years old?! We have to do the same thing when we create reports in SAS, although really only between Office 2003 and newer versions (when the .***x extension came about). Seems VBA is even pickier, given the different methods across versions. Would there be anything stopping you from using SaveAs by default rather than SaveAs2, given that SaveAs is still available in newer versions?
@JS-zb6zh5 жыл бұрын
great video. I am trying to copy a table range from word to excel. I am stuck with word vba syntax. wDoc.Tables(1).cell(2,2) to cell(3,9) can you please help me. Thanks in advance.
@RamboRoberto29054 жыл бұрын
Hello: please advise how to center a text vertically (as Page Setup/Layout/Page/Center). Also, please advise how to enter a new page in the created word document (as page break). In your video you showed how to enter a new line (with .TypeText vbnewline) or new paragraph (.Typeparagraph). Thank you.
@menaeem6 жыл бұрын
Hi Andrew! I am facing problem in copying chart. I tried these lines: Charts("Chart1").Select ActiveChart.ChartArea.Copy I can see in step by step method that chart sheet is selected but I get error on second line in copying that chart. The error is: Run_Time error '445' Object Doesn't support this action I tried single line as well as you did in video like: Chart1.ChartArea.Copy But I get the same error. Please help...
@retrofutur1st3 жыл бұрын
Thank you!!!!
@WiseOwlTutorials3 жыл бұрын
You're welcome!
@kittyhui347 Жыл бұрын
Why I cannot save as word file?
@sandicanales80818 жыл бұрын
Hi there, thus far WiseOwlTutorials are the best from all other tutorials I've watched to learn using VBA. I need help on something I'm sure is easy for you. I have an excel sheet with word information across in different cells. I simple need to structure a module that exports it all into a word document vertically using groups of cell aligned below each other like a paragraph. What are the codes i need to organize each cell. Do I have to set bookmarks (I don't even know what that is). Your guidance is greatly appreciated. Thank you.
@divyal58528 жыл бұрын
Hi Andrew, would be happy if you could solve this for me..tried googling but no much information - "how to possibly embed the word doc or the excel itself in the powerpoint presentation? ." . . . Thank you in advance
@DineshKumar-lq2ck3 жыл бұрын
You are making life easier for many like me. You will definitely be blessed.
@WiseOwlTutorials3 жыл бұрын
Thank you Dinesh!
@SantoshLoka7 жыл бұрын
I have Existed .txt Which has Some Data in File,Is it possible to Add Excel Data in .txt after Data? I am Eagerly waiting for this script,it can help me for my own script
@joncroweucl7 жыл бұрын
Thank you for the excellent video. I can paste data into bookmarks and am using .Selection.PasteSpecial DataType:=wdPasteText so the information within cells is pasted as text at the bookmark location within a paragraph. However, doing so removes the bookmark and the reference for subsequent cross-referenced text. How can I paste data from Excel into Bookmarks in Word and still retain the bookmark for cross-referencing? Thanks again :)
@cekinci9 жыл бұрын
Hi Andrew, first I would like to say your videos are great, and can't believe this to be free!! Anyways, I would like to know if I could edit a word file like a contract, and change the data within using my excel worksheet. For instance, I only use "find-replace" to edit manually, but I would like to automate it if possible?
@stavrous1002 жыл бұрын
what if you code with late binding but you also make the reference to the lib? will this give you intelisense and be version independent?
@WiseOwlTutorials2 жыл бұрын
Hi! In short, no. If you declare a variable as an Object you won't get Intellisense.
@1309poorva7 жыл бұрын
i learnt online and created a VBA code for excel 2016 on macbook. however, the syntax is probably a little different for ios. can someone help me with it? thanks
@parikshitpadture41225 жыл бұрын
Thanks Andrew for the useful video
@WiseOwlTutorials5 жыл бұрын
You're welcome, Parikshit, thank you for watching!
@ledfootdude8 жыл бұрын
AMAZING, just came across your video and I have to say I don't think anyone could have done a better job. It's amazing how much depth you provide, along with making it simple to understand. LOVE IT!!! Thank you
@chriscook407610 жыл бұрын
Hello Andrew. Thanks for the great video tutorial! I was hoping that you might post a video (or perhaps reply with the code) to copy only specific cells from excel to the bookmarks in word. In my job I put together contracts that have repetitive information and I wanted to put together a one page "Questionnaire" (for lack of a better term) to inject the "answers" into whichever page of the word doc it relates to using the bookmark method. Any help or suggestions is greatly appreciated!
@timcago10 жыл бұрын
Can you make a video that shows how to pull data from queries in VBA and update sheets in the workbook? In the business world this is what you end up needing to use VBA for most of the time.
@itlife45552 жыл бұрын
Dear Wise Owl, I find that all VBA tutorials teach that creating or opening Word document by VBA code as this: Dim wdapp As Word.Applicaiton, then Set wdapp= New Word. Application. However, i find a much more shorter and easier code which can connecting with Word in excel VBA. No need to declaration or set assignment. Like workbooks.open to open a xlsx file, we can also use documents.open to open a docx file. Thus, in excel VBE, we can directly manipulate word application and word document without any declaration or assignment. I wonder why all the tutorials don't use this very easier method? thanks.
@WiseOwlTutorials2 жыл бұрын
Hi! I can't speak for others but I do it that way because I want control over the instance of the Word application that I create and that's the conventional code pattern for providing it. But if you're happier doing it your way then go for it!
@itlife45552 жыл бұрын
@@WiseOwlTutorials thanks!
@brightonilukena15152 жыл бұрын
I have tried this code its giving me hell with the range
@maurocastagnera89497 жыл бұрын
Dear Andrew, it's a pleasure to watch your videos! You have the great ability to be essential, but at the same time do not overlook any detail you need to understand exactly how the program works. Really at any time of the day I watch your lessons, even after a hard day's work. I really believe that you are a very intelligent person and also admirable for having made available to all your innate professional and teaching skills. Thank you not just for the VBA, as at the same time I'm also improving my English. I do not know if and when I can visit England, but I would be extremely pleased to congratulate you on getting to know you personally. Who knows ... maybe one day we will meet. Thank you very much.
@augustodemelo9154 жыл бұрын
Excellent video. Great didactic technic. Congratulations! I cannot understand how someone can give a thumbs down for this excellent tutorial. For sure these people have a problem, I am sorry! Go ahead and bring us great things like this.
@vijaykumar-gv1dg4 жыл бұрын
You are simply amazing.....thank you very much for the videos. Very helpful for a beginner like me.
@jordanjvansickle7 жыл бұрын
This is great! How can I get my data to automatically scale to fit the word document? The data in Excel fits within the page guidelines, but it does not when I transfer it to Word.
@thinkandchangethewayyouthi91425 жыл бұрын
Thanks , Perfect way of exlpanation
@WiseOwlTutorials5 жыл бұрын
You're very welcome, thank you for the comment!
@phamngochoangnam2 жыл бұрын
share me code copy from word to word, please
@martinvarela2068 жыл бұрын
Hi!, there are any chances that you make a tutorial or at least offer a link about manipulate style list from excel vba, with data (like items, if they use number or dots, the level of the item) on a table, for give format in word?
@shaunmaher2789 жыл бұрын
Hello, thanks very much for the video. How can you save the Word document with a unique name, thats perhaps references a cell in the Excel Worksheet?
@Rebel36X6 жыл бұрын
Excellent Video! Just wondering if I can SaveAs my document using data from a cell in my document title?
@shaileshsharma6682 жыл бұрын
Thanks for enhancing our skills Your video is some awesome I just want to say that could you please create SAP GUI automation through VBA
@WiseOwlTutorials2 жыл бұрын
Thanks Shaielsh! Unfortunately I've no experience with SAP so it's unlikely we'll have any videos on that topic, sorry!
@shaileshsharma6682 жыл бұрын
@@WiseOwlTutorials no issue thanks a lot, I have learned lot of things from you plz upload more and more so that we can enhance our skill
@dkpatel44704 жыл бұрын
Sir how to create mail merge excel to word and each file save specific name in singal folder How to generate single order used word tamplate through Excel data using mail merge Please creat video sir
@thestuefi2 жыл бұрын
is there a way i can close the file/word (if its already created and word opened)? thanks
@WiseOwlTutorials2 жыл бұрын
Hi! You can close a document by applying the Close method to it, and you can close Word by applying the Quit method to the Word application. If you need to get a reference to an instance of Word that is already running you can do this: Dim wd As Word.Application Set wd = GetObject(Class:="Word.Application") Note that you'll see a runtime error if Word isn't running so you might like to add some error-handling code. I hope it helps!