+ Reply to Thread
Results 1 to 3 of 3

Run a Macro in a different workbook

  1. #1
    Registered User
    Join Date
    04-12-2019
    Location
    Dallas
    MS-Off Ver
    2016
    Posts
    64

    Run a Macro in a different workbook

    Hello,

    I am trying to open a workbook then run a macro that is assigned to that workbook, then after close the workbook. But when I do I get an error saying that the macro doesn't exist. I have disabled macros in that workbook as well. Am I missing something?

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    456

    Re: Run a Macro in a different workbook

    I dont know but something makes me think its the c.value that should be c.text

    Try that plz
    Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
    If you have been helped, maybe you could click the *

  3. #3
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Run a Macro in a different workbook

    Hi KColgrove,

    You have two errors in your Macro highlighted in red below.

    Please Login or Register  to view this content.
    Try similar code which does some error checking in the attached zip file containing Father and Son Workbooks:
    a. ExcelForumApplicationDotRunFather.xlsm
    b. ExcelForumApplicationDotRunSon.xlsm
    c. ExcelForumApplicationDotRunSon WithSpaceInName.xlsm


    Please Login or Register  to view this content.
    For a similar thread see: http://www.excelforum.com/excel-prog...ml#post4173872

    Lewis

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro VBA Excel : save and close a workbook from another workbook macro
    By estelleh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2019, 07:09 AM
  2. [SOLVED] VBA Macro pull a certain cell in closed workbook and copy/paste into current workbook
    By Hoover5896 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2017, 01:36 AM
  3. Can a Macro in a Workbook open and run a macro found in the other Workbook
    By Bobbbo in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-05-2016, 01:53 PM
  4. Personal Macro Workbook interference with other workbook macro(s)
    By Xanlithe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2015, 09:41 AM
  5. Replies: 1
    Last Post: 10-10-2015, 01:00 AM
  6. [SOLVED] VBA to open new workbook and run macro from new workbook, which closes old workbook
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-26-2014, 10:45 AM
  7. Replies: 0
    Last Post: 07-27-2011, 09:48 PM

Tags for this Thread

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