Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
LinkSources(xlOLElinks) address
I have realtime stock quotes updating a spread sheet via DDE. When
use the following code, I cannot determine the cell address of the cel which has been updated. Sub DDEUpdate() Dim colTimeStamp As String colTimeStamp = "I" varr = ThisWorkbook.LinkSources(xlOLELinks) For i = LBound(varr, 1) To UBound(varr, 1) ThisWorkbook.SetLinkOnData Name:=varr(i) Procedu="'MyLinkProcTest " & i & "'" Next End Sub The varr array seems to put the links in a different order than the are on the sheet. Your help would greatly be appreciated. Joh -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The address of this site is not valid. Check the address and try | Excel Discussion (Misc queries) | |||
How do I avoid excel change absolute address to relative address | Excel Discussion (Misc queries) | |||
long address list, name-address-city, listed vertically, how do y. | Excel Discussion (Misc queries) | |||
How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) | |||
LINKING Address cells from an EXCEL spreadsheet to fill MapQuest Address Info | Excel Programming |