ChatGPT: Automating Excel with VBA like never before 🤯

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this video, I'm going to show you how I use VBA and ChatGPT to automate some pretty tedious Excel tasks. We'll be consolidating data, sending mass emails with personalized text and attachments, and even automating pivot table creation. I'll walk you through step by step, showing you how easy it is to use ChatGPT to generate the VBA code for these tasks, and how little effort it takes to implement them in your own workbooks. So, come along with me and let's make Excel work for us, instead of the other way around!

🌍 𝗟𝗜𝗡𝗞𝗦:

⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
00:00 – Intro
00:26 – 1. Example: Extract data from multiple files
02:15 – 2. Example: Send personalized emails
05:59 – 3. Example: Find and replace values
08:15 – 4. Example: Create pivot tables and charts
10:15 – Outro

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:

[CodingIsFun]

*What do you think of ChatGPT in combination with VBA? Let me know in the comments!*

All the Excel files and ChatGPT prompts used in this video can be found here ⤵

[rbo]

I'm not a programmer, but I used to work near of topics that instigated me try to learn vba. I never did it because I'm very lazy. This video shows me that it was a good choice and sometimes laziness is virtue.

[alpenglowist]

I've been playing with this and have had tremendous results. I also have nearly 15years of experience with Excel and I've found that it's very useful (critical) to be able to succinctly describe to GPT what you want it to do. This is proving very difficult for junior staff with no coding or VBA experience. The digital brain hasn't replaced me yet!!

[markk]

Been testing this out for a few days now. I retired recently but am preparing to train my replacement on VBA, about 80% in Word and 20% Excel. Generated code for simple and mid-level stuff is surprisingly accurate, so it's gonna make my job (and hers) much easier. The bot doesn't always handle complex macro tasks well -- in one attempt, for what would've been the guts of the macro, it just made up a VBA method that doesn't exist. But that's hardly a dealbreaker at this stage. I'm sold.

[zaksept]

Cool video.

I write a lot of reports in excel and used chat GPT to write a python script that will submit text to the OpenAI API. Chat GPT wrote a VBA script for me to run where I select a cell and it's pushes the text from a cell to the API with instruction to "rewrite this phrase for a business report".

The text returned from the API then replaces the text in the cell. It has really accelerated my report writing and fixed all my grammar or spelling errors.

[kirk]

Thank you, THANK YOU for these examples and the great explanations!! I have been using Excel since around 1993, and have decent VBA coding knowledge, but watching how you got ChatGPT to create code from scratch is incredible. I really enjoy coding on my own, but having this new resource is a game-changer. Thank you again, subscribed! 😁👍

[armchair_mechanic]

Pretty amazing. It's nice to have a background in VBA to help you get past the humps. Looks like you are doing far fewer iterations if you have to debug code. It does show that code knowledge is still useful.

[MartinHiggs]

I have always understood the flow of macros, been able to copy and paste code and amend, chatgpt is great as can still make new changes if not quite what I need

[kpm]

I've tried python and VBA with Chagpt with mixed results. I find it useful for writing single lines of codes rather than entire subroutines. It ends up taking a lot more time than if you did it yourself from scratch.

[GiZeeGis]

I think this video shows why no job is going to be lost! While I am comfortable using excel, I would not have known those prompts or how to fix the error

[DanielWeikert]

Great work. Got my sub.
I agree it would be very interesting if you could dive deeper into the prompt development. That's most important. I guess you have to refine it a few times. Could you do a video on that
br

[robwin]

Hello, I have begun teaching myself Python, and I am currently heavily skilled in VBA.

I will cease Python studies and incorporate ChatGPT to extend my VBA skills.

Excellent demonstration.

Kind Regards.

[bernardofacciolli]

Man i love these types of videos using Chat GPT... I would enjoy even more if you use python to automate excel, i thought the video you made it was to shallow so another one would be awesome. Great content!

[markk]

This is incredible. If I were smiling any wider the top of my head would fall off...

[utube]

Thanks for the great video. Good to know how to use ChatGPT effectively.

[isaidgomez]

I’m doing a final proyect for my university, and as of now I’m was wondering how to automate the work hours and make decision based on different variables so the excel can give an estimate on how much will it take to complete the task and how many people should be hired based on a 10 year historic information, and I’m learning a lot from your videos, still a bit lost but I will keep watching them until I figure it out! Thank you!

[JB-NZ]

Thanks for the video, it really was great to learn about this. I gave it a go to write Excel VBA for a problem I had only just solved manually, to see how the AI did it, and had very mixed results. It seems to generate the subroutine, but then stop part way through - every single time. Its almost like there is a line limit or something on the AI and it wont generate the rest of the code beyond this point. Have you found that? Also, getting it to correct issues is great, it seems to remember context - but sometimes it gets really messed up and starts generating new code and new variable names, none of which match up. Overall though its awesome, I just wish it would continue to generate the whole subroutine, rather than 3/4 of it, and never seem to get it to show the last bit.

[chamamemestre]

This is great. ChatGPT is a God send. I spend weeks going through (manually) hundreds of excels. I wonder if I can do an approach like this with minimal VBA knowledge. Though I will see if ChatGPT can do the same in Python, where I am more comfortable.

[jorgemacgenity]

Great tips. I wonder how far we will go with Chat GPT in the future. This is going to help me a lot. Thanks

[afonsoosorio]

Great 👍, thank you for sharing. Very informative