Real-life Word App Automation Using VBA. Read/write to Word Document, Publish, Print and more

Поділитися
Вставка
  • Опубліковано 23 гру 2024

КОМЕНТАРІ • 199

  • @jamesh-kc7rk
    @jamesh-kc7rk Рік тому +5

    Your channel is gem for VBA enthusiasts

    • @VBAA2Z
      @VBAA2Z  Рік тому

      wow, thanks!

    • @osamasami5193
      @osamasami5193 11 місяців тому

      Your channel is gem for vba enthusiasts

    • @kentPitbull
      @kentPitbull 3 місяці тому

      I concur that. I've just learned how to VBA. And if I may speak the truth for a minute: He has a very, very light Indian accent, which makes his instructions so much easier to understand than most of whom I've come across. It's an honest statement. NO OFFENSE.

  • @WeningWang
    @WeningWang Рік тому +1

    by far the best and most practical word automation tut. thank you, my friend.

    • @VBAA2Z
      @VBAA2Z  Рік тому

      Glad it helped

  • @JanKowalski-hk5cg
    @JanKowalski-hk5cg 2 роки тому +1

    I have followed Your instructions, all works perfectly. Great Thanks

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Great to hear!

  • @holieh5301
    @holieh5301 4 роки тому +6

    Really appreciate your knowledge sharing. I have personally learned a lot from your channel. Keep it going. Many thanks!

    • @VBAA2Z
      @VBAA2Z  4 роки тому +1

      My pleasure!

  • @kingsoko5319
    @kingsoko5319 2 роки тому +1

    Your tutorials are too the point and very practical, thank you

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      You're welcome!

  • @georgekhaba6436
    @georgekhaba6436 3 роки тому +5

    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

    • @VBAA2Z
      @VBAA2Z  2 роки тому +1

      Thanks George!

  • @lookMy75
    @lookMy75 11 місяців тому

    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?

  • @shellyhangshing397
    @shellyhangshing397 2 роки тому +1

    thank you. Very informative and easy to follow. Keep up good work

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Thanks, will do!

  • @stef_anie777
    @stef_anie777 2 роки тому +2

    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
      @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.

  • @jamesh-kc7rk
    @jamesh-kc7rk Рік тому +1

    Thanks and keep up the great work !

    • @VBAA2Z
      @VBAA2Z  Рік тому

      Thanks, will do!

  • @Manguilee-qi8to
    @Manguilee-qi8to Рік тому +1

    great work as always. Learned alot from you sir

    • @VBAA2Z
      @VBAA2Z  Рік тому

      I appreciate that!

  • @NotSoLittleBro
    @NotSoLittleBro Рік тому +1

    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?

    • @VBAA2Z
      @VBAA2Z  Рік тому

      you'll need to design the conditions so it appears where it is needed. VBA is flexible

  • @manojkumarbehera7434
    @manojkumarbehera7434 3 роки тому +3

    Thank you for creating such an amazing content. I really appreciate your works. Understood many things after watching repeatedly.😀

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Happy to hear that! Thanks for watching!

  • @ekilunewmai7033
    @ekilunewmai7033 2 роки тому

    Hi, thank you so much for the video. I am a beginner and I learned so much from your channel

  • @GiselleBrat
    @GiselleBrat Рік тому +1

    great explanation! defenitely worth my time

    • @VBAA2Z
      @VBAA2Z  Рік тому

      Great to hear!

  • @vanessafontaine5737
    @vanessafontaine5737 2 роки тому +1

    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
      @VBAA2Z  2 роки тому

      You're welcome!
      May be try something like this ua-cam.com/video/dIqoXYy_Clg/v-deo.html

  • @susilsxzen-ff1zn
    @susilsxzen-ff1zn Рік тому +1

    The video was really useful. Thank you

    • @VBAA2Z
      @VBAA2Z  Рік тому

      you're most welcome!

  • @shellynomis7368
    @shellynomis7368 3 роки тому +1

    Excellent and professional. thank you

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      You are welcome!

  • @dk81
    @dk81 3 роки тому

    Thank you. Learned a lot from this video. VBA is very powerful programming language for automation.

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      you're welcome. glad to hear that!

  • @LoneIcon
    @LoneIcon 3 роки тому

    question if i have rows of different person - i can also loop the record, right?

  • @mercedescostagarcia7575
    @mercedescostagarcia7575 3 роки тому +1

    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?

    • @VBAA2Z
      @VBAA2Z  2 роки тому +1

      Best to record and edit accordingly

  • @lilynewmai8314
    @lilynewmai8314 4 роки тому +1

    Leaning many things from you sir. thanks alot.

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      So nice of you

  • @melindahitech3369
    @melindahitech3369 2 роки тому +1

    Another amazing content! super thanks!

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Glad you like them!

  • @InsideMyWall
    @InsideMyWall 2 роки тому +1

    Very useful. How to browse a folder or file via Excel VBA, copy the name and paste it in a specified word file??

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Watch the video: ua-cam.com/video/eHuETf6ygto/v-deo.html

  • @ccmckenna
    @ccmckenna Рік тому

    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!

  • @salamikuda6459
    @salamikuda6459 3 роки тому +1

    Brilliant tutorial. Many thanks

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Glad it was helpful!

  • @sandeepgurnani2200
    @sandeepgurnani2200 3 роки тому +1

    Is adding bookmarks mandatory to import the excel fields ? Can it be done without adding bookmarks also ?

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      you can add to range as below
      Set myRange = ActiveDocument.Range(Start:=0, End:=10)

  • @bindeeseaks9950
    @bindeeseaks9950 2 роки тому +1

    this is brilliant! many thanks

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      You're very welcome!

  • @rainertorka2082
    @rainertorka2082 4 роки тому +1

    thanks all your tutorials are great

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      You are welcome!

  • @helarylaurine5077
    @helarylaurine5077 2 роки тому +1

    Hi, great tutorial! Can this be done using visual studio instead? Thanks.

    • @VBAA2Z
      @VBAA2Z  2 роки тому +1

      Yes, absolutely

    • @VBAA2Z
      @VBAA2Z  2 роки тому +1

      please check here ua-cam.com/video/KPSuvRSwgh4/v-deo.html

    • @helarylaurine5077
      @helarylaurine5077 2 роки тому

      @@VBAA2Z thank you so much 👍

  • @joybyu1231
    @joybyu1231 3 роки тому +1

    Great tutorials.thank you soo much

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      You're very welcome!

  • @carinsnell3313
    @carinsnell3313 4 роки тому +2

    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!

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      try and google this error. This is something to do with your office installation and not the code.

    • @rizkifernando1975
      @rizkifernando1975 2 роки тому

      Same problem

  • @jalalkasmani2575
    @jalalkasmani2575 3 роки тому +2

    How can I find a text in header of a doc and return page number using VBA ?

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      try something like this
      'wRange.Find here
      If wRange.Find.Execute = True Then x = wRange.Information(wdActiveEndPageNumber)

  • @RoyAliKhairan
    @RoyAliKhairan 11 місяців тому +1

    Does it require the word document be opened?

    • @VBAA2Z
      @VBAA2Z  11 місяців тому

      no it is not

  • @smallone8795
    @smallone8795 3 роки тому +1

    Thanks so much I have learnt a lot.

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      You are very welcome

  • @daxteoh27
    @daxteoh27 3 роки тому

    Hi Pamai, Do you know how to select non-contiguous cells in Word table with VBA?

  • @sivaajjapu6205
    @sivaajjapu6205 3 роки тому

    How can we add ribbon tabs and user defined groups into that tabs for the application, Is there any reference video available for this??

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Yes you can please check below link
      ua-cam.com/video/ypI2VXYaXQI/v-deo.html

  • @iftaminka2804
    @iftaminka2804 3 роки тому

    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

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Yes you can. Add reference to Excel Excel Object Library from Word

    • @iftaminka2804
      @iftaminka2804 3 роки тому

      @@VBAA2Z thanks. How if I wanna link data from word to another word file? Maybe I missed your tutorial about this, thanks again

  • @naveedmohammad9266
    @naveedmohammad9266 2 роки тому +1

    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

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      can you share your code?

  • @nAJEEbKhan-um9wo
    @nAJEEbKhan-um9wo 2 роки тому +1

    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.

    • @VBAA2Z
      @VBAA2Z  2 роки тому +1

      You're most welcome. Will share more examples thank you

  • @kiloonzjico7953
    @kiloonzjico7953 3 роки тому

    Absolutely brilliant

  • @michaelbedano3265
    @michaelbedano3265 4 роки тому +1

    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.

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      Thanks for your note, I am going to cover JS & Office mobile apps integration soon.
      Do not forget to subscribe for upcoming videos.

    • @michaelbedano3265
      @michaelbedano3265 4 роки тому

      @@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. 😊

  • @m.n.953
    @m.n.953 3 роки тому

    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.

  • @anooop.143
    @anooop.143 3 роки тому

    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

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      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.143
      @anooop.143 3 роки тому

      @@VBAA2Z Now its Showing Compile Error
      Argument Not Optional
      By selecting (.Exportasfixedformat)

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      did you add wdExportFormatPDF?
      doc.ExportAsFixedFormat "C:\test.pdf",wdExportFormatPDF

  • @pamchamzell4489
    @pamchamzell4489 4 роки тому +1

    Very useful 👍🏻 thanks for the video

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      Glad it was helpful!

  • @satishacharya7403
    @satishacharya7403 3 роки тому

    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.

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      yes create multiple doc objects and replicate referring and write data there

  • @handikawibowo55
    @handikawibowo55 3 роки тому +1

    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

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      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).

    • @handikawibowo2409
      @handikawibowo2409 3 роки тому

      @@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?

  • @evanizboss1927
    @evanizboss1927 7 місяців тому

    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

  • @mahrusalhusen6335
    @mahrusalhusen6335 2 роки тому

    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?

  • @AnalyticsInDetails
    @AnalyticsInDetails 4 роки тому +2

    Great work done highly appreciated.

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      Thank you! Cheers!

  • @farhandeen6341
    @farhandeen6341 2 роки тому

    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.

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      please check these videos
      ua-cam.com/video/p93JRjTFWmc/v-deo.html

  • @PaulPhoenixRana
    @PaulPhoenixRana 3 роки тому +1

    One word...awesome....

    • @VBAA2Z
      @VBAA2Z  3 роки тому +1

      Thank you so much 😀

  • @Jusils
    @Jusils Рік тому

    Wowow this is great

  • @ajayagrawal6334
    @ajayagrawal6334 4 роки тому +1

    Great Video !! Can you make a video to replace images in "Word" using "Excel" along with sizing of those images !!

    • @VBAA2Z
      @VBAA2Z  4 роки тому +1

      thanks and great suggestion! will share something here or on blog.

    • @ajayagrawal6334
      @ajayagrawal6334 4 роки тому

      @@VBAA2Z I'll do check the blog out but the video would be great for me & all viewers as well!!

  • @sachinbhoite7367
    @sachinbhoite7367 3 роки тому

    Sir from where can I get this word file ? Of lease agreement

  • @giancarloschafloqueguzman9918
    @giancarloschafloqueguzman9918 4 роки тому

    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

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      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.

  • @marinospohr4676
    @marinospohr4676 4 роки тому +1

    Thank you! Nice tutorial.

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      You're welcome!

  • @lubna3002
    @lubna3002 Рік тому

    Hi. Thanks a lot
    But how can i save the file with different name each time without changing it in macros

    • @VBAA2Z
      @VBAA2Z  Рік тому

      create a template file and open that instead of the code file

  • @Iqbalsharib4
    @Iqbalsharib4 2 роки тому +1

    Can it be done through python if yes then how?

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Use python-docx

  • @faldahendardi5571
    @faldahendardi5571 3 роки тому

    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

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      This might help : docs.microsoft.com/en-us/previous-versions/office/troubleshoot/office-developer/automate-word-create-file-using-visual-basic

    • @faldahendardi5571
      @faldahendardi5571 3 роки тому

      @@VBAA2Z Thank you!

  • @LiangInfinite
    @LiangInfinite Рік тому +1

    superb, thank you

    • @VBAA2Z
      @VBAA2Z  Рік тому

      you're most welcome

  • @naveedmohammad9266
    @naveedmohammad9266 2 роки тому +1

    my document is opening in read only format can u please help me

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      set read only parameter to false

  • @haiyuyue5333
    @haiyuyue5333 2 роки тому

    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
      @VBAA2Z  2 роки тому

      Try ActiveDocument.Unprotect Password:="your password" before running the code

  • @sonisinghsony
    @sonisinghsony 4 роки тому

    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

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      Yes, you can

    • @sonisingh4556
      @sonisingh4556 4 роки тому

      @@VBAA2Z plz guide me

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      @@sonisingh4556 May I know what you're trying to achieve?

    • @sonisinghsony
      @sonisinghsony 4 роки тому

      ​@@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

  • @bnancy3699
    @bnancy3699 4 роки тому +1

    thanks for this helpful tutorial.

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      You're welcome!

  • @andyest8580
    @andyest8580 4 роки тому +1

    very informative, thanks sir

  • @jeffreyrivera2291
    @jeffreyrivera2291 2 роки тому +1

    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

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      Hi Jeffrey, this is from scratch. To add reference simply goto
      Tools >> References >> [ check ] Microsoft Word *** library >> click on OK

  • @tonybarker4240
    @tonybarker4240 3 роки тому

    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

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      have you tried formatting it like below bookmark object?
      rng_cdate.Text = Format(Range("Contract_Date"), "MMMM dd, yyyy")

  • @dallalstreet1775
    @dallalstreet1775 3 роки тому +1

    thanks VBA A2Z !! can you make play list for excel word and powerpoint separarely

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Sure, please check below.
      PPT: ua-cam.com/play/PLo0aMPtFIFDoSJKFqFpjjUOVvpPvSOag8.html
      Word: ua-cam.com/play/PLo0aMPtFIFDpoFM9Th51ute2796xwPg7J.html
      All playlist: ua-cam.com/users/vbaa2zplaylists?view=1

  • @CezaryDamianRosa
    @CezaryDamianRosa 3 роки тому

    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?

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Ensure word library is referenced.

  • @ayushmittal8624
    @ayushmittal8624 4 роки тому

    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

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      Check this 2 videos. It'll give you google ides to work with Word Objects and also with word table.
      ua-cam.com/video/KoTuy92uboY/v-deo.html
      ua-cam.com/video/RQgOxv6nrE0/v-deo.html
      Create a dummy table in template word file and write to it.
      All the best!

  • @Rahul-sn1wn
    @Rahul-sn1wn 4 роки тому +1

    Thanks there

  • @PABhoccungthaydeptrai
    @PABhoccungthaydeptrai 4 роки тому

    May I get help on file .dotm without password but can not access the code? Tks ad

  • @ningsan1054
    @ningsan1054 Рік тому +1

    Thanks

  • @TheAtinadjb
    @TheAtinadjb 2 роки тому +1

    I am needing this so bad for work. Can you help me?

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      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

  • @tyanthem3966
    @tyanthem3966 7 місяців тому

    Fast pace, but nice work!

    • @VBAA2Z
      @VBAA2Z  7 місяців тому

      Thanks!

  • @fabianreurekas9996
    @fabianreurekas9996 3 роки тому

    Thank you!

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      You're welcome! thanks for watching.

  • @naveenkarthik3305
    @naveenkarthik3305 2 роки тому

    i am trying to understand, what is the value in this ?

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      which value/?

  • @RahulSingh-we9so
    @RahulSingh-we9so 4 роки тому

    Can we do VBA automation from word to word doc?

  • @sskfrey
    @sskfrey 3 роки тому

    Could you do it on a Mac?

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      I currently don't own a mac, if you use mac please test it out and let me know

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      it should work

  • @greenleaffoods3891
    @greenleaffoods3891 4 роки тому +1

    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.

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      Hi, ensure you password all mandatory parameters.

  • @wangniperinmai
    @wangniperinmai Рік тому

    thanks!

  • @jaivashisth5866
    @jaivashisth5866 2 роки тому +1

    i have to work on word doc using coding, can anyone help in this.

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      try stackoverflow platform

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      any specific questions, feel free to post here too

    • @jaivashisth5866
      @jaivashisth5866 2 роки тому

      @@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.

  • @CodeLikeProz-dp8qr
    @CodeLikeProz-dp8qr Рік тому

    thank you so much!

    • @VBAA2Z
      @VBAA2Z  Рік тому

      you're most welcome!

  • @pwestphotography
    @pwestphotography 4 роки тому +1

    Thank you

    • @VBAA2Z
      @VBAA2Z  4 роки тому

      You're welcome

  • @ramzamthel8014
    @ramzamthel8014 5 місяців тому

    thanks

  • @sultannurdaulet6592
    @sultannurdaulet6592 Рік тому

    It gives me the error saying that my word document is protected and cannot be edited. Anyone who can help?

    • @VBAA2Z
      @VBAA2Z  Рік тому

      it must be password proected

  • @kchewang8331
    @kchewang8331 4 роки тому +2

    👍👍

  • @ab_Chitrkatha
    @ab_Chitrkatha 2 роки тому

    You cannot use bookmarks for data in column 😔😔

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      try this learn.microsoft.com/en-us/office/vba/api/word.bookmark.column

  • @muthuperumalkonar4874
    @muthuperumalkonar4874 3 роки тому

    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

  • @rizkifernando1975
    @rizkifernando1975 2 роки тому +1

    My Word didn't change at all

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      make sure the bookmarks are set up
      also debug line by line and see if it errors

  • @Jonesybabie
    @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
      @VBAA2Z  Рік тому

      Thanks for visit. Check here for basics on word app - support.microsoft.com/en-us/topic/7bcd85e6-2c3d-4c3c-a2a5-5ed8847eae73

  • @MAKIN54
    @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.

    • @VBAA2Z
      @VBAA2Z  Рік тому

      hope you find videos that helps.

  • @alializadeh8195
    @alializadeh8195 2 роки тому +1

    Thank you...

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      You're welcome!

  • @KrusioLikovich
    @KrusioLikovich Рік тому +1

    thank you

    • @VBAA2Z
      @VBAA2Z  Рік тому

      you're most welcome!