Excel 2002 and Active X controls (W2K)

[cerulean]

An engineer here at work is trying to use VB with a spreadsheet and whenever he opens the file, a message pops up (with a title of Microsoft Visual Basic) and states "Error Accessing File. Network Connection may have been lost." After he clicks ok, another box comes up and states that "Errors were detected in *filename.xls* but Microsoft was able to open the file by making the repairs listed below. Save the file to make these repairs permanent. Lost Visual Basic Project. Lost Active X Controls." It saves this info to a log file.

The file is located on the hard drive, not on our network. He's running W2K sp2 (I've reloaded sp2) with Office XP sp1. He sent the file to me and I got the same thing. I'm not sure why it would tell me that the network connection may have been lost. I looked through Technet and the forums here as much as I could, but I couldn't find anything that matched this exactly. I found one article that said VBA might not be installed, but Access 2002 is installed, so VBA has to be installed as well. Any ideas will be appreciated. Thanks,

Eric

[cerulean]

Come on, there has to be a VB guru out there... I have found out one thing: The user had a network installation of Office 97 on his old computer. His new one has Office XP installed locally.

When I got another computer with Office XP and updated a reference to MSForms20.dll within the VB editor in that file, it worked. I went back to his computer and tried to do the same thing, but it didn't work. I found the network path within the file using UltraEdit.

I don't want to have to hard code everything for every file like this on his computer. Does anyone know of a way to run a global change to all of his Excel files that will wipe out the old network path and put in the new local path? Thanks for any advice.

[reghakr]

I'm no VB guru, but...

Maybe you'll need to start over. It's common knowledge that many leftovers remain after a uninstall of Office.

<a target="_blank" href=http://support.microsoft.com/default.aspx?scid=kb;EN-US;q176823&FinishURL=%2Fdownloads%2Frelease%2Easp%3FReleaseID %3D38698%26area%3Dsearch%26ordinal%3D3%26redirect% 3Dno>OFF97: Utility to Completely Remove Remaining Office 97 Files and Registry Entries</a>

Then you'll ned to do a searchg in the registry for any remnants pointing to the network location.

reghakr

[cerulean]

Thank you very much for the reply. I neglected to mention that the user has a new computer, so there was no uninstallation of Office.

I think at this point, he can just copy the VB code from his old Excel files on his old computer and create new ones. I have put a lot of time in it and unfortunately, I'm not an expert with Office, VB or the registry. Thanks again for the suggestion.

Eric