Why Excel 2003 VBA program not working in Excel 2007?

  • Thread starter Thread starter James Heywood
  • Start date Start date
J

James Heywood

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.
 
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.
 
OWC10

Office Web Components are not part of Office 2007. MS has dropped them.

--
Jim
| 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Rect type problem 1
Disable Minimize/Maximize button for Excel 2007 Application 3
Can I declare an event in Excel 97? 2
Essbase Add-in VBA programming question 1
Why does timeGetDevCaps fail? 1
vba in excel 2007 5
2003 - MS Calendar Control VBA weirdness 4
Excel XP and WorkbookBeforeSave 2

Back
Top