This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am suddenly facing this problem: i have a excel file with (quite a lot) of embedded VB code and activeX.
It works fine under Office 2010 on a PC running Windows XP SP3.
Yesterday the office automation team migrated my PC under Windows 7 (and re-installed Office 2010) and now i got errors when i open my excel file.
I investigated and googled but nothing clear to me.
When i go to the VBA editor the statement : Worksheets.count return 14
Then i sequencially do display Worksheets(i).name with i changing from 1 to 14.
For the values 3 and 6 i get a message "runtime error 57121: Application-defined or object-defined error"
The same thing done on a Windows XP PC with same Office 2010 installed does no error at all
Any idea to help ?
Thanks bunches
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Check the references in the VBA editor for broken links.
If this doesn't help, upload the file on a online file hoster like www.dropbox.com and post the download link here. (The data in te sheets can be removed if necessary, that doesn't matter in this case.)
Andreas.