Friday, 30 November 2012

What is the difference between ActiveWorkBook and ThisWorkbook

Excel VBA -ThisWorkBook Vs. ActiveWorkBook
ThisWorkBook object refers to the workbook in which the macro code is contained. 

ActiveWorkBook object refers to the workbook that is currently active.

Most times, they will refer to the same workbook. But if the workbook on which running the macro code is not the active workbook then they will point to some different objects.


Thanks.,
Tamatam
            MBA

No comments:

Post a Comment

Hi User, Thank You for Visiting My Blog. Please Post Your Feedback/Comments/Query.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts