+ Reply to Thread
Results 1 to 3 of 3

Replace name of workbook in macro to active workbook

  1. #1
    Forum Contributor
    Join Date
    11-18-2014
    Location
    alex
    MS-Off Ver
    excel
    Posts
    135

    Replace name of workbook in macro to active workbook

    I want to Replace the name of that excel sheet which is selected to be active workbook and make macro from any workbook
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    Sunderland, England
    MS-Off Ver
    Excel 2007 (Home) / 2003 (Work)
    Posts
    740

    Re: Replace name of workbook in macro to active workbook

    It's a little confusing exactly what you want - are you saying you don't want to select the workbook that is highlighted and instead want the macro to run on the currently active workbook?

    If so, why not just delete the line?

  3. #3
    Forum Contributor
    Join Date
    11-18-2014
    Location
    alex
    MS-Off Ver
    excel
    Posts
    135

    Re: Replace name of workbook in macro to active workbook

    as i am beginner in macros i really dont konw what i put instead of the selected workbook to make macro run on any active workbook

+ 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. Replies: 2
    Last Post: 11-23-2015, 03:07 PM
  2. Copy active workbook to and save new workbook Macro
    By erik915 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2015, 07:27 PM
  3. Replace all data in active workbook with all data from an opened workbook
    By krisspy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-18-2014, 04:12 PM
  4. Run Macro in closed workbook and copy specific coloumn in active workbook
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2013, 03:43 AM
  5. Replies: 2
    Last Post: 06-21-2013, 08:59 PM
  6. VBA macro for hyperlink to active workbook in the active workbook path
    By Scott Taylor in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-10-2013, 05:37 AM
  7. how to run macro from active workbook, without opening source workbook??
    By etminasm in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-06-2010, 09:34 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