• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

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.
  • 2
1 Solution
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.
route217Author Commented:

thanks for the feedback....can you expand on " as some functions/codes will be deprecated"
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now