Really appreciate your knowledge sharing. I have personally learned a lot from your channel. Keep it going. Many thanks!
@VBAA2Z4 жыл бұрын
My pleasure!
@manojkumarbehera74343 жыл бұрын
Thank you for creating such an amazing content. I really appreciate your works. Understood many things after watching repeatedly.😀
@VBAA2Z3 жыл бұрын
Happy to hear that! Thanks for watching!
@WeningWang Жыл бұрын
by far the best and most practical word automation tut. thank you, my friend.
@VBAA2Z Жыл бұрын
Glad it helped
@jamesh-kc7rk Жыл бұрын
Your channel is gem for VBA enthusiasts
@VBAA2Z Жыл бұрын
wow, thanks!
@osamasami51936 ай бұрын
Your channel is gem for vba enthusiasts
@ekilunewmai7033 Жыл бұрын
Hi, thank you so much for the video. I am a beginner and I learned so much from your channel
@dk813 жыл бұрын
Thank you. Learned a lot from this video. VBA is very powerful programming language for automation.
@VBAA2Z3 жыл бұрын
you're welcome. glad to hear that!
@kingsoko5319 Жыл бұрын
Your tutorials are too the point and very practical, thank you
@VBAA2Z Жыл бұрын
You're welcome!
@JanKowalski-hk5cg2 жыл бұрын
I have followed Your instructions, all works perfectly. Great Thanks
@VBAA2Z2 жыл бұрын
Great to hear!
@andyest85804 жыл бұрын
very informative, thanks sir
@shellyhangshing3972 жыл бұрын
thank you. Very informative and easy to follow. Keep up good work
@VBAA2Z2 жыл бұрын
Thanks, will do!
@marinospohr46764 жыл бұрын
Thank you! Nice tutorial.
@VBAA2Z4 жыл бұрын
You're welcome!
@AnalyticsInDetails3 жыл бұрын
Great work done highly appreciated.
@VBAA2Z3 жыл бұрын
Thank you! Cheers!
@rainertorka20823 жыл бұрын
thanks all your tutorials are great
@VBAA2Z3 жыл бұрын
You are welcome!
@shellynomis73682 жыл бұрын
Excellent and professional. thank you
@VBAA2Z2 жыл бұрын
You are welcome!
@pamchamzell44894 жыл бұрын
Very useful 👍🏻 thanks for the video
@VBAA2Z4 жыл бұрын
Glad it was helpful!
@lilynewmai83143 жыл бұрын
Leaning many things from you sir. thanks alot.
@VBAA2Z3 жыл бұрын
So nice of you
@bnancy36994 жыл бұрын
thanks for this helpful tutorial.
@VBAA2Z4 жыл бұрын
You're welcome!
@melindahitech33692 жыл бұрын
Another amazing content! super thanks!
@VBAA2Z2 жыл бұрын
Glad you like them!
@salamikuda64592 жыл бұрын
Brilliant tutorial. Many thanks
@VBAA2Z2 жыл бұрын
Glad it was helpful!
@joybyu12313 жыл бұрын
Great tutorials.thank you soo much
@VBAA2Z3 жыл бұрын
You're very welcome!
@bindeeseaks99502 жыл бұрын
this is brilliant! many thanks
@VBAA2Z2 жыл бұрын
You're very welcome!
@jamesh-kc7rk Жыл бұрын
Thanks and keep up the great work !
@VBAA2Z Жыл бұрын
Thanks, will do!
@Manguilee-qi8to Жыл бұрын
great work as always. Learned alot from you sir
@VBAA2Z Жыл бұрын
I appreciate that!
@GiselleBrat Жыл бұрын
great explanation! defenitely worth my time
@VBAA2Z Жыл бұрын
Great to hear!
@kiloonzjico79532 жыл бұрын
Absolutely brilliant
@VBAA2Z2 жыл бұрын
thanks!
@smallone87952 жыл бұрын
Thanks so much I have learnt a lot.
@VBAA2Z2 жыл бұрын
You are very welcome
@Rahul-sn1wn4 жыл бұрын
Thanks there
@susilsxzen-ff1zn Жыл бұрын
The video was really useful. Thank you
@VBAA2Z Жыл бұрын
you're most welcome!
@PaulPhoenixRana3 жыл бұрын
One word...awesome....
@VBAA2Z3 жыл бұрын
Thank you so much 😀
@fabianreurekas99963 жыл бұрын
Thank you!
@VBAA2Z3 жыл бұрын
You're welcome! thanks for watching.
@georgekhaba64362 жыл бұрын
time table : @6:53 the finished layout of the excel that will import the data from word @7:27 linking word doc for input and excel sheet for output @8:32 the coding of the vba
@VBAA2Z2 жыл бұрын
Thanks George!
@daxteoh272 жыл бұрын
Hi Pamai, Do you know how to select non-contiguous cells in Word table with VBA?
@LiangInfinite Жыл бұрын
superb, thank you
@VBAA2Z Жыл бұрын
you're most welcome
@user-rx2ei2uu8q Жыл бұрын
Wowow this is great
@VBAA2Z Жыл бұрын
thanks!
@michaelbedano32654 жыл бұрын
Thank you so much for sharing your knowledge. Really appreciate it. Do you have any mobile application coming from Excel. Looking forward for this tutorial. God bless.
@VBAA2Z4 жыл бұрын
Thanks for your note, I am going to cover JS & Office mobile apps integration soon. Do not forget to subscribe for upcoming videos.
@michaelbedano32654 жыл бұрын
@@VBAA2Z yeah I already subscribe to your awesome channel. Is it possible to have a mobile application that is connected to Ms Excel? Looking forward to that. 😊
@mielkew27 Жыл бұрын
Nice video, how can I turn off the warning message for print margin? My word file do have tables that exceeds print margin, I want to bypass this warning by still printing it.
@inukpaw4 жыл бұрын
Thank you
@VBAA2Z4 жыл бұрын
You're welcome
@LoneIcon3 жыл бұрын
question if i have rows of different person - i can also loop the record, right?
@kchewang83314 жыл бұрын
👍👍
@nAJEEbKhan-um9wo2 жыл бұрын
Dear VBA.A2Z. you have done a great job, can you make it like to save every letter saves into same document using EXCEL ?????????? Thank you So much for you knowlede sharing.
@VBAA2Z2 жыл бұрын
You're most welcome. Will share more examples thank you
@alializadeh81952 жыл бұрын
Thank you...
@VBAA2Z2 жыл бұрын
You're welcome!
@ramzamthel801426 күн бұрын
thanks
@wangniperinmai Жыл бұрын
thanks!
@VBAA2Z Жыл бұрын
No problem!
@CodeLikeProz-dp8qr Жыл бұрын
thank you so much!
@VBAA2Z Жыл бұрын
you're most welcome!
@user-fp4mh2ki7c Жыл бұрын
thank you
@VBAA2Z Жыл бұрын
you're most welcome!
@ningsan1054 Жыл бұрын
Thanks
@VBAA2Z Жыл бұрын
Welcome
@vanessafontaine5737 Жыл бұрын
Thank you for this video...all worked perfectly with what I wanted to do with the text portions of my "automated report". But now I have to also automate copying and pasting charts from Excel into specific locations on the same word document. Is this something that can be done with VBA?
@VBAA2Z Жыл бұрын
You're welcome! May be try something like this kzbin.info/www/bejne/mnrUoIuPrsR2osk
@lookMy756 ай бұрын
Hi! Do you have any videos on how to create a customize ribbon on Visual Studio for PowerPoint Add-in where I can put different square colors where I click the square color and make it change a shape with that color? Same with a border color and text color?
@tyanthem39662 ай бұрын
Fast pace, but nice work!
@VBAA2Z2 ай бұрын
Thanks!
@farhandeen63412 жыл бұрын
Hello, thanks for this wonderful tutorial. Can you please tell me how to program it to be entering these values from a nice UI without opening excel.
@VBAA2Z2 жыл бұрын
please check these videos kzbin.info/www/bejne/pmqWe4WgiauKo8U
@m.n.9532 жыл бұрын
thanks for nice explanation/ i have a question pleas / if i need to add a command botton inside the word document or templat and write a code for it that save the document as the NAME lable field (plain text content control), in a specific bath directory, how can i write the code pleas ? can you drope the line code that do this when i click in this command botton.? pleas your answe and thank you in advance.
@ajayagrawal63344 жыл бұрын
Great Video !! Can you make a video to replace images in "Word" using "Excel" along with sizing of those images !!
@VBAA2Z4 жыл бұрын
thanks and great suggestion! will share something here or on blog.
@ajayagrawal63344 жыл бұрын
@@VBAA2Z I'll do check the blog out but the video would be great for me & all viewers as well!!
@stef_anie777 Жыл бұрын
Thank you for this! I have successful written the codes to execute my form using the control form button as you illustrated. Then, I also included a clear form macro to clear the contents, so that users could run the exportToWord macro repeatedly using different information. However, I cannot get the exportToWord macro to run again without completely closing out of the excel file and then re-opening. Is there any way to get around this? Some type of loop or call command? Or is there something I need to force closed to be able to do this?
@dan_draft Жыл бұрын
He used auto instancing in Dim WordApp as New Word.Application So your clear contents command did not work. Solution: Declare the WordApp like this Dim WordApp as Word.Application Then write this code before WordApp.Visible =True Set WordApp = New Word.Application I hope this helps. I'm on my phone rn so I cannot test it myself.
@carmelitaculanag-mckenna73837 ай бұрын
I'm working on a word form, when filling out, there's already info known and sometime need to input a new info. example, a name and address. i can make a combo box of the ff names and also if not in the selection can type one. then the name is link to another item like address that when one name is selected the address auto-populate on the address item. this is to avoid continuous mistake for someone filing up a form. and also if the name is not on the selection, a a new name can be added and write the address. your help would really be halpful. Thanks!
@CezaryDamianRosa3 жыл бұрын
Hi! Thank you for this tutorial. I am a begginer in VBA. I followed your code. When I run it, I get User-defined type not defined with reference to Sub ExportToWord (). Could you give me a hint what can be wrong? Additionally, I was trying to look for this material to download on your website, but unfortunately it looks missing. Could you refer where I can find it?
@VBAA2Z3 жыл бұрын
Ensure word library is referenced.
@mercedescostagarcia75752 жыл бұрын
Is there a way to add a bullet list of items in a word doc from excel cells? The bookmarks idea would work if the list was always of the same number of items, but what if the number of items changes?
@VBAA2Z2 жыл бұрын
Best to record and edit accordingly
@giancarloschafloqueguzman99183 жыл бұрын
Hi, excellent video How can I do if I have several times that I have to enter the same data, in order not to enter different markers for the same text, I tried to use cross reference but it has not worked
@VBAA2Z3 жыл бұрын
If you want to write to same range multiple times without closing the file first get the bookmark range address and keep reusing it by creating bookmarks on runtime. hope it helps.
@ayushmittal86244 жыл бұрын
How to transfer data including tables and paragraphs in different worksheets (having user form containing check boxes, selection button, list etc to choose from) into a single word document at a particular location only under different clauses using vba. For example word document first page is cover sheet having project name client name date , 2nd page is index sheet with clause number and page reference. 3rd page starts with clause 1.0 as introduction. 2 scope of supply and so on. It should take data from excel and paste at particular locations on click of button
@VBAA2Z4 жыл бұрын
Check this 2 videos. It'll give you google ides to work with Word Objects and also with word table. kzbin.info/www/bejne/gaC3pqxvZ9qVpbs kzbin.info/www/bejne/iILKgKusa9Ole5I Create a dummy table in template word file and write to it. All the best!
@InsideMyWall2 жыл бұрын
Very useful. How to browse a folder or file via Excel VBA, copy the name and paste it in a specified word file??
@VBAA2Z2 жыл бұрын
Watch the video: kzbin.info/www/bejne/m3nYdoeca96aqtE
@NotSoLittleBro8 ай бұрын
Does this work throughout a document? For instance if you have “contract date” in multiple places throughout the document, would it populate all of those fields?
@VBAA2Z8 ай бұрын
you'll need to design the conditions so it appears where it is needed. VBA is flexible
@mahrusalhusen6335 Жыл бұрын
hey i have problem in error 6124 "You are not allowed to edit this selection because it is protected" do you know to fix this proble?
@dallalstreet17753 жыл бұрын
thanks VBA A2Z !! can you make play list for excel word and powerpoint separarely
What is the trick to reference the same word bookmark multiple times? I tried to use a cross reference, but that doesn't seem to work
@tonybarker42403 жыл бұрын
Great Tutorial - thank you No matter what I do with the date I cannot get it to copy to the Word Document in the same format My spreadsheet displays as 22 January 2021 but when you view the Word Document it displays as 22/01/2021 Please help
@VBAA2Z3 жыл бұрын
have you tried formatting it like below bookmark object? rng_cdate.Text = Format(Range("Contract_Date"), "MMMM dd, yyyy")
@sivaajjapu62053 жыл бұрын
How can we add ribbon tabs and user defined groups into that tabs for the application, Is there any reference video available for this??
@VBAA2Z3 жыл бұрын
Yes you can please check below link kzbin.info/www/bejne/r6GsY4mOjsaLh6s
@helarylaurine50772 жыл бұрын
Hi, great tutorial! Can this be done using visual studio instead? Thanks.
@VBAA2Z2 жыл бұрын
Yes, absolutely
@VBAA2Z2 жыл бұрын
please check here kzbin.info/www/bejne/gYG2pqmIiNyanpY
@helarylaurine50772 жыл бұрын
@@VBAA2Z thank you so much 👍
@sandeepgurnani22002 жыл бұрын
Is adding bookmarks mandatory to import the excel fields ? Can it be done without adding bookmarks also ?
@VBAA2Z2 жыл бұрын
you can add to range as below Set myRange = ActiveDocument.Range(Start:=0, End:=10)
@satishacharya74033 жыл бұрын
Can we send data from one excel to multiple word documents? Like, if we want same data on different word documents but on different fields.
@VBAA2Z3 жыл бұрын
yes create multiple doc objects and replicate referring and write data there
@sachinbhoite73673 жыл бұрын
Sir from where can I get this word file ? Of lease agreement
@iftaminka28043 жыл бұрын
Hello, is it possible for doing the reverse process, that is to export/to link the data from word to excel? the word doc is as same as your lease agreement's sample, thankyou
@VBAA2Z3 жыл бұрын
Yes you can. Add reference to Excel Excel Object Library from Word
@iftaminka28043 жыл бұрын
@@VBAA2Z thanks. How if I wanna link data from word to another word file? Maybe I missed your tutorial about this, thanks again
@carinsnell33133 жыл бұрын
I created this document minus the export to PDF. When running the macro the word file is opening as read only and will not update. I’m uncertain how to change the set doc = WordApp.Documents.Open([WordPath].text, , True) I’m also getting a VBA 400 error Thank you!
@VBAA2Z3 жыл бұрын
try and google this error. This is something to do with your office installation and not the code.
@rizkifernando19752 жыл бұрын
Same problem
@haiyuyue5333 Жыл бұрын
Hi! When I run the code it prompted that "Run-time error '6124' You are not allowed to edit this selection because it is protected". For the set rng_cdate it runs smoothly, but for the tenant.Text=Range("Tenant").Value and landlord.Text=Range("Landlord").Value it failed. Could u please suggest how can I fix the error?
@VBAA2Z Жыл бұрын
Try ActiveDocument.Unprotect Password:="your password" before running the code
@jeffreyrivera22912 жыл бұрын
Bro, do you have a tutorial of this from the scratch. You should also explain on how can we add the object library. It's already open on yours
@VBAA2Z2 жыл бұрын
Hi Jeffrey, this is from scratch. To add reference simply goto Tools >> References >> [ check ] Microsoft Word *** library >> click on OK
@naveedmohammad92662 жыл бұрын
hello i have an error of 5914 my word document is showing me up with read only format only i have used all posibilities to remove protection sheet but still my document is opening in read only format
@VBAA2Z2 жыл бұрын
can you share your code?
@sonisinghsony3 жыл бұрын
hi sir this is really help full for me thanks for this tutorial but i have one question is their any possibility of automation between Word and publisher
@VBAA2Z3 жыл бұрын
Yes, you can
@sonisingh45563 жыл бұрын
@@VBAA2Z plz guide me
@VBAA2Z3 жыл бұрын
@@sonisingh4556 May I know what you're trying to achieve?
@sonisinghsony3 жыл бұрын
@@VBAA2Z sir plz make one video on publisher and word automation like if we add any text or image(chart) in publisher its will automatically add in word document
@lubna30028 ай бұрын
Hi. Thanks a lot But how can i save the file with different name each time without changing it in macros
@VBAA2Z7 ай бұрын
create a template file and open that instead of the code file
@jalalkasmani25753 жыл бұрын
How can I find a text in header of a doc and return page number using VBA ?
@VBAA2Z3 жыл бұрын
try something like this 'wRange.Find here If wRange.Find.Execute = True Then x = wRange.Information(wdActiveEndPageNumber)
@handikawibowo552 жыл бұрын
Hi ! I'm having an issue with an error saying 'Run-time error 6124 : You are not allowed to edit this selection because it is protected'. This occurs for the tenant.Text = Range("tenant").Value code. previously this code work properly on office 2019 but error on office 2016
@VBAA2Z2 жыл бұрын
When you go to the Developer tab, and click the "Restrict Editing" button it'll to show task pane with protection in current document. Else it is possible you're writing to uneditable region (like the end or beginning of a row).
@handikawibowo24092 жыл бұрын
@@VBAA2Z Thanks for your feedback. I've follow your suggestion and checked on restrict editing, but on formating restriction and editing restriction already on unchecked position. And If else any issue on uneditable region, this code should be error on office 2019 also right?
@RoyAliKhairan6 ай бұрын
Does it require the word document be opened?
@VBAA2Z6 ай бұрын
no it is not
@faldahendardi55713 жыл бұрын
Hi! I have a problem i cant find the reference for microsoft word in my visual basic app, could you please help me with this ?? Thank you
@VBAA2Z3 жыл бұрын
This might help : docs.microsoft.com/en-us/previous-versions/office/troubleshoot/office-developer/automate-word-create-file-using-visual-basic
@faldahendardi55713 жыл бұрын
@@VBAA2Z Thank you!
@naveedmohammad92662 жыл бұрын
my document is opening in read only format can u please help me
@VBAA2Z2 жыл бұрын
set read only parameter to false
@anooop.1433 жыл бұрын
I have Problem In doc.ExportAsFixedFormat After imputing ".pdf" in last of That Line. The Flash Window message to Debug Is Not showing and Also Not Creating The File In The Export Output Folder... Reference - 10:30 to 11:10 From Vedio
@VBAA2Z3 жыл бұрын
try with static path and see if it works if good with below, it is possible your docpath variable is not returning qualified full path doc.ExportAsFixedFormat "C:\test.pdf"
@anooop.1433 жыл бұрын
@@VBAA2Z Now its Showing Compile Error Argument Not Optional By selecting (.Exportasfixedformat)
@VBAA2Z3 жыл бұрын
did you add wdExportFormatPDF? doc.ExportAsFixedFormat "C:\test.pdf",wdExportFormatPDF
@Iqbalsharib42 жыл бұрын
Can it be done through python if yes then how?
@VBAA2Z2 жыл бұрын
Use python-docx
@sultannurdaulet6592 Жыл бұрын
It gives me the error saying that my word document is protected and cannot be edited. Anyone who can help?
@VBAA2Z Жыл бұрын
it must be password proected
@greenleaffoods38913 жыл бұрын
Hi ! I'm having an issue with an error saying 'Compile error : Argument not optional'. This occurs for the doc.ExportAsFixedFormat code. Could you please help me with this ?? Thank you.
@VBAA2Z3 жыл бұрын
Hi, ensure you password all mandatory parameters.
@naveenkarthik33052 жыл бұрын
i am trying to understand, what is the value in this ?
@VBAA2Z2 жыл бұрын
which value/?
@RahulSingh-we9so3 жыл бұрын
Can we do VBA automation from word to word doc?
@VBAA2Z3 жыл бұрын
of course
@PABhoccungthaydeptrai4 жыл бұрын
May I get help on file .dotm without password but can not access the code? Tks ad
@VBAA2Z4 жыл бұрын
not sure I understand. trying to reset vba password?
@PABhoccungthaydeptrai4 жыл бұрын
tks
@TheAtinadjb Жыл бұрын
I am needing this so bad for work. Can you help me?
@VBAA2Z Жыл бұрын
Please download from here: vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html Feel free to post your here if any
@sskfrey3 жыл бұрын
Could you do it on a Mac?
@VBAA2Z3 жыл бұрын
I currently don't own a mac, if you use mac please test it out and let me know
@VBAA2Z3 жыл бұрын
it should work
@jaivashisth5866 Жыл бұрын
i have to work on word doc using coding, can anyone help in this.
@VBAA2Z Жыл бұрын
try stackoverflow platform
@VBAA2Z Жыл бұрын
any specific questions, feel free to post here too
@jaivashisth5866 Жыл бұрын
@@VBAA2Z yes.. i have to prepare a manual letter in word file, where i need to update the information for particular person, like name ,address, amount at a specific position. i want coding for this.
@ab_Chitrkatha Жыл бұрын
You cannot use bookmarks for data in column 😔😔
@VBAA2Z Жыл бұрын
try this learn.microsoft.com/en-us/office/vba/api/word.bookmark.column
@rizkifernando19752 жыл бұрын
My Word didn't change at all
@VBAA2Z2 жыл бұрын
make sure the bookmarks are set up also debug line by line and see if it errors
@muthuperumalkonar48743 жыл бұрын
Hi, I have 1000 pages in word document In that 1st page has two highlighted word in two different places And I want to highlight rest 999 page at exact the same location ... Can you please share the VBA code for that
@Jonesybabie Жыл бұрын
The instruction is all over the place as though you forget maybe new people are trying to follow along. You already had windows opened and didn't explain where they came from and why 😑
@VBAA2Z Жыл бұрын
Thanks for visit. Check here for basics on word app - support.microsoft.com/en-us/topic/7bcd85e6-2c3d-4c3c-a2a5-5ed8847eae73
@MAKIN54 Жыл бұрын
I didn’t liked your way of explaining because because you do all the work yourself. It looks as if you’re talking to yourself.