With Vista / Excel 2007 and our VBA Add-In. Winbooks Programmer 6/21/2007 7:17:01 AM 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

Re: With Vista / Excel 2007 and our VBA Add-In. "Nick Hodge" <nick_hodgeTAKETHISOUT[ at ]zen.co.uk.ANDTHIS> 6/23/2007 11:30:40 AM Gerald This is a peer-to-peer group and we would likely need to see the code to see if we can pick something out. Some things you might try 1) Convert the add-in to an xlam (2007 version file) 2) Switch off any AV software and see if that helps 3) Ensure the workbook Excel is trying to open is the new format. Things like these should not happen, but whenever you are porting this type of stuff to a new version it inevitably will. Also it is tough to advise much more as we have no idea what your add-in is trying to do in detail. There may be something there that is conflicting -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT[ at ]zen.co.ukANDTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Winbooks Programmer" <WinbooksProgrammer[ at ]discussions.microsoft.com> wrote in message news:F900F209-EA60-4092-83D3-A57126775BF7[ at ]microsoft.com... [Quoted Text] > 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 > >