For decades, Macro viruses are a serious problem. Does it mean that Windows, Office and VBA – all Microsoft products – are insecure?
Absolutely not. Microsoft gave you the ability to stop Macro viruses
– instantly – ever since Office existed (25 years+).
This is a technical article – for Security and IT professionals.
Reading time (7 min)
Continue reading Stop Macro viruses instantly
Here is a list of Macros I have written for various Office tools. Usually we feel that any repetitive task requires a macro. That is a wrong concept. Typically, repetitive tasks indicate that the method you are using is inefficient. Usually there is an efficient way to do the same job – which eliminates the repetition.
Continue reading Macros Knowledge Pack
Here is a new year gift for the Indian customers. Converting Amount to Words is always a problem. Many application require it and that code is always written manually, within the application. What is really needed is a comprehensive Excel function. Many people have written lots of Excel functions. But neither of them is specific to India, nor is it comprehensive.
We (Raj and me) had created it in 2005, but I had forgotten to publish it on the blog. We have done good amount of testing – but still you have to use it at your own risk. No guarantees. Read on to download, install and use the Excel function.
Continue reading Amount to Words macro
In the earlier post, we saw how boring text can be converted into interesting and high-impact slides. The only pending problem was that splitting text into words or characters needed to be done manually. That is a tedious process. Therefore, I wrote a macro to simplify this activity. Read on to find out how to download and use this macro.
Continue reading Split text into words or characters: Macro
In an earlier article, I had shown a method of making a picture transparent using the Transparency animation. This method shows the transparency only while PRESENTING – not while EDITING. Here is a macro which will help you create a transparent copy of any picture which is transparent during editing as well.
Continue reading How to make a picture transparent – Macro
Refer to the previous post. We saw how Filter fields can be exploded into individual sheets and files. In this article, I am releasing a macro – which does all the hard work for you. Of course, you must use it at your own risk. The source code is also included for you to view, learn from and modify. Created by Raj Chaudhuri and myself.
Continue reading Macro to Explode Pivot table by Filter Field Items
Repetitive activity? Record a macro. Right?
Find out why…
Continue reading When NOT to record a macro in Excel
I created this Paste as Pivot utility (macro) along with Raj Chaudhuri. It helps you in copying cells from Pivot Table and pasting them as GetPivotData functions. You must read this article about GetPivotData in order to understand the background information.
Estimated reading time 8 min
Continue reading Paste as Pivot – New way to use Pivot table data
This is a utility I created along with Raj Chaudhuri many years back.Use the scribble tool to draw a waveform or shape, the utility will create the data for it.
You can then create a line chart which looks similar to original drawing.
Try it out.
Continue reading New Excel Tool: Scribble a line and generate data (and chart)
Any corporate sales presentation usually have a “our customer” slide. Usually creating such a slide is very cumbersome because the logos come in all shapes and sizes. Someone has to spend inordinate amount of time resizing and aligning all the logos – and often, the slide still looks shabby … Here is a method which will solve your problem instantly.
Continue reading Marketing: How to create “Our Customers” Slide in seconds