Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 "sjc" wrote in message ... 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 what fields in the variant should be populated? And where is xlExcelLinks defined in my case? There's no good documentation for that. -- sjc ------------------------------------------------------------------------ sjc's Profile: http://www.excelforum.com/member.php...o&userid=32001 View this thread: http://www.excelforum.com/showthread...hreadid=517354 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Slow opening links between workbooks with links created in 2003 | Excel Discussion (Misc queries) | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) |