In my latest video I show how to use the GetOpenFilename() function to allow users to select a file or multiple files.
I also cover how to copy data from these files and how to write optimal the code to do optimize the performance. youtu.be/dQB2LYCw0Ko#ExcelVBA
My latest video covers the little-known but incredibly
useful Enums.
"Enums: The Key to Cleaner, More Efficient VBA Code"
Video Link: youtu.be/Kxeqydve-CM#VBA#ExcelVBA#VBAEnums
@brennandunn I ended up using Quaderno. It automatically charges VAT and can also do a company reverse VAT charge. Works with PayPal and Stripe. The downside is that it's not as flexible as other checkouts.
Is there really still no easy way to:
1️⃣ Find Stripe payment
2️⃣ Add customer address + tax ID
3️⃣ Either append to existing receipt or create a new (paid) invoice from that payment
I'm still finding myself using free invoice PDF generators, plugging in data, and exporting 😂
Video link: youtu.be/mfG74mJr_8g
Brand new video "How to Combine Multiple Excel Files using VBA".
If you need to read data from multiple files using VBA then you cannot afford to miss this video.
#Excel#ExcelVBA
@MacroMastery Thank you for your YouTube videos on how to improve VBA performance. Your teachings just helped solve a performance problem which has vexed me for over a year. What once took 14 seconds, now runs in less than 1 second. Sláinte!
Yay!!! I'm excited to be renewed as a Microsoft MVP (M365 Apps and Services) for the 3rd consecutive year!!!🤗🤠🤓.
All glory be to God and thanks to Microsoft
Another year to churn out technical contents
Congratulations to me 💕
#mvpbuzz
My latest video covers everything you need to know about VBA Arrays in 3 minutes.
Long videos have their place but sometimes you want all the info quickly:-)
youtu.be/vDn5OpH0y6Y#VBA#ExcelVBA