🔥 Get 20% OFF our Excel VBA & Macros Course just for the next 7 days! www.careerprinciples.com/courses/vba-macros-for-business-automation
@solomonbhandari-young4154
Жыл бұрын
incredible
@PETERSSEBUFU-y4y
6 ай бұрын
Your in which country
@PETERSSEBUFU-y4y
6 ай бұрын
I want to take courses
@collinsntimarthur8429
2 ай бұрын
thanks
@kemtemartchirouesylvestre
2 ай бұрын
good
@NoelCarson
Жыл бұрын
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
Жыл бұрын
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.
@waleedalqubati3849
8 ай бұрын
Truth 👍
@guilhermeh.v.santos7424
6 ай бұрын
Amazing content in such a short video, straight to the point !! Thanks for sharing
@sharmilasanka2186
7 ай бұрын
Great and simple way of explaining. Thank you so much.
@an5048
2 ай бұрын
I really like you man, your thinks are just amazing, please continue
@user-qp1un7qo2d
4 ай бұрын
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?
@24.ផនពន្លឺ
6 ай бұрын
Thanks Kenji for this video. I learned from you more.
@pablojp3498
Жыл бұрын
Loved it. More vba please
@Seawolf159
Жыл бұрын
Nice video. Annoyingly the email sending doesn't work with the new outlook.
@pokrpork
10 ай бұрын
15 minutes video ,just good enough to study for my exam in 1 hour
@melisbas5049
2 ай бұрын
Thank you so much for this resource!
@hansgulbranson9506
5 ай бұрын
My favorite part about this video was how confusing it was.
@LivingGuy484
5 ай бұрын
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?
@ElaEastlund-p9z
2 күн бұрын
Effertz Stravenue
@AnkishToshniwal
10 күн бұрын
Sir it is showing me an error- Run-time error '429' ActiveX component can't create object What should I do then?
@sergio_molinari
10 ай бұрын
Hi Kenji, helpful video. To reduce the vba code could you write? If Answer = vbNo Then Exit Sub , it's correct?
@bryantimaan1575
21 күн бұрын
very clear explanation
@antoniotruong5647
Жыл бұрын
"Sub ClearContent" is the name he gives and the "...ClearContents" is an actual command in VBA. Two different things.
@jabulanijama7569
2 ай бұрын
I'm trying out this example but it's not working. I wonder where I'm not doing it correctly
@afzaalahmed9565
10 ай бұрын
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.
@eldercleric
4 ай бұрын
can you set it up so that if you have a file up the custom function wil work accross all files?
@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
@stevetheanalyst
Жыл бұрын
I was toldvba and macros are dying because of powwer query. As a financial analysts is it still importance. Thanks
@drax432
7 ай бұрын
I wonder if microsoft has ever improved and enhance VBA language in terms of api and syntax
@francesdobbins2964
Жыл бұрын
Thank you, Kenji! Can you create more VBA tutorials? Have a good day.
@daveyvergara
Жыл бұрын
I swear, you have helped me tremendously throughout my career. THANK YOU SO MUCH!!
@mr.write1433
9 ай бұрын
Which one is faster to calculate? If statement or vba?
@RishiPradhan-jf1ju
Ай бұрын
Thank u so much for this
@claudineyribeiro518
9 ай бұрын
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
@SmartElegent
10 ай бұрын
How can fixed row & column in excel via vba code. But not change size via mouse & in option row & column width.
@AnibalNall-n9e
14 күн бұрын
Flatley Cliffs
@JasonKilgrow
8 ай бұрын
That's cool. I didn't know you could do that.
@edmundlegitimas1737
3 ай бұрын
regarding excel auto email, what if i need to excel, print as pdf and then email
@srisridaran05
Жыл бұрын
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
7 ай бұрын
me too, do you find the solution?
@sebastiankumlin9542
7 ай бұрын
Great explanation! VBA just seems so weak!
@BurnsLindsay-m9h
Күн бұрын
Lucio Trail
@anonymoususer4356
5 ай бұрын
Good video. Thank you.
@Daniel-dj7fh
4 ай бұрын
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
4 ай бұрын
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.
@BlakeViola-o7y
14 күн бұрын
Windler Oval
@khawajarizwan7006
11 ай бұрын
Very informative thanks
@MooreCamp-n4e
12 күн бұрын
Stiedemann Glens
@cjbrown3396
2 ай бұрын
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?
@nhojareubla
11 ай бұрын
very informative thanks sir!
@fengfuxu4822
9 ай бұрын
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
@poulinfranciscas2146
Жыл бұрын
Nice video. Thanks for sharing. Please share I want to send emails with multiple vendors at the same time.
@motopelamohapi4152
Жыл бұрын
Thank you. Kenji.
@dhawalghia
8 ай бұрын
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 ?
@hayderxyz0
7 ай бұрын
you are amazing thank you
@goodboy6724
Жыл бұрын
Thanks kenji ❤️
@IarukaSkYouk
Жыл бұрын
Kenji you are a GODSENT bro I'm so thankful for your teaching
@KenjiExplains
Жыл бұрын
Haha thanks for watching!
@erickang3579
Жыл бұрын
I enjoyed this so much that I went ahead and purchased a full bundle course with the discount.
@abhikhaire9505
8 ай бұрын
Amazing Video. Must watch for basics of VBA
@CrystaLuckado-m7c
9 күн бұрын
Stanton Passage
@waleedalqubati3849
8 ай бұрын
You make everything thing easy and us eager to learn vba❤
@WendellRamirez-q6p
9 күн бұрын
Morar Throughway
@SalvadorGarcia-rt1kk
5 ай бұрын
Hi sir, how to enrol in the VB course and how much it cost, thank you.
@KenjiExplains
5 ай бұрын
Hey thanks for your interest. You can learn more here: www.careerprinciples.com/courses/vba-macros-for-business-automation
@JeriRodgers-f4w
Жыл бұрын
Helpful informatiion
@TessHere
9 ай бұрын
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
7 ай бұрын
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
@Urf_Keshav
Жыл бұрын
More vba please ❤
@HamdanYouTuber
Жыл бұрын
Useful video, thanks
@KenjiExplains
Жыл бұрын
Thank you!!
@HamdanYouTuber
Жыл бұрын
@@KenjiExplains You're welcome
@Servants_Heart
Жыл бұрын
How much is the class?
@zorgitron
9 ай бұрын
Dude the background music makes me so hyped while I'm Typing in some VBA。
@KenjiExplains
9 ай бұрын
Hahaha let’s go 🚀😂
@GrahamOpalicki-u9d
18 күн бұрын
Maeve Spring
@micmv
9 ай бұрын
You could literally do this with a simple IF excel formula...
@amarsharma1148
Ай бұрын
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 🥂
@NerdsRunTheWorld
4 ай бұрын
Oh this is great
@Juan-Hdez
8 ай бұрын
Very useful. Thank you!
@EvelineJuliet-o9o
17 күн бұрын
Cleveland Vista
@messiahscent
Жыл бұрын
05:51 Kenji, when you say, "this sign," which sign is it?
@KenjiExplains
Жыл бұрын
Sorry it’s the : Colon sign
@VincentMalory-d3u
Күн бұрын
Daniella Cape
@HardyJohn-g2x
10 күн бұрын
Mills Garden
@nirvickdas7674
Жыл бұрын
Bro you underrated ❤ you are the best teacher
@camlex6310
Жыл бұрын
More VBA videos please!!
@zizosaeed
Жыл бұрын
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
9 ай бұрын
Lmaooooo jit tweakin
@Simplevids786
9 ай бұрын
Yes i also do same not wasting a single second go ask copy paste done
@Jcohen3503
9 ай бұрын
Bruh, wait til you accidentally get an error that you didnt edit out that deletes your data 😭
@pamuji_alfaruq
8 ай бұрын
True.
@rubixio8014
7 ай бұрын
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
@eotppanpoli25
Жыл бұрын
7:59 Ada namma T.R
@harib7406
10 ай бұрын
😂😂
@CharlesDavis-q1e
6 күн бұрын
Douglas Locks
@JeffreySanchez-e9n
10 күн бұрын
Rolfson Canyon
@StephenBerg-m9l
Күн бұрын
Daniel Coves
@RuskinDonna-q1p
9 күн бұрын
Cali Drive
@followthescience5571
Жыл бұрын
16h ago? I don't want to be rude, but this is a bit late to the party isn't it? Apart from the pain of using this "IDE", most companies block or discourage the use of macros because of security concerns. There is already a javascript api in place for replacement. If you don't know VBA in 2023, don't bother!
@tato2493528
Жыл бұрын
never knew vba was this powerful
@GloriaJordan-s6d
10 күн бұрын
Oberbrunner Harbors
@EvanVita-b2g
8 күн бұрын
Joshua Camp
@NicolAllen
14 күн бұрын
703 Domingo Summit
@AledkNick-z5j
5 күн бұрын
Sam Well
@CliftonDuhe-m1c
11 күн бұрын
Lauriane Avenue
@BabetteTorrain-z6b
Күн бұрын
Kerluke Route
@TimothyAprill-b1y
7 күн бұрын
Sabryna Forges
@jaedonbigbrain8700
Жыл бұрын
You are a genius bro :)
@Variedviews8711
Жыл бұрын
Hi Kenji, is there any site which sells the templates?
Пікірлер: 238