Problems building Excel Addin from Command Line LoadBehavior changes

Y

Yani

Hi all,

Just joined this newsgroup because I can't find any forums out there
for Excel Plug-In developers.

I am working on an Excel Plug-In that is for users of Excel 2000 and
above. And everytime that I build it from within the IDE I see a new
registry key is created under

HKEY_CURRENY_USER\Software\Microsoft\Office\Excel\Addins\MyAddin.Connect

In this registry key there is a REG_DWORD value "LoadBehavior" and its
value is set to 3. Which to my understanding means the plug-in is
"Connected" and will "Load on Startup". Which means that everytime the
user starts excel, my addin will run. If I change this value to 1, the
plugin is simply "Connected", and will not run when the user starts
excel.

So, my problem is that when I build the plug-in from the command line
the registry is loaded with the same information as before but except
that the value of LoadBehavior is 1.

This is causing me many headaches because I feel that the VB6 command
line compiler is screwing up badly.

And to make this more interesting, if I continue to build the addin
from the command line, for certain iterations the value of LoadBehavior
will be correct, 3, and for all other cases, its value will be 1.

Anybody know anything about buliding VB6 addins? I have the proper
values set in my Connect.Dsr file, "Connect at Startup", and I have
verified these values by looking at the text of connect.dsr in a text
editor.


Thanks,

John Stratoudakis
johnstratoudakis at gmail dot com
 
Y

Yani

Here is a quick update:

I changed my build batch file to not build my excel addin, so what I do
now is check out the project from sourcesafe, increment the build
number, build the project, check it back in, then run my batch file to
build the installation package.

Where I figure this out, I'll let the group know,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top