Hi all,
At work, we have a handful of add-ins that have been used for quite a while. I'm not sure when they were originally written, but when we switched from Office 2003 to Office 2007, a lot of them didn't work until we got a VBA converter from MS. We have now switched to Office 2010 and are having the same problem. MS sent our IT department a VBA converter pack (converter, several .dll files, etc) with instructions, but that has not worked. I can post the instructions if that would help. One of the IT guys I've spoken with stated that MS had a solution for 64-bit systems running Office 2010, but not 32 (I'm on 32). But, the instructions that came with the VBA converter say it will work for both 32 and 64-bit systems running Office 2010. I know I have the add-ins in the right location. Unfortunately, our IT department is struggling with what to do because they are not familiar with VBA code and don't deal with Excel issues regularly. I am more familiar with the location of the add-ins, how they work, etc. The last suggestion was to try to get a local tech support person from MS over to our office to try to figure it out.
To make matters more interesting, the last step in the instructions says to extract each VBA module and then import it and that should take care of any language issues from an older version of Excel to 2010. However, all but one of the add-ins were purchased and are password protected. AND, the one that is our own code and not password protected STILL doesn't work after exporting and importing it. We've never had to mess with the modules when installing the VBA converters for older versions of Excel.
Has anyone experienced a similar problem and/or been able to get add-ins written in an older version of Excel to work in Excel 2010?
Thanks in advance!
At work, we have a handful of add-ins that have been used for quite a while. I'm not sure when they were originally written, but when we switched from Office 2003 to Office 2007, a lot of them didn't work until we got a VBA converter from MS. We have now switched to Office 2010 and are having the same problem. MS sent our IT department a VBA converter pack (converter, several .dll files, etc) with instructions, but that has not worked. I can post the instructions if that would help. One of the IT guys I've spoken with stated that MS had a solution for 64-bit systems running Office 2010, but not 32 (I'm on 32). But, the instructions that came with the VBA converter say it will work for both 32 and 64-bit systems running Office 2010. I know I have the add-ins in the right location. Unfortunately, our IT department is struggling with what to do because they are not familiar with VBA code and don't deal with Excel issues regularly. I am more familiar with the location of the add-ins, how they work, etc. The last suggestion was to try to get a local tech support person from MS over to our office to try to figure it out.
To make matters more interesting, the last step in the instructions says to extract each VBA module and then import it and that should take care of any language issues from an older version of Excel to 2010. However, all but one of the add-ins were purchased and are password protected. AND, the one that is our own code and not password protected STILL doesn't work after exporting and importing it. We've never had to mess with the modules when installing the VBA converters for older versions of Excel.
Has anyone experienced a similar problem and/or been able to get add-ins written in an older version of Excel to work in Excel 2010?
Thanks in advance!