Automatically Update the linked document

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Automatically Update the linked document

  1. #1
    New Member
    Join Date
    Apr 2004
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Automatically Update the linked document

     
    Hi everyone,

    I m quite a beginner in VBA and I was wondering if any of you can help me.

    I v created a macro in excel to acess other excel files. when I launch my macro it then access the files to retreive the data needed.
    Those files are linked to other files and then I have the excel prompt asking if I want to update or not these links.

    Do you by any chance know a way to automatically answer yes (or no) to this and then avoiding the prompt.
    Its a quite important matter cuz I cant do any modification on the second level files (the ones open with my macro).

    Hope its clear enought :-p (sorry if not )

    Thanks

  2. #2
    MrExcel MVP Zack Barresse's Avatar
    Join Date
    Dec 2003
    Location
    Oregon, USA
    Posts
    10,693
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hiya pickache, welcome to the board!

    you must set the files (individually i believe). Tools -> Options -> Calculation (tab) -> Workbook options -> ensure 'Update remote references' & 'Save external link values' are both checked. that should do ya!
    Regards,
    Zack Barresse
    My Book on Excel Tables
    My Blog @ ExcelTables.com
    (If you would like comments in any code, please say so.)

  3. #3
    Board Regular P Sitaram's Avatar
    Join Date
    Jun 2003
    Posts
    1,974
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    If you are using the Workbooks.Open method, the UpdateLinks argument can be set to 0:

    Workbooks.Open FileName:="ABC.xls", UpdateLinks:=0
    Sitaram

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