Constructing Add-In

Hi, I'm trying to build an add-in (something I did back in Office 2003), but in Office 2010, I'm experiencing some oddities. I'm thinking it's just simple references and how I'm referring to elements in the add-in as opposed to elements in the currently open spreadsheet. I'm wondering if there is a property that I have overlooked, but even upon opening up Excel, my opening of the command bar shows the menu options where my mouse cursor is instead of on the command bar of Excel. Then when I run a command, I'm getting my main user form not getting created correctly.

What this routine is doing is presenting the user with a form, taking values out of a spreadsheet in the add-in that 'saves' the last used values to serve as a starting place, and then it runs exposed methods from a company that has enabled secure FTP to work with a zOS environment (mainframe).

The opening code of the routine looks currently like the following:

Please Login or Register  to view this content.

but as soon as I hit the "with" statement I see that nothing is allocated to that form in the "locals" window of the project explorer.

I've got to think that it's just how you reference the code, but I can't remember how to treat the add-in code differently. And I searched the internet for a while and couldn't find a good tutorial to do it.

Thanks to anyone who knows this (and it's probably right off the top of your head).

Thank you Andy. That was the issue. As the code was loading up the form I was referencing in the add-in, the initialization routines in the form also needed that line of code. Without that, the form wasn't being created properly and the whole process was failing.

I knew it had to be something relatively simple.