Home / VBA & Scripts

VBA & Scripts

Imagine waking up every morning with your Amazon Ads reports already in your inbox – compiled, analyzed, and ready for action. Running

Exploring VBA (Visual Basic for Applications) can sometimes feel like finding your way through a complex puzzle, especially when working with the

In VBA we need to check if a character is valid or not. So, let me give some examples: 1️⃣ File Name

Recently I have found one post on File Selector for windows to use in power query. I would suggest you to checkout

By default Text.Replace do case sensitive replacing. Sometimes we need to do case-insensitive replacement. I have created a custom function that will

This post is about the third most important parameter and that is Headers. We can pass data to a HTTP Call and

This post is the center point of Web.Contents PQ Function. Please learn it well. In this post, I am going to introduce

If you haven’t checked the different parameters of Web.Contents function, then please check them from MSDN. In this post, we are going

I wish I knew all of this or could find one place to learn everything about Web.Contents power query function. I used

I had one idea for long time that how can we store all the utility code into one single place(Need to be

Stay Ahead with Weekly Insights!

Dive into Excel, Al and other essential tech news:

carefully crafted for the modern professional.