Exception Error using code from 'From VBA to VSTO'

L

Legacy 69293

Guest
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?
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Joined
Feb 8, 2002
Messages
3,050
Office Version
  1. 365
Platform
  1. Windows
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).
 

Forum statistics

Threads
1,136,427
Messages
5,675,777
Members
419,585
Latest member
popsin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top