Upgrade to windows 7/8 excel spreadsheets

Hi experts (excel 2003)

What's are the pitfalls if any one should watch out for when upgrade all vba, graphs, spreadsheets to windows 7/8...

Also are there any on line reading materials......

If I have missed any points, positive feedback welcome.
route217JuniorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Steven HarrisPresidentCommented:
Are you upgrading from Office 2003?  What version are you looking to upgrade to?

If you are moving to a Win7 or Win8 Machine, you will most likely be looking at Office 2010 or Office 2013.  If that is the case, there are some VBA changes that you will run into, and may have to update your codes to work properly as some functions/codes will be depricated.  As far as graphs are concerned, you may want to reconfigure them to use new features that are available (especially if you are moving to 2013).

If you are looking to make a move, try setting up a sandbox (virtual machine running the OS of your choice + office version of your choice) and run your own tests.
0
route217JuniorAuthor Commented:
thinkspacesolutions...

thanks for the feedback....can you expand on " as some functions/codes will be deprecated"
0
Steven HarrisPresidentCommented:
So some things you may run into are:

VBA Upgrade from 6.0 to 7.0.

Printed Chart Size: The Printed Chart Size option has been removed from the Chart tab in the Page Setup dialog box. The PageSetup.ChartSize property is hidden and has no functionality.

Chart Window: The Chart Window command has been removed from the View menu. The Chart.ShowWindow property is hidden, and has no functionality.

Change chart type for multiple charts: In Office 2003, you can select multiple charts and change the chart type for all of the selected charts simultaneously. This behavior is not available in the 2007 Microsoft Office system.

Support for Excel 4 macro (XLM) constants: Macros that were converted from XLM might have retained the XLM constants for certain parameters. These constants are no longer supported, and the documented constants should be the only constants used. Change VBA calls that use numeric values for enumerations to those that use appropriately named constants.

Data Retrieval Services (DRS) has been removed in the 2007 Office system.

Conditional Sum and Lookup Wizards have been replaced in Excel 2010.

You can read more about Object Model changes in Office versions at these links:

MSDN - New Objects, Collections, and Enumerations_Excel.Dev

New Members and Constants_Excel.Dev

Excel 2010 Object Model Changes Since Earlier Versions
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.