Exception Error using code from 'From VBA to VSTO'

[Legacy 69293]

Several places in the code samples (eg. page 100) there is a line of code setting a reference to ThisWorkbook.

dim thisWorkbook as Excel.Workbook = CType(Globals.Thisworkbook,Excel.Workbook)

Every time I have tried the code with this line I get an exception. I think I am following the examples to the letter.... Any suggestions on this one?

 

[MrExcel]

From Gerry Verschuuren:

The problem is that the reader is using a variable label that is the same as the object ThisWorkbook itself:
dim thisWorkbook as Excel.Workbook = CType(Globals.Thisworkbook,Excel.Workbook)

Please change the first one into something like thisWB (as was also suggested and done in the book, btw).