Learn Excel VBA to Automate Anything

Поделиться
HTML-код
  • Опубликовано: 22 дек 2024

Комментарии • 272

  • @KenjiExplains
    @KenjiExplains  Год назад +18

    🔥 Get 20% OFF our Excel VBA & Macros Course just for the next 7 days! www.careerprinciples.com/courses/vba-macros-for-business-automation

  • @NoelCarson
    @NoelCarson Год назад +21

    Your tutorials are a lifesaver for a new analyst. There are many more new tools like Alteryx which won't replace Excel but just makes life easier. Wish you could eventually make videos on those.

  • @ashimasingh7578
    @ashimasingh7578 Год назад +11

    Your videos are truly exceptional and the level of clarity in your communication is absolutely invaluable. We cannot thank you enough for the tremendous effort and skill you put into creating such helpful content.

  • @guilhermeh.v.santos7424
    @guilhermeh.v.santos7424 9 месяцев назад +7

    Amazing content in such a short video, straight to the point !! Thanks for sharing

  • @sharmilasanka2186
    @sharmilasanka2186 10 месяцев назад +3

    Great and simple way of explaining. Thank you so much.

  • @pablojp3498
    @pablojp3498 Год назад +16

    Loved it. More vba please

  • @muhammadtaqi1494
    @muhammadtaqi1494 2 месяца назад +1

    Well explained. The way and the methodology is very simple and attractive

  • @LivingGuy484
    @LivingGuy484 8 месяцев назад

    For the last one, how do you adjust the code so it can handle saving if there's already a file with the name in the path?
    Example, if you need to change invoice detail immediately after saving PDF, does it automatically overwrite old file if you click button again or does it do nothing?

  • @Seawolf159
    @Seawolf159 Год назад +2

    Nice video. Annoyingly the email sending doesn't work with the new outlook.

  • @Dean-rs2nt
    @Dean-rs2nt 2 месяца назад

    Would the function you created also work for an excel file which is on Sharepoint ?

  • @sergio_molinari
    @sergio_molinari Год назад

    Hi Kenji, helpful video.
    To reduce the vba code could you write?
    If Answer = vbNo Then Exit Sub , it's correct?

  • @user-qp1un7qo2d
    @user-qp1un7qo2d 7 месяцев назад

    Brilliant stuff! Do you have a tutorial on how to create a macro to copy and paste into a summary table the various different outputs from a scenario manager please?

  • @toheebyusuf1033
    @toheebyusuf1033 2 месяца назад +1

    What a short and informative video. That you very much

  • @tucatng9293
    @tucatng9293 24 дня назад

    Thank you so much. Your video is very clear. I learn a lot.

  • @SohilShah_Melodyman
    @SohilShah_Melodyman 2 месяца назад

    Very clearly and well explained! Super helpful video! Thanks a lot😊🙏

  • @24.ផនពន្លឺ
    @24.ផនពន្លឺ 9 месяцев назад

    Thanks Kenji for this video. I learned from you more.

  • @SmartElegent
    @SmartElegent Год назад

    How can fixed row & column in excel via vba code.
    But not change size via mouse & in option row & column width.

  • @Daniel-dj7fh
    @Daniel-dj7fh 7 месяцев назад

    Assuming I'm in MS-Word.
    How do I read off a table, and then make parts of it disappear?
    And what is a good source to find this out, because MIcrosoft's website seems to be really poorly explained on what xy-function does and what can and cannot be included to it.
    As an example, I know of "function.Select" but what does it really do? No clue, like what am I selecting, the value or the text. And what does selecting do really?

    • @Daniel-dj7fh
      @Daniel-dj7fh 7 месяцев назад

      Here in Excel it seems pretty straight forward, there is one table.
      No clue how the code reads out "Quantity" or "Price" out of it, assuming it exists on multiple fields.
      And the rest is simple maths, no Dim Variable As int or Set Variable = xyz nonsense.

  • @claudineyribeiro518
    @claudineyribeiro518 Год назад +1

    Hi i liked your video a lot. I am also a VBA programmer in Brazil and just started my channel teaching how to use OpenGL with Excel VBA

  • @manojitdey3323
    @manojitdey3323 Год назад

    i have a problem sir will u solve it? In a column if there is a holiday in a cell then function should merge that cell to next 7 cells like If C4=Holiday then merge cells C4:C10

  • @eldercleric
    @eldercleric 7 месяцев назад

    can you set it up so that if you have a file up the custom function wil work accross all files?

  • @messiahscent
    @messiahscent Год назад

    05:51 Kenji, when you say, "this sign," which sign is it?

  • @afzaalahmed9565
    @afzaalahmed9565 Год назад

    Thank you, I have learnt how to create custom function. I use vba just for fun. I want to discuss another problem which I faced. I know excel can’t handle figure more than 15 correctly. I used “NumberFormat=“@“” to convert the digits into text format. It was OK then but when I multiply and product is more than 15 digits, it again turn into the format which don’t require. For example I want to multiply 1111111111111111(col A)x11111111111111111(col B) in Number format without any error. I hope you can do this. Thank you.

  • @fengfuxu4822
    @fengfuxu4822 Год назад

    thank you for the video. I have a question for Printer object and Printers object. is any Reference library required to install in the Tool->Reference before we can use Pinter and Printers object? I run below code, and get error "object is required" for line "For Each prt In Printers".
    Sub ListPrinters()
    Dim prt As Printer
    For Each prt In Printers
    Debug.Print Printer.deviceName
    Next prt
    End Sub

  • @srisridaran05
    @srisridaran05 Год назад +2

    Hi, When i run the email macro after coding i can see an error called "ActiveX Component can't create objects". Can you help me to solve this issue.

    • @nmahrunnisa
      @nmahrunnisa 10 месяцев назад

      me too, do you find the solution?

  • @mr.write1433
    @mr.write1433 Год назад

    Which one is faster to calculate? If statement or vba?

  • @stevetheanalyst
    @stevetheanalyst Год назад

    I was toldvba and macros are dying because of powwer query. As a financial analysts is it still importance. Thanks

  • @dhawalghia
    @dhawalghia 11 месяцев назад

    Hi Kenji, thanks for this video. I need one help. If some one sends me a request and i want to send him an auto email reply saying "Hi we have ack the receipt of your mail. Someone from the team will revert on your request. Kindly note the ticket number 0001" can we automate this and once the ticket is closed then he will get the email "Hi your ticket number 0001 has been closed". How can we do this using excel and outlook ?

  • @edmundlegitimas1737
    @edmundlegitimas1737 6 месяцев назад

    regarding excel auto email, what if i need to excel, print as pdf and then email

  • @an5048
    @an5048 5 месяцев назад

    I really like you man, your thinks are just amazing, please continue

  • @daveyvergara
    @daveyvergara Год назад +1

    I swear, you have helped me tremendously throughout my career. THANK YOU SO MUCH!!

  • @cjbrown3396
    @cjbrown3396 6 месяцев назад

    Hey Kenji I faced a problem when sending the emails. Error shows "ActiveX Component Cant Create Object Run-time 429 Error." Debug line highlighted Set outApp = CreateObject("Outlook.Application"). Could you please help?

  • @AnkishToshniwal
    @AnkishToshniwal 3 месяца назад

    Sir it is showing me an error- Run-time error '429'
    ActiveX component can't create object
    What should I do then?

  • @jabulanijama7569
    @jabulanijama7569 5 месяцев назад

    I'm trying out this example but it's not working. I wonder where I'm not doing it correctly

  • @melisbas5049
    @melisbas5049 5 месяцев назад

    Thank you so much for this resource!

  • @TessHere
    @TessHere Год назад

    Very useful examples. For the last example, you gave me an idea of sending a file on the laptop to the printer depending on what the answer of the user is (eg 1 then print docA, 2 then print docB, 3 then print both ). What would the dim for a printer be ? Thanks.

    • @Tokinjester
      @Tokinjester 11 месяцев назад +1

      I don't think you'd need a DIM for the printer, you'd need one to determine which document you want to send to the printer e.g.
      DIM DocToPrint As String
      DocToPrint = _the name of the doc your user selected_ (which would be the result of your function, If 1 then print docA, ElseIf 2 print docB, ElseIf 3 then print doc C)
      doc C could just be a copy of docA inserted and saved into docB, or you could write a loop to print docA then print docB

  • @IarukaSkYouk
    @IarukaSkYouk Год назад +1

    Kenji you are a GODSENT bro
    I'm so thankful for your teaching

  • @drax432
    @drax432 10 месяцев назад

    I wonder if microsoft has ever improved and enhance VBA language in terms of api and syntax

  • @anonymoususer4356
    @anonymoususer4356 8 месяцев назад

    Good video. Thank you.

  • @pokrpork
    @pokrpork Год назад +3

    15 minutes video ,just good enough to study for my exam in 1 hour

  • @weike656
    @weike656 Год назад

    Thanks Kenji, 12:38 how to send to 2 peoples email or cc another one email?

  • @SalvadorGarcia-rt1kk
    @SalvadorGarcia-rt1kk 8 месяцев назад

    Hi sir, how to enrol in the VB course and how much it cost, thank you.

    • @KenjiExplains
      @KenjiExplains  8 месяцев назад

      Hey thanks for your interest. You can learn more here: www.careerprinciples.com/courses/vba-macros-for-business-automation

  • @Servants_Heart
    @Servants_Heart Год назад

    How much is the class?

  • @francesdobbins2964
    @francesdobbins2964 Год назад +2

    Thank you, Kenji! Can you create more VBA tutorials? Have a good day.

  • @abhikhaire9505
    @abhikhaire9505 11 месяцев назад

    Amazing Video. Must watch for basics of VBA

  • @bryantimaan1575
    @bryantimaan1575 3 месяца назад

    very clear explanation

  • @ankitjadhav6775
    @ankitjadhav6775 Год назад

    can we code it to undo our actions?

  • @erickang3579
    @erickang3579 Год назад +1

    I enjoyed this so much that I went ahead and purchased a full bundle course with the discount.

  • @goodboy6724
    @goodboy6724 Год назад

    Thanks kenji ❤️

  • @waleedalqubati3849
    @waleedalqubati3849 11 месяцев назад

    You make everything thing easy and us eager to learn vba❤

  • @JasonKilgrow
    @JasonKilgrow 11 месяцев назад

    That's cool. I didn't know you could do that.

  • @RishiPradhan-jf1ju
    @RishiPradhan-jf1ju 4 месяца назад

    Thank u so much for this

  • @motopelamohapi4152
    @motopelamohapi4152 Год назад

    Thank you. Kenji.

  • @hayderxyz0
    @hayderxyz0 10 месяцев назад

    you are amazing thank you

  • @khawajarizwan7006
    @khawajarizwan7006 Год назад

    Very informative thanks

  • @antoniotruong5647
    @antoniotruong5647 Год назад +10

    "Sub ClearContent" is the name he gives and the "...ClearContents" is an actual command in VBA. Two different things.

  • @zizosaeed
    @zizosaeed Год назад +146

    Talk to chatgpt and copy paste code is easy and fast don't waste your time in write code just learn how to edit code to face any problem

    • @MasterBaiter69420-g
      @MasterBaiter69420-g Год назад +16

      Lmaooooo jit tweakin

    • @Simplevids786
      @Simplevids786 Год назад +5

      Yes i also do same not wasting a single second go ask copy paste done

    • @Jcohen3503
      @Jcohen3503 Год назад +21

      Bruh, wait til you accidentally get an error that you didnt edit out that deletes your data 😭

    • @pamuji_alfaruq
      @pamuji_alfaruq 11 месяцев назад

      True.

    • @rubixio8014
      @rubixio8014 10 месяцев назад +27

      I strongly believe your suggestion is not good. If anyone is trying to patch chatgpt code to build a project then I strongly advise they get a VBA fundamentals, this I a programming language with weird rules, one mistake could cost you your precious data if you don't have a good understanding of what you're doing

  • @nirvickdas7674
    @nirvickdas7674 Год назад +1

    Bro you underrated ❤ you are the best teacher

  • @Juan-Hdez
    @Juan-Hdez 11 месяцев назад

    Very useful. Thank you!

  • @poulinfranciscas2146
    @poulinfranciscas2146 Год назад

    Nice video. Thanks for sharing.
    Please share I want to send emails with multiple vendors at the same time.

  • @mukeshkunkolkar5524
    @mukeshkunkolkar5524 Год назад

    Sub OpenDartFolder()
    Dim folderPath As String
    folderPath = "C:\Users\kunko\OneDrive\Desktop\Dart"
    Shell folderPath, vbNormalFocus
    End Sub
    i have written this VBA Code and assingned macro button to it but when i click or run the code an error occurs showing invalid procedure call or argument. what might be the problem please do help me it will be very greatefull of you.
    this code is used to excess folder present at any location in your pc using excel file and macro so please do help me

  • @Variedviews8711
    @Variedviews8711 Год назад

    Hi Kenji, is there any site which sells the templates?

  • @Urf_Keshav
    @Urf_Keshav Год назад

    More vba please ❤

  • @HamdanYouTuber
    @HamdanYouTuber Год назад

    Useful video, thanks

  • @JeriRodgers-f4w
    @JeriRodgers-f4w Год назад

    Helpful informatiion

  • @tato2493528
    @tato2493528 Год назад

    never knew vba was this powerful

  • @jaedonbigbrain8700
    @jaedonbigbrain8700 Год назад

    You are a genius bro :)

  • @zorgitron
    @zorgitron Год назад

    Dude the background music makes me so hyped while I'm Typing in some VBA。

  • @NerdsRunTheWorld
    @NerdsRunTheWorld 7 месяцев назад

    Oh this is great

  • @camlex6310
    @camlex6310 Год назад +1

    More VBA videos please!!

  • @spring802007
    @spring802007 11 месяцев назад

    I tried it, shows ambiguous name!

  • @nhojareubla
    @nhojareubla Год назад +1

    very informative thanks sir!

  • @hansgulbranson9506
    @hansgulbranson9506 8 месяцев назад +10

    My favorite part about this video was how confusing it was.

  • @sebastiankumlin9542
    @sebastiankumlin9542 10 месяцев назад

    Great explanation! VBA just seems so weak!

  • @nishanth4323
    @nishanth4323 Год назад +1

    Sensai....more vba video's 🙏

  • @michaelquach6655
    @michaelquach6655 Год назад +2

    More VBA please 🙏

  • @JOHNNYKAZANDRE
    @JOHNNYKAZANDRE 6 месяцев назад

    I want to be your disciple please advise.

  • @vikramadityarathore97
    @vikramadityarathore97 Год назад

    Keep up the good work!

  • @willzinner8813
    @willzinner8813 Год назад +2

    can you do a part 2?

  • @solomonbhandari-young4154
    @solomonbhandari-young4154 Год назад

    thank you professor kenji

  • @ElaEastlund-p9z
    @ElaEastlund-p9z 3 месяца назад

    Effertz Stravenue

  • @GrahamOpalicki-u9d
    @GrahamOpalicki-u9d 3 месяца назад

    Maeve Spring

  • @BurnsLindsay-m9h
    @BurnsLindsay-m9h 3 месяца назад

    Lucio Trail

  • @AnibalNall-n9e
    @AnibalNall-n9e 3 месяца назад

    Flatley Cliffs

  • @eotppanpoli25
    @eotppanpoli25 Год назад +2

    7:59 Ada namma T.R

  • @Tanzif_ishmam
    @Tanzif_ishmam Год назад

    Interesting

  • @CrystaLuckado-m7c
    @CrystaLuckado-m7c 3 месяца назад

    Stanton Passage

  • @BlakeViola-o7y
    @BlakeViola-o7y 3 месяца назад

    Windler Oval

  • @WendellRamirez-q6p
    @WendellRamirez-q6p 3 месяца назад

    Morar Throughway

  • @MooreCamp-n4e
    @MooreCamp-n4e 3 месяца назад

    Stiedemann Glens

  • @Gundal66
    @Gundal66 17 дней назад

    I thought VBA was outdated yet I saw lot of ads asking for it.. smhu 😅

  • @BernalParker-c5c
    @BernalParker-c5c 3 месяца назад

    Diamond Lights

  • @micmv
    @micmv Год назад +1

    You could literally do this with a simple IF excel formula...

  • @FrankVeblen-c5h
    @FrankVeblen-c5h 2 месяца назад

    Wyman Lights

  • @SilasAdonis-c4i
    @SilasAdonis-c4i 2 месяца назад

    Green Spur

  • @amarsharma1148
    @amarsharma1148 4 месяца назад

    Dear family.
    Basics will always remain same,even bot writes ur code,u shud have ample sense to judge it,becos machine only knows 0 ,1,so stick to basics,so even if any contingency occurs,our work doesn't suffer
    Hope makes sense.
    Cheers 🥂

  • @WhitmanJulia-d6b
    @WhitmanJulia-d6b 3 месяца назад

    Kennith Mount

  • @RuskinDonna-q1p
    @RuskinDonna-q1p 3 месяца назад

    Cali Drive

  • @VincentMalory-d3u
    @VincentMalory-d3u 3 месяца назад

    Daniella Cape

  • @EvelineJuliet-o9o
    @EvelineJuliet-o9o 3 месяца назад

    Cleveland Vista