xla add in issue

[Guest]

Hi,
I have created an xla file (using VB and VBA) which is part of Excel add-in
when I open Excel up. But when Excel is shut down and I click on any xls
workbook to open it up, my xla add-in prevents it from opening.(Excel opens
up and is empty). If I remove my xla add-in, this problem goes away. Is
there a way to solve this problem? I was told that the code has to be
converted from xla to xll to solve this problem. If so, do I have to convert
all my VB and VBA code into C/C++ to convert it to xll. Any suggestions
would be highly appreciated. Thank you, PM

 

[Tom Ogilvy]

You shouldn't have to convert your code to C/C++ to use an adding.

The usual cause of the problem you describe is on of two things.

In Tools =>Options=>General, Ignore Other applications is checked. It is
possible that somehow your XLA is causing this option to be checked. Check
it before you load you addin and after and see if it gets checked.

The other possible solution is to reregister Excel.

With excel closed, go to the windows start menu and select run

Excel.Exe /unregserver

Then click OK.

Now repeat with

excel.exe /regserver

This causes excel to reregister itself in the registry.

However, I am not sure how you addin would affect that, but something else
to try.

 

[Paulw2k]

"If I remove my xla add-in, this problem goes away" -

Check your coding in the add-in file, that is the most likely source of the
problem.

Paul

 

[Guest]

Thanks Tom,

I tried both your solutions and am still having the same problem. The
"Ignore Other Applications" is always unchecked. I unregistered and
reregistered the server - no change.

Please let me know if there is anything else I can try.

Thanks,
PM

 

[Guest]

Thanks Paul,

I am trying hard to find if the code is preventing Excel files to open up -
no luck as of yet!

Let me know if you can think of anything else I can do.

Thanks,
PM

 

[Rob van Gelder]

Change the code in the add-in so that it's startup code does not run -
comment it out.

See if the problem still occurs.
If the problem goes away, uncomment sections at a time until the problem is
found.