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:

Dim frmDownLoad As New frmFTP
Dim lRC As Long             'return code from download
Dim recItems As sFTP_DownloadItems
Dim tStart, tEnd As Date
Dim lElapsed As Long   'used for seconds holder for download.

tStart = Now()

    With frmDownLoad
        .bTS.Value = Sheets("LastUsed").Range("TS").Value
        .
        .
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).