autolink between files
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: autolink between files

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi, need you helps on automatic links updates between files.
    Workbook a.xls contains sheets("b1"), Sheets("c1")
    Workbook b.xls contains sheets("b1"), Sheets("b2")
    Workbook c.xls contains sheets("c1"), Sheets("c2")

    in a.xls, sheets("b1")'s source is sheets("b1") in b.xls. Same with sheets("c1").

    These 3 workbooks are in three different networked computers. b.xls and c.xls updates frequently. How can i make a.xls automatically changes with the changes of b.xls and c.xls.

    Thx
    XJ

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Bushkill, PA
    Posts
    54
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    You can add a WorkbookBeforeClose Event in workbooks b and c to open workbook a update the data and save it

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