Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 3 of 3 FirstFirst 123
Results 21 to 25 of 25

Thread: Tweaking existing VBA code...

  1. #21
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Christy


    I suspected as much! I think you will find that there is no Workbook open by the name of
    "Main Directory.xls" or you have miss-spelt the name?





    Workbooks("Main Directory.xls").Activate



  2. #22
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Nope, the name's spelled correctly...but that is one of the files that it should open on its own first.

    It automatically opens that file and one other, then prompts for the third. I just want it to switch back to that one after it opens the one the user selects to open, and before it closes the workbook with the macro. As it is, it will stay on the last book opened. I use the main directory.xls first.

    It's no big deal if I can't get this to work, I was just trying to simplify it a little further.

    Thanks again,


    Kristy

  3. #23
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Woohoo! I managed to get it to work!

    Trial and error is a pain in the butt!

    Thanks,
    _________________
    Kristy

    "There are two means of refuge from the miseries of life: music and cats." - Albert Schweitzer

    [ This Message was edited by: Von Pookie on 2002-04-04 13:25 ]

  4. #24
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Kristy


    What was the problem?

  5. #25
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I honestly don't know. I just started moving things around.
    Kristy

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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