Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Macro Code for Workbook the macro resides in (Excel 2002)

    What would the code be to select the workbook that contains the macro that is being called... to explain a bit more in detail, my macro is in workbook A. This macro (located in workbook A) goes out and opens 4 other workbooks. I'm in need of the code that would "select" the workbook that the macro is located in... activeworkbook.activate doesn't seem to work... any ideas? Keep in mind that my file name changes, so I can't just put the actual name of the workbook.
    Thanks!
    Lana

  2. #2
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Macro Code for Workbook the macro resides in (Excel 2002)

    Ureka... I figured it out.... ThisWorkbook.Activate
    Thanks to all that were going to reply!!
    Lana

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Macro Code for Workbook the macro resides in (Excel 2002)

    Try

    ThisWorkbook.Activate

Posting Permissions

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