????? ????? ???????? ?????? RTD ?? Excel

???? ???????: 289150 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ??????? ???? ?????? RealTimeData (RTD). ???? Microsoft Office Excel ???? ???? ??? RealTimeData (RTD). ????? ??? ??????? ??????? ???? ????? ???? ???? ???? (COM) ???????? ???????? ?? ????? ???????.

????? ???? ???? ?????? ???? ????? ?????? ??? ??????? ?? ????? ??????? ??? ???? ??????? ???????? ??????? ?? ???????? ??????? ????? ???? ??????? ???? ???? ????? RTD. ?? ????????? ??????? ?? Excel ??? ??????? ????? ???????? ?????? (DDE) ???? ?????. ?????? RTD ????? ??? ????? COM ??? ???? ????? ?? ????? "?" ?????? "?" ????????. ????? RTD ??? ???? ???? RTD ?????? ?????? ????? ??????? ??? Excel. ????? ?? ????????? ??? ????? ????? ???? RTD ???? ??? "???????".

?????? RTD ???????? ???????? ?? ???? RTD ????????? ?? ??????. ??? ????? ????? ???? ????? ???? ???????? ???? ????? ?? ?????? ?????? ??????. ????? ?????? ??? ???? Excel ?????? ??? ?????. ??? relieves ?????? ?? ?????? ??? ????? ?? ??? ??? Excel ????? ???? ?????????. ?????? RTD ????? ??????? ?????? ?? ??? regard ??? ????? ???? ??????? ??? ????? ??? ????? ???? ???? ?????.

??? ????? ?? ???? ?????? RTD ?????? ?????? ??? ???? ? ??? ??? ??? ???????? ????? ??????? ?? ????? ??? ?? ?????? ????. ??? ???? ??????? ??? ??? ?????? ?????? RTD ?? ???? ??? ??? ?????? ????? ??? ??????? ?????????? ??? ??? ?????? ??? ???? ????? ?????? ???? RTD ???? ???? ?????? ????? ??????????.

???? ??????

?????? ?????? RTD ???? ?????? ??????
= RTD(RealTimeServerProgID,ServerName,Topic1,[Topic2],...)
??? ?????? ?????? ??? ???:
  • RealTimeServerProgID

    ????? ???? "???? ????????" ?????? RTD ???? ??? ?????? ??????. ??? ?? ????? ????? ???????? COM ???? ?? ??????? ?????? ????? ?????? ????? ?? ?????? ??????? RegSvr32. RealTimeServerProgID ????? ??????.
  • ??? ??????

    ????? ???? ???? ??? ?????? ??? ???? ?????? RTD ?????. ?? ??? ????? ???? RTD ?????? ServerName ??? ?? ???? ????? ????? ("") ?? ?? ?????.
  • Topic1 [Topic2]...

    ????? ????? ??? ??????? ????????. ????? ??????? ?? ???? ??? ???????? 28 ??? ????? ?? ??? ????? ????? ???? ???.

??????? RTD

????? ?????? RTD ?? ???? ???????? ??????? ??????? ?? ???? ???? ???? ???????? ????? ?? ???? ???????? ?? ??? races ?????????. ????? ?? ?????? ????? ??? ????? ???????? ?????? (DLL) ??????? RaceReport.dll ?????? ??? ???? ????????? ????? ????????? ? ????? ????? ??? ????? ?????? ?? COM ?????? ????? ??????? ????? ??. ?? ???? ??????? ?????? ?????? RTD ????????? ?? ??? ?????? ??? ???
=RTD("MyRTDServerProdID","MyServer","RaceNum","RunnerID","StatType")
??? ???? ???????? RaceNum ? RunnerID StatType ?????? ??????? runner ??????? ????? ???? ???????? ?????????? ????? ?????? ??? ???????.

??? ?? ???????? ?? ????? ???? ???? ?????? ??????? ???
=RTD("ExcelRTD.RaceReport","","2","16","Time")
??????? ????? ??????? ?????? ??? runner 16 ?? ?????? ??? 2. ??? ????? ??? ???????? ???? ????? ???????? ???????? ?????? ???? ???? COM. ??? ???? ??????? ?? ?????? ???????? ?????? ????? ?????? ?????? ?? ???? ??????? ?????? RTD ???????:
=RTD("ExcelRTD.RaceReport","","3","25","Position")
?? ??? ??????? ???? ???????? ???? ?? ??????? ??? ?????? ?????? runner ????? 25 ?? ?????? ??? 3.

???? ??????? ??? ???? ???? ??????? ???? ????? ???? ?????? ??????? ?????? ?????? ?? ??? ?????? ????? ???? ???? ????????.

wrappers ?????? ?????????

???? ??????? ?????? RTD ???? ??????? ??????? ?? ??? ???????? (UDFs) ?? Microsoft Visual Basic for Applications. ???? ??? ?? wrappers ???? RTD. ???? ?? ???? ??? ??????? ?????? ?? shielding ?????????? ?? ??? ?????? RTD ProgID ???????? ??? ????? ??????? ??? ??? ???????? ?????? ?????.

??? ???? ??????? ?? ????????? ?????? ???????? ???? ????? ?????? ?????: GetTime(RunnerID) ? GetPosition(RunnerID). ????? ??? ??????? ???? ?? ???????? ?? ?????? ?????? ?? ??? ??? ????? ??????. ???? ??? ???????? ?????? ????? ????? runner ????? ???????? ??????? ??? runner ?? ????? ??????? ??????? ? ??? ???????.

??????

??? RTD ????? ???????? ??? ???? Excel ? ????? ????? ??????? ??? ??? Excel ?? ??? ?????? ??????. ??? ????? ???????? ??????? ???? ?? ??????? ?????? ?? ??? ??????? ????? ??????? ??? ????? ???? ????.

??????

??? ?? ???? ?????? RTD ????? ??????. ??? ?? ??? ??????? ?????? ???? RTD ? ?? ?? ??? ????? ?????? ?? ???? ??? # N/A ?? ??????? ?????? ??? ???? RTD.

?? Microsoft Office Excel 2007? ????? ?????? ??????? ?????? ???????? ???? ???????. ??? ???? ?????? ????? ?? ??? ?? ????? ??????? "???? ???????" ?? ???? ?????? ?????? Excel.

?????? ??? Microsoft Office Excel 2003 ??? Microsoft Excel 2002 ???? ??? ????? ?????? ??????? ?? ???? ??? ??????? ???? ??????? ?? Excel.
???? ??? ?????? | ????? ???????

?????

?????? ??? ???? ?? ????????? ??? ???? RTD ? Excel ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
286259
(http://support.microsoft.com/kb/286259/ )
??????? ?????? ??????? RealTimeData Excel
?????? ??? ???? ?? ????????? ??? ????? ???? RTD ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
285339
(http://support.microsoft.com/kb/285339/ )
????? ????? ???? RealTimeData ?? Excel
???? ??? ?????? | ????? ???????

???????

???? ???????: 289150 - ????? ??? ??????: 02/???? ?????/1428 - ??????: 2.1
????? ???
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
????? ??????: 
kbmt kbfunctions kbformula kbexpertisebeginner kbhowtomaster KB289150 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????289150
(http://support.microsoft.com/kb/289150/en-us/ )
???? ??? ?????? | ????? ???????

????? ???????

 
???? ??? ?????????? ??? ??????