+ Reply to Thread
Results 1 to 2 of 2

updating links in command

  1. 11-14-2007, 02:15 PM #1
    khalid79m
    khalid79m is offline
    Forum Contributor
    Join Date
    12-16-2006
    Posts
    349

    updating links in command 

    Please Login or Register  to view this content.

    how do i get it not update the links when it opens the files , any help please
    Reply With QuoteRegister To Reply
  2. 11-15-2007, 10:40 AM #2
    timbo1957
    timbo1957 is offline
    Valued Forum Contributor
    Join Date
    11-15-2007
    Location
    England
    MS-Off Ver
    Office Pro Plus 2021
    Posts
    424
    Does this help?

    Sub OpenDontUpdate()
    Workbooks.Open FileNmae:= _
    "C:\My Documents\MyFile.xls", UpdateLinks:=xlUpdateLinksNever
    End Sub
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1