Secret Power Of Web.Contents PQ Function: URL Parameter – Part 2
If you haven’t checked the different parameters of Web.Contents function, then please check them from MSDN. In this post, we are going
Secret Power Of Web.Contents PQ Function: Helper function – Part 1
I wish I knew all of this or could find one place to learn everything about Web.Contents power query function. I used
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,
Essential CODE Snippets for Every PROJECT in 2023
to SAVE Debugging Time
If you want to reduce debugging time, this post is for you. It would help if you had these code snippets in
SAVE Debugging
If you want to reduce debugging time, this post is for you. It would help if you had these code snippets in
List.Generate in Power Query – A Complete Guide With Examples
If you don’t know what List.Generate is then see the docs from Microsoft first. If you look carefully then you will notice
