Call another Workbook and make it work!?
Call another Workbook and make it work!?
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Call another Workbook and make it work!?

  1. #1
    Board Regular HunterN's Avatar
    Join Date
    Mar 2002
    Location
    Maryland
    Posts
    479
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a workbook that has a control button
    that opens another workbook. This other
    workbook has forms and macro code behind it
    that works when I open the workbook by itself.

    This is my problem: I want the second workbook only opened when the command button is selected from the first workbook. The command button does open the second workbook but, it does not allow me to select (or move) within this workbook. It sits at the current activecell and makes all changes to that one cell. I though maybe it was the Protection issue, but I've tried that and it doesn't fix anything. Any suggestions????

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The following code will open a workbook:

    Workbooks.Open "NameofYourWorkbook.XLS"


    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Raleigh, NC USA
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Check out the last few replies to the topic "Macro works in native excel but not via automation"

    Should work for you also.

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
  •  

 

 
DMCA.com