Barrie, here's another one for you. Thnx in advance.
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Barrie, here's another one for you. Thnx in advance.

  1. #1
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,053
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Another annoying message box that pops up when I open my summary Workbook is "The Workbook you opened contains automatic links to info in another Workbook, etc, etc....Update (Yes) or (No).

    Is there code to click "Yes"?

    The line of code to open the subsid. w/b is "Workbook.Open Filename:="G......filename.xls", Password:="elf"

    Do I use (True) somewhere?

  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-08 09:19, Barry Katcher wrote:
    Another annoying message box that pops up when I open my summary Workbook is "The Workbook you opened contains automatic links to info in another Workbook, etc, etc....Update (Yes) or (No).

    Is there code to click "Yes"?

    The line of code to open the subsid. w/b is "Workbook.Open Filename:="G......filename.xls", Password:="elf"

    Do I use (True) somewhere?
    Nope, sorry but if you have links in the file you will be prompted to update even if you have "displayalerts" set to false.


    Regards,
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  3. #3

    Join Date
    Feb 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-08 09:19, Barry Katcher wrote:
    Another annoying message box that pops up when I open my summary Workbook is "The Workbook you opened contains automatic links to info in another Workbook, etc, etc....Update (Yes) or (No).

    Is there code to click "Yes"?

    The line of code to open the subsid. w/b is "Workbook.Open Filename:="G......filename.xls", Password:="elf"

    Do I use (True) somewhere?

    You can disable this message box for all files by going to Tools>Options>Edit and un-checking AskToUpdateAutomaticLists.

    Or if you want to disable it only before your macro opens your susid. w/b and enable it immediately thereafter, put this in your macro :-

    Application.AskToUpdateLinks = False
    Workbook.Open Filename:="G......filename.xls", Password:="elf"
    Application.AskToUpdateLinks = True

  4. #4
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-08 15:39, Escalus wrote:

    Or if you want to disable it only before your macro opens your susid. w/b and enable it immediately thereafter, put this in your macro :-

    Application.AskToUpdateLinks = False
    Workbook.Open Filename:="G......filename.xls", Password:="elf"
    Application.AskToUpdateLinks = True
    Thanks for showing me something I did not know.

    A note for Barry Katcher - this will eliminate that annoying message box, but the links will be updated without notifying the user. So....if your links are no good you will have problems.

    Regards,
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  5. #5
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,053
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Escalus, thanx a lot, worked perfectly.

    Barrie, must be the Canadian spelling.

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