VB or computer question regarding file path differences between XP and Windows 7

[dbwiz]

We have a huge Excel based program with a ton of VB behind it and quite a few addins specially designed for the program.

Most of the users (including myself) have been on Windows XP - and before that, Windows 2000. However I am getting a new computer which is Windows 7 and of course, it has a totally different file structure (libraries, for instance). There are a lot of hard coded paths in the VB which direct certain processes to directories/pathways which have changed in the new Windows 7 file structure.

So right now, I cannot even open the file using the add in which points to the server and file path. Other than having to re-program all the VB, is there a way to redirect file paths to make the computer think it is going to (for example) C:\Program Files\Microsoft Office\Office12\Excel.exe when in reality it will be going to the new Windows Computer (x86) path?

Any thoughts/suggestions/links to material on the subject would be most appreciated.

 

[tweedle]

I don't think you're going to be able to 'trick' it enough to be able to avoid touching the code.
You can look at Environ function to pull back the path for multi-O/S compatability and shortening the re-writes.