The following function called XorEncrypt can be used to encrypt the data source server name, database name, username and password within a connection string in the following format: ...

This is a small proof of concept but a working one. The need is the following: you have an Excel worksheet that contains a large number of columns and, based on rules, you want to complete a column ...

At the end of last year two new, fairly minor, improvements were made to Excel VBA’s support for Power Query: you can now refresh and delete individual Power Query queries. These methods are available ...

So, I am writing an application to pull a SQL query from an Oracle DB and paste the data into Excel. The problem is that the SQL string is over 2200 characters long ...

The constant innovation in new technologies in this rapidly changing world is significantly inducing disruption across industries globally. The velocity and scope of this disruption is forcing ...