Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why Excel 2003 VBA program not working in Excel 2007?
Dear my colleagues,
I have a Excel 2003 VBA program. I don't know why it doesn't work in Excel 2007. It always gave out a message "Can't find project or library" and highlighted the function: Private Sub ResultCol_BeforeContextMenu(ByVal x As Long, ByVal y As Long, ByVal Menu As OWC10.ByRef, ByVal Cancel As OWC10.ByRef) End Sub Could you tell me how to solve this problem? Thanks a lot. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why Excel 2003 VBA program not working in Excel 2007?
just a guess, but in vb, click tools/references and look for any listed as
missing. check the boxes and see if it will run. -- Gary "James Heywood" <James wrote in message ... Dear my colleagues, I have a Excel 2003 VBA program. I don't know why it doesn't work in Excel 2007. It always gave out a message "Can't find project or library" and highlighted the function: Private Sub ResultCol_BeforeContextMenu(ByVal x As Long, ByVal y As Long, ByVal Menu As OWC10.ByRef, ByVal Cancel As OWC10.ByRef) End Sub Could you tell me how to solve this problem? Thanks a lot. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why Excel 2003 VBA program not working in Excel 2007?
OWC10
Office Web Components are not part of Office 2007. MS has dropped them. -- Jim "James Heywood" <James wrote in message ... | Dear my colleagues, | I have a Excel 2003 VBA program. I don't know why it doesn't work in Excel | 2007. | It always gave out a message "Can't find project or library" and highlighted | the function: | Private Sub ResultCol_BeforeContextMenu(ByVal x As Long, ByVal y As Long, | ByVal Menu As OWC10.ByRef, ByVal Cancel As OWC10.ByRef) | End Sub | Could you tell me how to solve this problem? | Thanks a lot. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple Excel 2003 macro not working in Excel 2007 | Excel Programming | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
Pivot in excel 2003 is not working when open in excel 2007 | Excel Worksheet Functions | |||
Can I add in program in excel 2007 like in excel 2003 | Excel Discussion (Misc queries) | |||
working with excel and other program | Excel Discussion (Misc queries) |