Tuesday, 20 August 2013

Lost VBA when downgrading from excel 2013 to excel 2010

Lost VBA when downgrading from excel 2013 to excel 2010

I am on windows 7. In the past I waas using excel 2003. I installed office
2013 and found that my office 2003 was in tact and I could run both
versions. I made updates to some worksheets using excel 2013 and VBA code.
I was informed that I needed to use office 2010 (I won't go into the
reasons) so I uninstalled office 2013 and installed office 2010 (Corporate
licenses). When I open the spreadsheets that I modified using excel 2013
in 2010 I get a microsoft visual basic for applications message "Class not
registered. Lokking for object iwht
CLSID:(AC9F2F90-E877-11DE-9F68-00AA00574A4F). When I hit ok, I get the
excel message "Excel found unreadable content in "name of
spreadsheet".xls. Do you want to recover the content of this workbook?" If
I select yes then I get a message that reads "Excel was able to open the
file by repairing or removing the unreadable content. Lost Visual Basic
project. Reparis were made to PivotTable report, ONe or more invalid
conditional formats were removed from the workbook and Lost ActiveX
controls.
Now the VBA code is not found. The workbook opens and looks normal but
buttons running VBA don't work and when opening VBA (alt F11) I don't see
any of the modules.
I tried running the FM20.dll using regsrv32.exe and I get a message which
says "The module fm20.dll failed to load. Make sure the binary is stored
at the spedified path or debug it to check for problems with the binary or
dependent .DLL files. The spedified mdoule could not be found". But I ran
regsrv32 from the subdirectory the FM20.dll was in.
I presume my problems have to do with losing the visual basic project and
or ActiveX controls.
What do I need to do to be able to find the vba code that was there before
removing excel 2013 and installing excel 2010?
THank you for helping me.

No comments:

Post a Comment