| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Version compability of classes?
I have a spreadsheet that has a class that uses the withEvents keyword.
It seems that if I compile & save the file in Excel 2000, it will work in Excel XP, but If I compile & save the file in Excel XP then the events never get called when the spreadsheet is used in Excel 2000. It seems that the code generated in XP is not compatible with 2000. Has anyone else seen this? -- o_o_o_o /| ,[_____], |ŻŻŻL --O|||||||O- ()_)Ż()_) ŻŻŻŻŻ )_) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Version compability of classes?
A WithEvents class in general should work fine in Excel 2000. What object's events are you trying to sink with your class? -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "aGraham" wrote in message ... I have a spreadsheet that has a class that uses the withEvents keyword. It seems that if I compile & save the file in Excel 2000, it will work in Excel XP, but If I compile & save the file in Excel XP then the events never get called when the spreadsheet is used in Excel 2000. It seems that the code generated in XP is not compatible with 2000. Has anyone else seen this? -- o_o_o_o /| ,[_____], |ŻŻŻL --O|||||||O- ()_)Ż()_) ŻŻŻŻŻ )_) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Version compability of classes?
sorry took so long to respond, forgot to check this group....
They work fine as long as the file was saved in excel 2000, as soon as the file is saved by XP the events do not get handled in 2000. In article , "Rob Bovey" wrote: A WithEvents class in general should work fine in Excel 2000. What object's events are you trying to sink with your class? -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "aGraham" wrote in message ... I have a spreadsheet that has a class that uses the withEvents keyword. It seems that if I compile & save the file in Excel 2000, it will work in Excel XP, but If I compile & save the file in Excel XP then the events never get called when the spreadsheet is used in Excel 2000. It seems that the code generated in XP is not compatible with 2000. Has anyone else seen this? -- o_o_o_o /| ,[_____], |ŻŻŻL --O|||||||O- ()_)Ż()_) ŻŻŻŻŻ )_) -- o_o_o_o /| ,[_____], |ŻŻŻL --O|||||||O- ()_)Ż()_) ŻŻŻŻŻ )_) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Version compability of classes?
"aGraham" wrote in message
... sorry took so long to respond, forgot to check this group.... They work fine as long as the file was saved in excel 2000, as soon as the file is saved by XP the events do not get handled in 2000. I can't reproduce this problem with any Excel objects using the computers on my network. What is the object whose events you are trying to trap? -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "aGraham" wrote in message ... sorry took so long to respond, forgot to check this group.... They work fine as long as the file was saved in excel 2000, as soon as the file is saved by XP the events do not get handled in 2000. In article , "Rob Bovey" wrote: A WithEvents class in general should work fine in Excel 2000. What object's events are you trying to sink with your class? -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "aGraham" wrote in message ... I have a spreadsheet that has a class that uses the withEvents keyword. It seems that if I compile & save the file in Excel 2000, it will work in Excel XP, but If I compile & save the file in Excel XP then the events never get called when the spreadsheet is used in Excel 2000. It seems that the code generated in XP is not compatible with 2000. Has anyone else seen this? -- o_o_o_o /| ,[_____], |ŻŻŻL --O|||||||O- ()_)Ż()_) ŻŻŻŻŻ )_) -- o_o_o_o /| ,[_____], |ŻŻŻL --O|||||||O- ()_)Ż()_) ŻŻŻŻŻ )_) |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Version compability of classes?
It is the App_WorkbookOpen event. I will try to make a smaller test
case that I can send you if I get time. In article , "Rob Bovey" wrote: "aGraham" wrote in message ... sorry took so long to respond, forgot to check this group.... They work fine as long as the file was saved in excel 2000, as soon as the file is saved by XP the events do not get handled in 2000. I can't reproduce this problem with any Excel objects using the computers on my network. What is the object whose events you are trying to trap? -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "aGraham" wrote in message ... sorry took so long to respond, forgot to check this group.... They work fine as long as the file was saved in excel 2000, as soon as the file is saved by XP the events do not get handled in 2000. In article , "Rob Bovey" wrote: A WithEvents class in general should work fine in Excel 2000. What object's events are you trying to sink with your class? -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "aGraham" wrote in message ... I have a spreadsheet that has a class that uses the withEvents keyword. It seems that if I compile & save the file in Excel 2000, it will work in Excel XP, but If I compile & save the file in Excel XP then the events never get called when the spreadsheet is used in Excel 2000. It seems that the code generated in XP is not compatible with 2000. Has anyone else seen this? -- o_o_o_o /| ,[_____], |ŻŻŻL --O|||||||O- ()_)Ż()_) ŻŻŻŻŻ )_) -- o_o_o_o /| ,[_____], |ŻŻŻL --O|||||||O- ()_)Ż()_) ŻŻŻŻŻ )_) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find cell that has compability issues | Excel Discussion (Misc queries) | |||
| Excel Classes | Excel Discussion (Misc queries) | |||
| data classes | Excel Discussion (Misc queries) | |||
| Using classes defined in an add-in | Excel Programming | |||
| Excel 2000-2002 compability | Excel Programming | |||
Hybrid Mode
