Results 1 to 16 of 16

Running a macro using a macro in another workbook

Threaded View

  1. #1
    Registered User
    Join Date
    04-05-2017
    Location
    Houston, TX
    MS-Off Ver
    2016
    Posts
    57

    Running a macro using a macro in another workbook

    I have a workbook that contains a large number of worksheets, one of which contains a number of button objects. Clicking one of the buttons (let's call it the "calculate button") begins a series of calculations based on numbers in that worksheet which itself reads inputs from throughout the workbook. It currently functions as I want it to without any issues.

    I have created a second workbook with which I would like to run a loop that modifies values in the original workbook and "click" the calculate button after each combination of values is entered. It would likely be easier to do all of this with one workbook but I have to keep them separate as the first workbook is for public use and the second one is just for me.

    I've created a simplified version of the scenario and attached the two files. I would like to click the button in 'Results Worksheet.xlsm" and have it then run the macro in 'Calculation Worksheet.xlsm'. Currently I keep getting the error shown below:

    macroError.JPG

    Hopefully someone has some ideas about how to fix this. Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Worksheet Macro Error When Running Workbook Macro
    By Phil Hageman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2016, 07:07 AM
  2. Running A Macro With Information From the Workbook On Opening The Workbook
    By Jaynestown in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-17-2013, 03:04 PM
  3. Replies: 2
    Last Post: 06-21-2013, 08:59 PM
  4. Running a macro with arguments from a macro in a different workbook
    By griffolo78 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-29-2012, 04:07 AM
  5. [SOLVED] macro not running in macro enable workbook
    By noclass1980 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2012, 03:30 AM
  6. Cannot find macro error when running a macro from a macro in a diffrent workbook.
    By Acrobatic82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2010, 09:22 AM
  7. Replies: 9
    Last Post: 07-25-2005, 08:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1