How to call function from another specific workbook in VBA?

by

In the workbook you want to call from (I’ll call this A), you could add a reference to the workbook that you want to call to (I’ll call this B) as follows:

  1. In workbook A, open the Microsoft Visual Basic for Applications window (for example, by pressing Alt+F11).
  2. Select Tools, References.
  3. In the References dialog that appears, choose Browse.
  4. In the Add Reference dialog that appears, choose Microsoft Excel Files from the Files of type box, select the file that you want to call (B), and choose Open.
  5. Choose OK to close the References dialog.

In file A, you should then be able to call public module-level functions in file B as if they were in file A. To resolve any naming conflicts, you can prefix calls by the “Project Name” for file B as specified in the General tab of the Project Properties dialog (accessible via the Properties command in the Microsoft Visual Basic for Applications Tools menu). For example, if the “Project Name” for file B was “VBAProjectB”, you could call function F from file A using the syntax VBAProjectB.F.

More Related Contents:

  1. delete Autofilter Field resullt using the header Name
  2. Somehow it’s not copying [closed]
  3. VBA macro that search for file in multiple subfolders
  4. So, I have 6 “master” files to then divide into 40 separate files
  5. Getting ScriptControl to work with Excel 2010 x64
  6. Application.Match gives type mismatch
  7. Count and Highlight keywords within phrases
  8. Protecting cells in Excel but allow these to be modified by VBA script
  9. Saving excel worksheet to CSV files with filename+worksheet name using VB [duplicate]
  10. Detect merged cells in VBA Excel with MergeArea
  11. Using VBA code, how to export Excel worksheets as image in Excel 2003?
  12. Parse HTML content in VBA
  13. How to add a DocumentProperty to CustomDocumentProperties in Excel?
  14. How do I name a spreadsheet automatically, by referencing two cells?
  15. Excel VBA Delete Rows
  16. VBA EXCEL To Prompt User Response to Select Folder and Return the Path as String Variable [duplicate]
  17. Should I turn .CutCopyMode back on before exiting my sub procedure?
  18. VBA: How to delete filtered rows in Excel?
  19. How to use VBA SaveAs without closing calling workbook?
  20. Removing the password from a VBA project
  21. Removing special characters VBA Excel
  22. Excel VBA Formula German/French/Italian/Russian/Dutch/Foreign Function
  23. Iterate over slicer via VBA and select a single item each time
  24. Return a range from A1 to the true last used cell
  25. How to add items to a combobox in a form in excel VBA?
  26. How can I open this VBA workbook faster?
  27. How do I avoid run-time error when a worksheet is protected in MS-Excel?
  28. Remove double quotation from write statement in vba
  29. Meaning of .Cells(.Rows.Count,”A”).End(xlUp).row
  30. VBA inheritance, analog of super

Leave a Comment