Page 1 of 1

How to count OLE and DDE links in a spreasheet.

Posted: Tue Jun 12, 2007 6:42 pm
by harafeh
Is there a way to count and/or enumerate DDE and OLE links in a spreasheet?

How about counting/enumerating QueryTables?

Also, how do I get the properties and custom properties of a spreasheet (the things that show up when you right click the file in Explorer).

Thanks,

Hassan

Posted: Tue Jun 12, 2007 10:29 pm
by larsa
Hello

1. It is possible to get information about DDE and OLE links.

2. I can't remember that I have see a spreadsheet with a QueryTable, but it may be possible to get info on those as well.

3. Custom properties are not accessible.

If you are a registered user, please send me an e-mail and I will give you an example on this.


Lars Arvidsson