Results 1 to 2 of 2

Thread: VBA Links

  1. Nov 25th, 2000, 02:18 AM #1
    icemanmt78
    icemanmt78 is offline

    Thread Starter
    Addicted Member icemanmt78's Avatar
    Join Date
    May 2000
    Posts
    142

    Unhappy

    I have a problem checking for links in Excel VBA. I am using the link sources property and i want to check both XL and OLE links.

    At present i can only check for one type of link as follows

    mark = activeworkbook.linksources(xlExcellinks)

    How do i check for any sort of links????
    I have tried:
    mark = activeworkbook.linksources
    but this does not work either.

    Help?
    Reply With Quote Reply With Quote
  2. Nov 25th, 2000, 03:17 AM #2
    TheOnly
    TheOnly is offline
    Addicted Member
    Join Date
    Oct 2000
    Location
    Vienna/Austria
    Posts
    132
    Hi icemanmt78 !!!

    I have also try this, whith no success. In my opinion the
    Excel help is missleading in this case.
    The only solution for me is to make loops for all link types.

    -cu TheOnly
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width