Codematic Excel developers logo
Codematic spreadsheet-excel development image

Rapid Application Development / Advanced Excel Development

Products for Excel
Commercial Products:
  - Classic Ribbon
  - Alt-FileSearch
  - Password Remover
Spreadsheet Quality Products
Free Products
Excel Development
Excel Development Index
Excel VBA
- VBA IDE (editor)
- VBA Training
- VBA Best Practice
- VBA Performance
- COM Performance
- VBA Security
Excel and Databases
Excel and Pivot Tables
Excel Add-ins
Worksheet Functions
Excel and xlls
Excel (in)security
Excel testing
Excel and .net
Excel External Links
Excel Developer Types
Professional Excel Development
Excel 2007
Excel 2010
Excel Development Archive
Spreadsheet Services
Spreadsheet Development
Spreadsheet Migration
Spreadsheet Maintenance
Spreadsheet Review
Spreadsheet Management
Excel User Confs
Consultant Profile
Book Reviews
Site Map

Office 2007 Migration Program Guide

(Continued from Office 2007 Migration justification)

Office 2007 Migration Program

('M' is migration day, 'M-12' means 12 months before migration)

M-12 Recruit overall program manager to begin coordinating, consulting and informing, including selling in the new features etc. Plan to move in 2 steps - 1: to Office 2007 client applications, but using the 2003 file formats, 2: to native 2007 file formats.

M-10 Recruit developers with migration experience to catalog Office dependent business systems. The number required will depend on the organisational infrastructure, perhaps just 1 or 2 people for all but the largest most complex systems.

M-8 Recruit developers with Office 2007 experience to test every important spreadsheet and system. Estimate they can check and fix approx 300 spreadsheets each (~10 per week) before migration. Changes between test date and migration date must be considered too.

M-6 Provide test Office 2007 machines to each department so they can get a feel for the new software and test some of their own work too. Consider using tools to simplify the step to 2007 such as our Classic menu Tab. Also consider what training materials and on-line resources will be available for users.

M-5 Run a pilot with a challenging department, to spread the load and also to highlight any issues that can inform the main migration program. Also recruit an Outlook migration expert around now to help with the other key Office application, can delay for several months if there are no Outlook add-ins or system interactions to test and update.

M-1 Arrange relevant Office 2007 training for all users. We strongly recommend face to face training. This should be as near to the actual migration of that users machine as possible. Perhaps even during the migration. We suggest a minimum of 1 hour on Office 2007 in general, and a further hour of Excel 2007 specific training and advice for those who use Excel a lot.

M day - or M month. Migrate 10 or 20 machines per day with trainers and devs available for deskside support and coaching to ensure all users can get going quickly. This should be a quiet period for the user so they are not under pressure to deliver key work as they are presented with new tools.

M+1 Devs and trainers still around for support and coaching, and perhaps some enhancement work. But especially for anything missed in initial testing, or breaking changes that have been introduced.

M+2 Migrate to native file format - the name change from .xls to .xlsm will break lots of user written VBA that does not use ActiveWorkbook and ThisWorkbook.

M+3 reassign team - migration should be complete. Perhaps retain key developers in recognition of just how critical spreadsheet have become in your organisation.


Excel 14 / Excel 2010

As part of the Microsoft Office Developer Advisory Council, Codematic are working with Microsoft on the developer features of the next version of Office. Office 2010 is at least as big a step as 2007, so if you are planning to skip 2007, be prepared to run something similar to the above program for the move to 2010. 2007 to 2010 should be a much more simple upgrade.

A migration to (or other office productivity suite, eg. Google Apps) would follow a similar program, but perhaps with a little more early feasibility investigation. It should also be possible to migrate just a proportion of users to OOo, whilst leaving the heavy Excel/Access/Outlook/VBA users on Microsoft Office.

We would be happy to help with any stage.


Please contact us with any questions.


Upcoming Events:

25 January 2012 - UK Excel Developer Conference - London

Products for sale:


Office 2007 FileSearch replacement logo

New information about the missing FileSearch feature in Office 2007 and details of our pragmatic solution (Current price GBP 30.00)


worksheet password remover logo

Instant Excel worksheet protection remover and password recovery (Current price GBP 15.00)

Classic Ribbon Tab

classic ribbon for office 2007 logo

Add Excel 97/2000/2002/2003 compatible menu structure to Excel 2007
(Current Price GBP 10.00)


Products coming soon:

Link Manager

(Find and control external links in Excel Workbooks)

Due by Q1 2111.

XLAnalyst Pro

(Excel VBA based spreadsheet auditing tool)

Due before the end of 2111.

This page was last reviewed on December 21, 2011

©Codematic Ltd 1999-2011