Ole Links (C++)

[sjc]

I don't know if this is the proper forum for asking a C++ Excel
programming question, but here goes.

My application has an _Application, _Workbook, and Workbooks classes
all derived from COleDispatchDriver that were added from Excel's type
library. The two methods I'm interested in using right now are:

void ChangeLink(LPCTSTR Name, LPCTSTR NewName, long Type);
VARIANT LinkSources(const VARIANT& Type);

That are declared in the _Workbook class. I'd like to iterate through
all the client links Excel is holding onto and change the filename
they're pointing to, however I can't find any good documentation or
samples on how to use these or any other methods from a C++
perspective. Could anyone direct me to such documentation or provide
some samples?

 

[NickHK]

sjc,
The Excel VBA Help has examples of both of these, in VB of course, but
should be relatively straight forward to translate into C++ for someone who
knows that beast.

NickHK

 

[sjc]

I've seen samples in VB, like this:


Code
-------------------

Sub ListLinks()
Dim aLinks As Variant
aLinks = ActiveWorkbook.LinkSources(xlExcelLinks)
If Not IsEmpty(aLinks) Then
Sheets.Add
For i = 1 To UBound(aLinks)
Cells(i, 1).Value = aLinks(i)
Next i
End If
End Sub

-------------------


In C++, the parameter to LinkSources is a "const VARIANT&". Well wha
fields in the variant should be populated? And where is xlExcelLink
defined in my case? There's no good documentation for that

 

[NickHK]

sjc,
LinkSources returns an array of strings or Empty.
xlExcelLinks is defined in Excel as a member of the XlLink enum:
Enum XlLink
xlExcelLinks = 1
xlOLELinks = 2
xlPublishers = 5
xlSubscribers = 6
End Enum

NickHK