Run a Macro from Another Workbook

by

This line:

Workbooks(mCalc).Application.Run ("!SummarizeMaster")

needs to be changed a little. You need to include the name of the workbook inside a single quotes, even if it looks like you are specifying the proper workbook with Workbooks(mCalc):

Workbooks(mCalc).Application.Run ("'Master Calc with Macro.xlsm'!SummarizeMaster")

You can actually just shorten it to:

Application.Run ("'Master Calc with Macro.xlsm'!SummarizeMaster")

More Related Contents:

  1. Excel Number Separation [closed]
  2. excel vba compare & copy worksheets from 2 excel files
  3. VBA Stuck after certain loop
  4. Is the . in .Range necessary when defined by .Cells?
  5. How to return a result from a VBA function
  6. Cycle through sub-folders and files in a user-specified root directory [duplicate]
  7. Convert Text to Date?
  8. Loop through each cell in a range of cells when given a Range object
  9. Non-web SQL Injection
  10. Properly Handling Errors in VBA (Excel)
  11. Password hash function for Excel VBA
  12. Is there a way to slow down a Web Scraper so it will pick up the code?
  13. Create a folder and sub folder in Excel VBA
  14. Aggregate, Collate and Transpose rows into columns
  15. Select method of Range class failed via VBA
  16. Renaming Files with Excel VBA
  17. Is there a way to import data from .csv to active excel sheet?
  18. Comparison of Dictionary, Collections and Arrays
  19. Break out of a While…Wend loop
  20. Cannot VBA write data to cells in Excel 2007/2010 within a function
  21. Sorting a dictionary by key in VBA
  22. Handle “No cells were found” error when filtered range is empty
  23. Excel: the Incredible Shrinking and Expanding Controls [closed]
  24. How to send email to multiple recipients with addresses stored in Excel?
  25. Generate Word Documents (in Excel VBA) from a series of Document Templates
  26. Using Excel VBA Macro To Capture + Save Screenshot of Specific Area In Same File
  27. Excel VBA – select multiple columns not in sequential order
  28. How to check whether certain sheets exist or not in Excel-VBA? [duplicate]
  29. Excel – Using COUNTIF/COUNTIFS across multiple sheets/same column
  30. Delete all data rows from an Excel table (apart from the first)

Leave a Comment