Tags » Vba

Version 1.22 - Hotfix

There was an issue with some of the features when a password protected VBA Project was loaded. This caused several of the tool window, most notably the Test Explorer, to fail to open. 43 more words


NSE Live Indices into Excel

One of our blog reader, Bimal has asked for how to get live NSE Indices (CNX Nifty, India VIX) into Excel. As posted in the previous blog posts, to get any live data we need to perform two steps. 256 more words


VIDEO: Using VBA for Excel and the XDK to Improve the @RISK Experience

This recorded webcast, led by Palisade expert trainer Rishi Prabhakar, explores the use of VBA (the programming language for Excel) to control @RISK functionality to simplify the process of risk analysis for resource-strapped businesses. 113 more words


Hide or Show an Excel Ribbon using VBA

This post demonstrates how to hide or show an excel ribbon using VBA (Visual Basic for Applications).

In certain cases it may not required to show an excel ribbon to the user. 292 more words


Sending an XML-RPC Message from VBA (e.g. Excel) to Wordpress

If you want to send an XML-RPC payload to WordPress from Microsoft Office (e.g. Excel) then you can use the following function. In there the wpURL is expected e.g of the form “ 194 more words


Permutations with repetition using Excel

The back story

Recently I have been trying to limit my use of VBA. It’s not that I was addicted and needed to go to VBA-rehab, on the contrary, I still love VBA till death do us part.  1,174 more words


Count spaces in cell

This function will count spaces in a cell. You can replace the space with any other character, and it will return the of it, in an exact match. 39 more words