-
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?
-
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