Hi,
Your VB6 add-ins will not work in 64-bit Office 2010.
http://technet.microsoft.com/en-us/l.../ee681792.aspx
Quote:
ActiveX controls and COM add-ins ActiveX controls and add-in (COM) DLLs (dynamic link libraries) that were written for 32-bit Office will not work in a 64-bit process. As a result, Office 2010 64-bit solutions that try to load 32-bit ActiveX controls or DLLs will not work. Installations of 64-bit Office 2010 will run only 64-bit controls. Computers can have 64-bit and 32-bit controls installed, and Office 2010 64-bit can only run the 64-bit versions of the controls. The workaround for resolving these issues is to obtain 64-bit compatible controls and add-ins or to install Office 2010 32-bit (WOW).
|
Additionally (and I'm sorry to be the bearer of bad news), you cannot compile 64-bit VB6 add-ins.
I think the best option would be to install 32-bit Office 2010 on those rogue PCs (it will work fine on 64-bit Win 7). Other options would be either rewriting your add-ins in VBA or .Net.