Tag Archives: EarlyBinding

What is a VBA Dictionary?

A dictionary is an object in VBA (similar to a collection) that stores data like an array. It can be used to store data of any type except an array. A VBA dictionary has two parts: Key Value …where key is simply a reference to the

No Thumbnail

VBA, Excel Automation From Other Applications

In this article I will explain how you can automate an Excel workbook from another application. There are basically two methods for automation: Early binding Late binding I have explained the difference between these two methods when I was explaining about word automation: VBA, Automating