Lost ActiveX controls; Lost Visual Basic project.

[Asa Monsey]

I am getting an error when moving an excel spreadsheet with VBA coding and command buttons from a workstation running Excel XP SP2 to a term server running Excel XP SP3

"Error accessing file. Network connection may have been lost."

followed by the enable macros dialog box. Then I get another error saying:

"Errors were detected in 'XXXX.xls,' but Microsoft Excel was able to open the file by making repairs listed below. Save the file to make these repairs permanent

Lost Visual Basic project.
Lost ActiveX controls.

The vba code has disappeared and the command buttons have been converted to pictures. There is a KB article (http://support.microsoft.com/default.aspx?kbid=836031) that refers to this relating to adding a digital signature, but that does on apply to this scenario, and regardless the KB article says that has been fixed.

I found an article in an Access discussion board that mentioned VB6E.DLL. I checked the versions between the workstation where everything works, and the server, and they are different. I have not been able to figure out why this is happening, and any help would be appreciated

Thanks
Asa Monsey

 

[Wei-Dong XU [MSFT]]

Hi Asa,

I'd suggest you can check the excel workbook to see whether the VBA codes for the commandbutton exist in the same workbook or locate in one xla
file placed in another directory. Generally speaking, the VBA codes may be from one xla file. When you copy the workbook from the workstation to
the team server, the xla is not copied together. Then when you open the workbook in server-side. Excel can't find the xla file, then report the error.

I'd suggest you can use the Filemon utility to capture the loaded files in the Excel process of the workstation and the team server. Then compare the
tow logs to see whether there is any file lost in the server side so that we can know which file should be copied to the server. The filemon is
available from the link:
http://www.sysinternals.com/ntw2k/source/filemon.shtml

In FileMon, please press "CTRL+L" to set the "Excel.exe" in the include textbox to only capture the files loaded by Excel. Then open the workbook and
then save the log. After that, compare the two log files to find whether there is any different file loaded in Workstation, not in the server.

Please feel free to let me know if you have any further questions.

Best Regards,
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.