How to count OLE and DDE links in a spreasheet.

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
harafeh
Posts: 1
Joined: Tue Jun 12, 2007 6:37 pm

How to count OLE and DDE links in a spreasheet.

Post 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
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Post 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
Post Reply