“Can’t find Project or Library” for standard VBA functions

by

I have seen errors on standard functions if there was a reference to a totally different library missing.

In the VBA editor launch the Compile command from the menu and then check the References dialog to see if there is anything missing and if so try to add these libraries.

In general it seems to be good practice to compile the complete VBA code and then saving the document before distribution.

More Related Contents:

  1. How to add a reference programmatically using VBA
  2. Save excel file multiple times with file names in another workbook.
  3. Read/Parse text file line by line in VBA
  4. How do I find the last column with data?
  5. Excel VBA: Answer gets “stuck”
  6. How to insert a picture into Excel at a specified cell position with VBA
  7. Save multiple sheets to .pdf
  8. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  9. filter out multiple criteria using excel vba
  10. Excel VBA autofilter all but three
  11. How can I create a calendar input in VBA Excel?
  12. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  13. Excel VBA code to copy a specific string to clipboard
  14. Merge values of column B based on common values on column A
  15. How to import a table from web page (with “div class”) to excel?
  16. Range limit conundrum
  17. Excel VBA – Range.Copy transpose paste
  18. How to determine the last Row used in VBA including blank spaces in between [duplicate]
  19. How to give a time delay of less than one second in excel vba?
  20. Changing the date format to yyyy-mm-dd
  21. Outputting Excel rows to a series of text files
  22. How to create a range from two ranges in VBA?
  23. XML parse VBA excel (function trip, & MSXML2.DOMDocument)
  24. Refreshing all the pivot tables in my excel workbook with a macro
  25. Countif With Multiple OR Criteria
  26. Vlookup to copy color of a cell
  27. every possible combination of the contents of 2 columns in excel
  28. How to delete rows in Excel based on criteria using VBA?
  29. Macro to export MS Word tables to Excel sheets
  30. How to protect Excel workbook using VBA?

Leave a Comment