RoseTech is created to share my experiences on VBA technology in last 10 years.
With this site, I will be providing my knowledge and creating an ultimate source of VBA code
This site will display the VBA code created by me time to
time in my professional career. If you do
not find the code you are searching for or if any question comes
to your mind about VBA or MS Office applications, feel free to
write your queries / question on VBA. I will try to solve it.
Visual Basic for Applications (VBA) is nothing but Visual Basic 6 implemented and associated
in most of the Microsoft Office applications. This is done by embedding the VBA IDE into office applications.
It can be used to control almost all parts of the host office application. This includes access and manipulation of UI (User Interface), toolbars, Menu Bars etc.
VBA uses the Visual Basic Runtime, but only run VBA code within a host office application. It has a great advantage of connecting and controlling one application from another using OLE Automation. e.g. Word connecting to Excel to import data and creating reports.
VBA language is extremely rich in functionality and flexible. It has flexibility to use ActiveX or COM DLLs but cannot create it.