Geek asks and answers

Excel VBA project does not close

I have a COM addon in which I handle excel events. I click Alt F11to view a VBA project related to excel. However, when I close the book, the Excel VBA project in the project explorer also does not close.

It closes normally when my COM addon is not installed. What happens and what should I do differently?

+3
source share
2 answers

The problem was that the book's objects remained in memory. By clearing objects in a workbook deactivation event, the VBA project closes when I close the workbook.

See this: http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/377fbebc-021d-4e48-aaef-d4658cc221b3

thank

+1
source

COM-Add-In (#/VSTO):

Windows.Forms.Tree . TreeNode.Tag. , , , "" VBA Workbook. , Workbook-Objects TreeNode Workbook.FullName-String ( ).

, ,

0

More articles:


All Articles