Closed Thread
Results 1 to 2 of 2

Links Braking Problem

Hybrid View

  1. #1
    Registered User
    Join Date
    03-22-2011
    Location
    Colombo, Sri Lanka
    MS-Off Ver
    Excel 2007
    Posts
    16

    Links Braking Problem

    Hi,
    I have created one DashBoard and have to mail other recipients. Before sending mail I have to break the all links using below codes


    Dim i As Integer
    On Error Resume Next
    astrLinks = ActiveWorkbook.LinkSources(Type:=xlLinkTypeExcelLinks)
    For i = LBound(astrLinks) To UBound(astrLinks)
    ActiveWorkbook.BreakLink _
    Name:=astrLinks(i), _
    Type:=xlLinkTypeExcelLinks
    Next i

    This codes are working my other files but not working for one file. This file have lot of sheets (About 35). IS that the problem ?

    Someone know any strong coed to break links pls help me
    Thanks

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,709

    Re: Links Braking Problem

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread. Please read our forum rules and abide by them in the future. You have violated two with this post. You have duplicated a post and ignored the forum rules on posting code with code tags. Future abuse may result in infractions put to your account.

    Thread Closed.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Links Braking Problem
    By Neranjan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-24-2017, 06:56 AM
  2. Replies: 14
    Last Post: 12-27-2014, 11:43 AM
  3. Replies: 0
    Last Post: 04-05-2013, 03:00 PM
  4. Problem with Links
    By Melodieann in forum Excel General
    Replies: 0
    Last Post: 04-21-2008, 02:24 PM
  5. Replies: 0
    Last Post: 10-29-2007, 04:54 PM
  6. problem with links
    By justas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2006, 12:35 PM
  7. [SOLVED] Links Problem
    By DSE in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-24-2005, 10:06 PM

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