+ Reply to Thread
Results 1 to 5 of 5

Opening Workbooks-combine seperate macros into one macro

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2016
    Posts
    1,092

    Opening Workbooks-combine seperate macros into one macro

    I have 2 separate macro to open files and to paste into respective sheets


    I would like to combine this into one macro so as to streamline the process


    It would be appreciated if someone could assist me



    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    377

    Re: Opening Workbooks-combine seperate macros into one macro

    If you always run the 2 macros consecutively, then you could simply "call" the second macro from the first one before the END SUB line.

  3. #3
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2016
    Posts
    1,092

    Re: Opening Workbooks-combine seperate macros into one macro

    Thanks for the advise

  4. #4
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    377

    Re: Opening Workbooks-combine seperate macros into one macro

    Alternatively, remove the last line of the first macro and the first line of the second macro:
    End Sub
    Sub Import_BR2()
    Cheers.

  5. #5
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2016
    Posts
    1,092

    Re: Opening Workbooks-combine seperate macros into one macro

    Thanks for the info

+ 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. Run Macros Between Workbooks & Combine Multiple Modules in one
    By Little Master in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2020, 12:25 PM
  2. [SOLVED] Opening workbooks and running macros in them
    By LAVA2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-19-2015, 11:54 PM
  3. [SOLVED] Help to combine two Modules from seperate workbooks to one workbook preform task
    By tcrjmom in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-30-2014, 06:14 PM
  4. [SOLVED] opening seperate excel instances macro
    By Quicksnot in forum Excel General
    Replies: 8
    Last Post: 06-27-2014, 02:50 PM
  5. [SOLVED] Macro to seperate worksheets to seperate workbooks fired from external excel file
    By optionone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-26-2012, 01:25 PM
  6. [SOLVED]:Opening workbooks and enabling user defined macros to run in those workbooks
    By vbarookie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-05-2012, 12:00 AM
  7. Saving and Opening New Workbooks with Macros
    By Footeball13 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-26-2008, 08:43 PM

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