Missing VBA compiler message for wrong method name

by

As I have been explained (kudos go respectively), this is a COM feature.

By default COM assumes an interface is extensible, that is, it allows adding members at run time. If that is not the desired behaviour, one can apply the [nonextensible] attribute to the interface definition, which declares the interface only accepts methods explicitly defined in the type library.

dispinterface _Application and dispinterface _Workbook do not have this flag set in the Excel type library, dispinterface _Worksheet does.

Similarly, ADO’s dispinterface _Connection does not have [nonextensible], dispinterface _Command does.

To learn which are extensible, add a reference to TypeLib Info in the project’s References and run:

Dim t As tli.TLIApplication
Set t = New tli.TLIApplication

Dim ti As tli.TypeLibInfo
Set ti = t.TypeLibInfoFromFile("excel.exe")

Dim i As tli.InterfaceInfo
For Each i In ti.Interfaces
    If (i.AttributeMask And tli.TYPEFLAG_FNONEXTENSIBLE) <> tli.TYPEFLAG_FNONEXTENSIBLE Then
      Debug.Print i.Name
  End If
Next

You will see that almost all interfaces are extensible here, so most of them get pushed out of the debug window and you will only see the last ones. Change the <> to = to print those that are not extensible, there are much less of them.

More Related Contents:

  1. How to error handle 1004 Error with WorksheetFunction.VLookup?
  2. How can Excel VBA open file using default application
  3. How to compare two entire rows in a sheet
  4. Run same excel macro on multiple excel files
  5. how to detect whether VBA excel found something?
  6. VBA : save a file with UTF-8 without BOM
  7. Excel tab sheet names vs. Visual Basic sheet names
  8. Saving a Excel File into .txt format without quotes
  9. VBA – Range to jpg picture
  10. Fastest way to delete rows which cannot be grabbed with SpecialCells
  11. Combine multiple Excel workbooks into a single workbook
  12. Excel Macro, inserting internationally valid formula during run-time
  13. Sheet protection: UserInterFaceOnly gone
  14. VBScript – How to make program wait until process has finished?
  15. Making VBA Form TextBox accept Numbers only (including +, – and .)
  16. VBA Convert date to week number
  17. Inserting an Online Picture to Excel with VBA
  18. Change length of For loop while in the loop
  19. VBA – Run Time Error 1004 ‘Application Defined or Object Defined Error’
  20. Copy filtered data to another sheet using VBA
  21. Range.Find on a Date That is a Formula
  22. TextJoin UDF For Excel 2013
  23. Range() vs Cells() vs Range.Cells()
  24. How to get address of cell which calls a VBA Functions in a Excel sheet
  25. Add new row to excel Table (VBA)
  26. VBA Function argument list select
  27. Iterating through all the cells in Excel VBA or VSTO 2005
  28. How can I display my windows user name in excel spread sheet using macros? [closed]
  29. How to get selected value in multicolumn listbox
  30. Query my excel worksheet with VBA

Leave a Comment