Welcome to my blog! I’m excited to introduce you to the power of Excel’s Lambda functions. I recently recorded a video on
Start Your Lambda Journey With This
Category: Visual Basic
Toggle all Power query Columns Auto-Fit
When loading data into an Excel Table using PowerQuery, the Table columns may automatically resize each time the query is refreshed. This can affect the
Shell.Application Weird Behavior: Prevent Debugging Headaches Now!
Exploring VBA (Visual Basic for Applications) can sometimes feel like finding your way through a complex puzzle, especially when working with the
3 Techniques for Character Validation in VBA
In VBA we need to check if a character is valid or not. So, let me give some examples: 1️⃣ File Name
Win and MAC Compatible File Selector
Recently I have found one post on File Selector for windows to use in power query. I would suggest you to checkout
Secret Power Of Web.Contents PQ Function: Options[Content] Parameter – Part 5
I am sure you have rarely used this or know about this. Yes, You can use the POST HTTP method using Web.Contents.
Update VBA Code From Github(Single Code Source).
I had one idea for long time that how can we store all the utility code into one single place(Need to be
Replace Space From Power Query Step Name Using VBA
In this blog post, I will show you how to replace space from the Power Query step name using VBA. This can
How to Get Downloads Folder Path from Registry Using VBA Win API
If you are working with VBA and need to access files in the Downloads folder, you might wonder how to get the
GitHub merge conflict for binary (excel) file
If you have worked with GitHub and excel files, then you may have faced this scenario. Let’s say you have two branches,
