VB: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)

First of all, try to run Visual Studio with the /ResetUserData command line argument. Read more about that in the Error “Unable to cast COM object…” when exporting to Microsoft Excel from Team Explorer 2008 article.

Obviously you are trying to connect to a wrong Excel version. Looks like you have some extra windows registry keys left after uninstalling an old version of Office or vice versa. Anyway, take a look at the How to solve “Unable to cast COM object of type Microsoft.Office.Interop.Excel.ApplicationClass’ to interface type ‘Microsoft.Office.Interop.Excel._Application’” blog post which describes exactly the same issue. Basically you need to find a wrong entry in the windows registry and then delete it.

BTW When you add a new COM reference to the project a missed PIA is generated automatically (if it doesn’t exist any longer). So, that is a possible way to go. Also you may try to embed interop types into your own assembly like the following screenshot shows:

Related Posts:

  1. MS Excel Scatterplot converts Months to Numbers
  2. Excel to Google Sheets – Error: Formula parse error
  3. Swap x and y axis without manually swapping values
  4. Excel: Calculate the frequency of a particular month in a column of date cells
  5. Object Required Error in excel VBA
  6. Insert picture into Excel cell
  7. What is a correct MIME type for .docx, .pptx, etc.?
  8. Is there Infinity in Spreadsheets?
  9. Declaring variables in Excel Cells
  10. What are .NumberFormat Options In Excel VBA?
  11. Better way to find last used row
  12. VBA, if a string contains a certain letter
  13. How to loop in excel without VBA or macros?
  14. Excel VBA Macro: User Defined Type Not Defined
  15. What is correct content-type for excel files?
  16. How do I get countifs to select all non-blank cells in Excel?
  17. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  18. Excel – SUMIFS for multiple columns
  19. Workaround for “Formula omits adjacent cells”
  20. Select method of Range class failed via VBA
  21. Does VBA contain a comment block syntax?
  22. Why does “Paste Method of Worksheet class failed” occasionally occur?
  23. check if a file is open in Python
  24. How to return a result from a VBA function
  25. Select all the cells below current cell in excel
  26. How to clear memory to prevent “out of memory error” in excel vba?
  27. Use VBA to Clear Immediate Window?
  28. Excel: Can I create a Conditional Formula based on the Color of a Cell?
  29. VBA: Else without If Error
  30. Recommended IDE for VBA
  31. ByRef argument type mismatch in Excel VBA
  32. How do I open space-delimited file in Microsoft Excel?
  33. VBA: Convert Text to Number
  34. VBA Error: “Compile error: Expected End Sub”
  35. Using SUBSTITUTE with wildcard characters
  36. Change default ‘delimiters’ in excel
  37. Error: “Could Not Find Installable ISAM”
  38. Adding a newline character within a cell (CSV)
  39. Loop without Do error
  40. Row count where data exists
  41. (Excel) Conditional Formatting based on Adjacent Cell Value
  42. Test or check if sheet exists
  43. How to detect if user select cancel InputBox VBA Excel
  44. Shortcut to Apply a Formula to an Entire Column in Excel
  45. macro run-time error ‘9’: subscript out of range
  46. How to label scatterplot points by name?
  47. Why does my VBA code throw an “Invalid outside procedure” error?
  48. Excel Solver Password: what is it and where can it be acquired/bought?
  49. Compile error: Next without For || VBA
  50. Is there a way to crack the password on an Excel VBA Project?
  51. Substring in excel
  52. IndexError: too many indices for array
  53. What does <> mean?
  54. HTML encoding issues – “” character showing up instead of ” “
  55. How do I get my C# program to sleep for 50 msec?
  56. Converting string to byte array in C#
  57. Looking for a clear description of Excel’s .xlsx XML format
  58. Invalid column count in CSV input on line 1 Error
  59. Exception of type ‘System.OutOfMemoryException’ was thrown.
  60. Windows Application has stopped working :: Event Name CLR20r3
  61. Why is Dictionary preferred over Hashtable in C#?
  62. excel IF formula Error, “You’ve entered too many arguments”
  63. Export html table data to Excel using JavaScript / JQuery is not working properly in chrome browser
  64. How to fix file format and extension don’t match?
  65. How can I open an Excel file in Python?
  66. ValueError: cannot index with vector containing NA / NaN values
  67. How can I import an Excel file into SQL Server?
  68. Sleep function Visual Basic
  69. lists and arrays in VBA
  70. To get a random integer value between 1 and N (inclusive) you can use the following.
  71. How to run a SQL query on an Excel table?
  72. What is the function of FormulaR1C1?
  73. What is the C# version of VB.net’s InputDialog?
  74. VBA Excel – Insert row below with same format including borders and frames
  75. ImportError: No module named win32com.client
  76. Cannot access a disposed object – How to fix?
  77. Cannot access a disposed object – How to fix?
  78. How to use \n new line in VB msgbox() …?
  79. Syntax error on token(s), misplaced construct(s)
  80. VB6 to VB.net conversion
  81. VBA for Cross Products in Excel
  82. Excel VBA: Can’t get a match, error “Unable to get the Match property of the WorksheetFunction class”
  83. How do I convert from a string to an integer in Visual Basic?
  84. Reference to a non-shared member requires an object reference occurs when calling public sub
  85. Error -1072896636 “DTD Prohibited” when opening xml file in Excel, what do I do?
  86. Python: Where does if-endif-statement end?
  87. How to install Date Picker form control in Excel 2016
  88. How to fill color in a cell in VBA?
  89. How to enable assembly bind failure logging (Fusion) in .NET
  90. Is there a coalesce-like function in Excel?
  91. Refreshing all the pivot tables in my excel workbook with a macro
  92. Converting Excel Column with To SSRS (inch or pt)
  93. When should I use a List vs a LinkedList
  94. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  95. VBA Excel “Compile error: Object Required”
  96. Choosing paper size (NOT DEFAULT sizes) in excel vba
  97. “Unable to get the VLookup property of the WorksheetFunction Class” error [duplicate]
  98. Using Excel VBA to run SQL query
  99. VBA: Getting run-time 1004: Method ‘Range’ of object ‘_Worksheet’ failed when using cells
  100. Cannot run the macro… the macro may not be available in this workbook

Leave a Comment