Free Excel VBA Course #35 - Creating Word Reports Using VBA

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

КОМЕНТАРІ • 41

  • @bhupiistersingh4097
    @bhupiistersingh4097 3 роки тому +4

    Now, this is what I call a quality tutorial, not just to get one youtube video on the internet but how your yourself would want things to be explained. Kudos to you...

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

    Your teaching is very clear. So nice of you.

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

      Thank you... Glad you're finding the videos useful :)

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

    Thank you so much, quality and well explained. very much appreciated.

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

    First macro I've ever written and it works really well. Many thanks for this clearly explained tutorial.

  • @cs-study-ua
    @cs-study-ua 3 роки тому +1

    Super cool video & clear explanation

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

    This was an absolutely beautiful tutorial.
    You are a great guide! Thank you for being so detailed, so well organized, and such a great teacher.
    Keep it up 👍 👍

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

    Fantastic explanation, Thank you!

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

    time table :
    @2:24 creating a new word document using VBA library (early binding )
    @5:18 creating a new word document using VBA create object (late binding)
    @7:44 steps of copying excel table to word using VBA
    @8:25 using the statement "with" to active multiple commands
    @9:51 using "with" statement to control the formatting of the text copied to word
    @12:36 copying the table to word
    @14:04 saving and exit the document (attention it will override the file with the same name )
    @17:19 saving multiple document
    @19:25 taking the name of the sheet to name the automated word report
    @20:37 how to exit the word file after creating it
    @22:31 changing early binding to late binding ( assuming the other users don't have any VBA library )

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

    Thank you. One of the best tutorials I have encountered. I very much like the way you teach sir.

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

      Glad you found the tutorial useful :)

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

    Great video!! Keep going, I am sure your channel will scale very soon!!

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

    Perfect! Very useful.

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

    Extremely useful!! So late binding would be preferred as it doesn't bother anyone to go check object library and output the same stuff! But of course I need my word object library checked anyway for outlook use! Thank you!!

  • @JonClark-b6p
    @JonClark-b6p 4 місяці тому

    AMAZING!!! THANK YOU!!!

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

    will there be a requirement to transfer the word template in the same file path if we share the Excel file with other PC ???

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

    exactly what was searching for work

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

    thank you for a great start to my problem, I my case I have a java app the creates excel sheets but need to print it out in word.
    And currently do a lot of manual copy and pasting so looks like I should be able to do away with that thanks to your wonderful demo

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

    What a great video, thank you.

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

    Nice tutorial .I like to learn this.

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

    Thank you very much for this free tuto.
    Please, can you tell me if it's possible to generate more than one sheet in the same report?

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

    thanks so much, very helpful !!!

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

    Thank you for this tutorial
    Is it possible to save the file automatically with a specified name instead of document1?
    Cheers

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

    Great job. useful information. however, i have a question on how to select multiple tables in the range. I have multiple tables beneath each other. how to select them all instead of one (end of the 1st one).

  • @margad-erdeneboldbaatar4704
    @margad-erdeneboldbaatar4704 2 роки тому

    Thanks so much.

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

    This is good. Can u read data from csv or text file and insert chart of that?

  • @abcd2-k4s
    @abcd2-k4s 3 роки тому

    Excellent 👌

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

    Great,
    this topic close to what I am looking for:
    "I would like to use this feature in a different way.
    I have a set of records in the Excel sheet file, and each record carries a number, date, subject and other information, and I would like to create a Word document with the record number and date which I select it only".
    May I have a questions:
    1. How can I make a command bottom for each record to run this code instead to open VBA screen?
    2. In your example I want to copy Region in first line, and Sales in second line.
    I am waiting your reply sir.
    Thank you

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

    Hi, how would I use vba coding to to convert information on student subject progress to individual student reports saved in word.

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

    Hey,
    i’m trying to paste the table with long data into word doc using excel macro, it’s getting distributed across word doc, could u please assist?
    Could you please show us how to add the excel workbook at selected location in word?

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

    Need video for outlook also.
    How to send a mail from vba?

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

    Way to teach!

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

    I like your style of explaining things... can you explain how to do the vba code for extracting data by Date? for example, Excel has to sort data by Date (date today, date tomorrow, etc) then extract it to Word by Dept, say Engineering Dept has 5 people coming in today, then Sales Dept has 8 people coming in today, etc... then generate a/one Word report per day/date with all the following data on one sheet: Name, Phone and Notes. Can you help?

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

    Sumeet, Is it possible to do the same with notepad.? I want my data copied from excel to notepad.

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

    Why I cannot auto save as new docx file?

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

    How to add table autofit in the modules

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

    Hi Sir - it not working in office 365. Kindly assist...

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

    WoW!!

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

    Does anyone knows how to simultaneously export all VBA Codes of a workbook into a word document without missing any Modules, Macros, etc contents?