Trouble referencing XLA files.

[utagoalie]

I have been charged to modify a Legacy Excel application which was developed for Excel 8.0. As Excel was upgraded the application has been fairly stable. Recently my company has mandated everyone be moved to Office 2003, but there are problems and I've determined I need to have two versions of the app until all the users have been converted.

The basic distribution of the application looks like this:
We have 4 servers (one development and 3 production). Any one of which is mapped to the S:\ Drive on the users machine. And the application is launched from there.

Since I had to make a new folder for the new version to run excel 11.0 I have to change all the references to point to that new folder (I will need to delete the old folder at some point).

The trouble I am having is this. When I map to the new folder the Reference is going to the server location and not the "S:\" Drive. Thus all of my a production boxes are now going to my development box to pull down the XLA I am trying to reference.

Now this is not consistant for the most the references seem to be able to find the correct location (the server mapped to the "S:\" drive), but not all.

This project is now 2 weeks late. Please help.

Thanks,

David

 

[PHV]

but there are problems and I've determined I need to have two versions of the app
Which sort of problems have you migrating XL97 to XL2003 ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[utagoalie]

Problems have been.
1. 97 uses an vb4 like interpretor, 2003 us more VB6 like and if I make changes that work "on my box" they may not work on older machines.
2. DAO350.DLL and DAO360.DLL, without making extensive changes.. it is easier just to have two versions.

 

[PHV]

A common way is to make changes with 97 until the move to 2003 is done.
Another way is to use late binding.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886