Error : with Vista and our VBA Add-In.

Hello



We actually have a problem with Vista / Office 2007 and our VBA Add-In.

In fact, we are an accounting software development company and have
developed a add-in for accounting functions in MS Excel.

This add-in is working perfectly well since 6 years and the different
versions of OS and/or Office.



More and more we have customers encountering troubles with this add-in. All
of them are configured with Vista and Office 2007.

We have already tried a lot of things (Turn off U.A.C., in the Excel
options, modify the trust center settings, updates of Vista and Office,…)



The trouble is when I try to add this add-in (by browsing) and select
“myaddin.xla”. I click on OK and I receive a message “Excel has stopped
working”

When I restart my Excel, Excel propose to disable this addin (notifying me
that this addin causes a crash)



When trying to analyze witch line (in VBA) causes the crash, it seems to be
the function “workbooks.add” but we are absolutely not sure of that.



Can you please have a look at this problem and give me a solution to this
problem.



Thank you in advance.



GĂ©rald BONSANG
Training & Tech. Support Department
sa WinBooks nv
Fond Jean-Pâques 6 C Tel : 010/45.12.44
1348 Louvain-La-Neuve Fax : 010/45.91.01