Script won't run in Excel 2010
Office 2010 upgrade
Good morning!
We are in the process of upgrading all of our users to Office 2010. There are several other versions out there, from 97 to XP. We are going department by department with a "Super User" testing all the departmental applications to ensure things go smoothly. As we get closer to the end of this project we have a few hold outs. One department in particular has a spreadsheet in Excel 97 that runs a macro that we cant seem to get running in 2010. The only columns that calculate from the macro running are AN and AO. Now, I can't find it actually saved as a macro in the spreadsheet, but did find the following on a tab with other information:
/c~c33~{left}/c~c37~{left}/c~c32~{left}
/c~c35~{l 5}/c~c34~{right}/c~c31~
{if c33=0}/xq~{calc}
/ce35..g35~e36~
/ce35~f36~{calc}/cc38~h36~/rvh36~h36~
/cg35~f36~{calc}/cc38~i36~/rvi36~i36~
/cf35~f36~
{calc}/rve36..i36~e36~
{if c38=0}/xgoutput~
{if c38<>0}/cg36~e36~/ci36~h36~/cf36~g36~/cc38~i36~
{calc}/rve36..i36~e36~/xgyield~
{calc}{r 11}(an1)~/rv~~{right}(ao1)~/rv~~
{l 5}{down}/xg\a~
Any ideas how I can get this to function in Excel 2010?
Any and all help is greatly appreciated!
Thank you
Stephanie
If you could explain what
If you could explain what this piece of code does, probably that would help; I might write an Excel VBA code as well to provide you the same functionality as this code.
Thank you! At this point they
Thank you!
At this point they have decided to have them access the 97 spreadsheet via Citrix so we can get them upgraded as soon as possible. They only use this spreadsheet at year end.
I appreciate the assistance!