asked on

Excel 20003 to 2012 Migration/conversion

Hi
I am converting some excel 2003 spreadsheets to 2010.
It would be very helpful if some one could provide me with the list of the formula changes, vba code change and other things to consider (such pivot table and charts etc) that wouldnt work/possible issue etc.

Many thanks

ASKER CERTIFIED SOLUTION

Richard Daneke

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

student225

ASKER

I am sorry I am a little dumb and not much experienced excel developer either :)
I dont understand what exactly you are referring to when you say, "VBA references use a new file, but in your existing installs, old references can be maintained" ?
Does this means that vba references use new dlls? It would be helpful if you could explain.
I am sorry if its too annoying to answer this one.

SOLUTION

redmondb

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

student225

ASKER

Brain,

Thanks for your help but that sounds horrific.
Ok about the int to long conversion.
But because I am dealing with quiet complex spreadsheets here I am sure almost 70% of them use excel menus/toolbars (one way or another).

But I am using a converter - not quiet sure at this stage if it could convert those references to the corresponding references in excel 2010? :/

SOLUTION

redmondb

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

student225

ASKER

First of all I am sorry I miss-spelled your name 'Brian'
Secondly, Its a clean install so I guess I don't have to worry about the vba reference issues.

I was actually asking about,
The Ribbon destroyed all macros which referred to Excel menus, toolbars etc.

I thought it meant that vba code (calling) of all the excel menus would be different.
Little confused. :/ -

redmondb

Hi, student225.

Sorry for scaring and confusing you! What do you mean by "calling of all the excel menus"?

Thanks,
Brian.

student225

ASKER

:) I am asking about what you said -> (3) The Ribbon destroyed all macros which referred to Excel menus, toolbars etc.

May be it would earlier for me to understand if you could give me an example of the point you mentioned.

student225

ASKER

typo - be easier*

redmondb

student225,

Sub Auto_open()
Application.CommandBars("Trident_Reports").Visible = True
End Sub

Regards,
Brian.

dlmille

Not for points - just my two cents:

Interesting. I never ran across any macros that created/used CommandBars that didn't work properly under Excel 2010. Perhaps there are some nuances I don't understand, but I find all my pre-Excel2007 commandbars in the Add-ins Menu area.

Here's an article/utility for batch conversion which should work - but you already probably have what you need:https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_8269-Convert-between-Excel-file-formats-XLS-XLSX-XLSM-with-without-macro-option.html

If you like the article and think it might be helpful, your YES vote is appreciated.

The only issues I can think of that are significant (requiring manual intervention) are library references to prior Office versions. If your developers leveraged late binding (declared variables as object, etc.) then you shouldn't have problems. Its likely they used early binding, which means the references the old macros are using need to be updated to the latest Office version.

Dave

redmondb

Dave,

"I never ran across any macros that created/used CommandBars that didn't work properly under Excel 2010."
Thanks. After the introduction of the Ribbon in 2007, its restrictions led me to abandon the use of CommandBars/Toolbars completely. In what passes for my memory, "Don't use..." must have morphed into "Can't use...".

Regards,
Brian.