View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
xuanzhiyi xuanzhiyi is offline
external usenet poster
 
Posts: 1
Default VBA code disappeared when open workbook in other computer


Hi all,

I wrote a VBA project in Excel workbook in one computer(WinXP,
Execl97), there are over 10 classes and 5 modules, compiled and tested.


Later, I copy the file to another machine(Win2000, Excel2002), and
tried to open the VBA editor, all classes and modules disappeared! Then
I uninstalled Excel2002 and installed Excel2003, still codes were
missing.

Strange thing is:
1. One of my friends can open the excel file correctly in his
computer(WinXP, Excel2003).
2. I can open some other excel file's VBA code.

Is there anyone met this kind of problem before? all kinds of help are
appreciated.

-Xuan


--
xuanzhiyi
------------------------------------------------------------------------
xuanzhiyi's Profile: http://www.excelforum.com/member.php...o&userid=24863
View this thread: http://www.excelforum.com/showthread...hreadid=384064