+ Reply to Thread
Results 1 to 4 of 4

Breaking links between workbooks VB

  1. #1
    Registered User
    Join Date
    09-04-2008
    Location
    Madrid, Spain
    Posts
    8

    Breaking links between workbooks VB

    Hi everybody.
    I have some workbooks with links between them.
    I know how to break those links with excel, but I have to create an application in Visual Basic which will break all those links and then save a copy of those workbooks without links.
    Could somebody write an example of that action for me please?
    Thanks a lot.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Try this
    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    09-04-2008
    Location
    Madrid, Spain
    Posts
    8
    Hi again, I'd like to try the code above, (thanks Roy) but I still cannot open any xls file...

    I always receive "The server returned an error" message... I checked the excel reference and added it again and again... Any other idea?

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Does the workbook open manually?
    Have you tried recording a macro to open the workbook?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Breaking Links Between Workbooks
    By longfisher in forum Excel General
    Replies: 6
    Last Post: 03-07-2008, 10:10 AM
  2. Problem breaking links
    By MickeyGreen in forum Excel General
    Replies: 1
    Last Post: 01-15-2008, 10:09 PM
  3. Relative links between workbooks
    By Glio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-29-2007, 12:04 PM
  4. Finding Links to Other Workbooks
    By rrucksdashel in forum Excel General
    Replies: 1
    Last Post: 03-06-2007, 07:33 PM
  5. Automatically update links to other workbooks
    By krabople in forum Excel General
    Replies: 0
    Last Post: 10-09-2006, 08:31 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1