Migration problems from Excel 93 to Windows 7/ Excel 2010

Hello everyone.

I am currently working on a project that is two-fold in purpose:

1. Maintain an application tool that uses (or operates) on the following platform: Excel 1993, Access 2003 and LotusNotes (a mid 90's version). The application tool was written with VBA 5.
   
2. Redevelop that application tool so that it operates on the following platform: Windows 7, Excel 2010, Access 2010, and Microsoft Outlook 2010. Presumeably I will be coding in VBA 6 or VBA 7.

Now the application relies extensively on writing and reading data from Excel to Access. It also allows user to manipulate the application tool by using a calander ( Calander Control Object 8.0)

I am aware that the calander control object will not work as that object has been removed from the reference library for Office 2010 products. (Am I correct on this ?) So I know this will be an issue.

Furthermore I am aware that there will be connection issues with Excel 2010 and older versions of Access.

I currently have not attempted to simply "open-up" the application tool and see if it runs in the new enviroment. I no that it will not !

I am just looking for some general advice (project management) to go about getting this done properly and promptly. I am working with approximately 6,000 lines of code.

Thanks in advance.

There's no simple answer (other than that Excel 1993 doesn't exist). You will have to open, compile and fix any glaring errors that way. Then try running it. If the program is well written, it shouldn't be that big an ordeal.

Check under Tools-References in the VB Editor - one or more of the checked references will start with 'MISSING:' and you will need to update or remove any that don't work.

Correct - the Calendar control is no longer packaged with Off2010 - see this page near the bottom.

It's another control, similar to a Calendar control, but again it is not available on all machines, so unless you can package it and distribute it, or guarantee that all the target machines have it, it may not help you.

If you have it, you'll find it by:
1. Set a reference to the Microsoft Windows Common Controls 2 (you may need to browse to the MXCOMCT2.ocx file in your System32 folder)
2. Then right-click a form, choosing 'Additional controls...' then selecting 'Microsoft Date and Time Picker Control 6.0' from the list.

Did you set the reference to 'Microsoft Windows Common Controls-2'? (note: it's not in 'common controls', only in 'Common Controls-2'

As I mentioned earlier: Tools - References, look for it in the list. If it's not there, click Browse..., navigate to your C:\Windows\System32 folder if it doesn't default to there anyway, change the file type dropdown to show .ocx files and locate the MSCOMCT2.ocx file.

if you don't have that file, then you're out of luck, I think, as I don't believe it's freely distributable. I'm a little surprised it's not there though.

It appears you can download it from Microsoft here.