VSTO newbie: how to call method in ThisWorkbook using button in Excel 2003?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stefan - 24 Feb 2008 17:09 GMT

Hi,

I'm just writing my first VSTO excel app. How can I call a method
defined in ThisWorkbook.vb? I created a button in my worksheet. Using
the click event I now want to call the method. But intellisense does
not show my method when I enter "ThisWorkbook."

Maybe I have been working too long this weekend and are just blind
now...

TIA,
Stefan

Reply to this Message

Stefan - 25 Feb 2008 07:51 GMT

After some hours of sleep, I found it myself:
Globals.ThisWorkbok lists all my public methods from ThisWorkbook.vb.

Now I face a new problem. Further down my code I get a COM exception
with HRESULT 0x800A03EC
Maybe I should go to bed again...

> Hi,
>
[quoted text clipped - 8 lines]
> TIA,
> Stefan

Reply to this Message

Stefan - 25 Feb 2008 22:24 GMT

Found the reason for the COM exception, too: one of the named ranges
had a typo.

> After some hours of sleep, I found it myself:
> Globals.ThisWorkbok lists all my public methods from ThisWorkbook.vb.
[quoted text clipped - 17 lines]
>
> - Zitierten Text anzeigen -

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...