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

?????? ????????? ?????? ?????????
???? ???????: 286258 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

??????

???? Microsoft Excel 2002 ? Microsoft Office Excel 2003 Microsoft Office Excel 2007 ???? ???? ??? ???? ???? RTD. ???? RTD ??????? ???? ????? ???? ???? ???? (COM) Microsoft ???????? ???????? ?? ????? ???????. ?? ???? ????? ?????? RTD ????. ??? ?? ??????? ?????? RTD ????? ????, ???? ??????? ?? ?????? ?????? # VALUE.

??????? ????

???? ????? ???? ???? RealTimeData (RTD) ?????? RTD ????????? ?? ??? ?????? ??? ????????. RTD ????? ??????? ?????? ??? ??? ?????? ?? ?????? ?????? ???????? ???? ???? ????? ?? ???? ?? ?????. ???????? ????? ??????? ?????? ???? ?? ???? RTD well-written ?????? ???? ?????. ??? ?? Excel ??? ????? ?????? ????? ??? ???? RTD ??????? ???? ???????? ?? ?????? RTD. ?????? ??? ?? ???? ??? ??????? ??????.

?? ??? ?? ???????? ??????? ????? ???? RTD ????? ???? ?? ????? ?? ????? ???? ??? ?? ????? ????? ??? ?????? ?? ????? ???? ?????? ??? ????? ??????. ?? ??? ??????? ???? ?? ?????? RTD ?????? ????? ????? ????? ??? ???? ?????. ??? ???? ????? ??????? Microsoft Visual Basic for Applications (VBA) ?????? ????? ??????? ???? ???? ????? ???????? ??? ???? ??? ?????. ???? ??????? Excel ????? ????? ????? ??????? ????? ?? ?????. ??? ??????? ??? ??????? ?????? ????? ?????? ?????? ? ???? ??? ????? ????? ?????? ????? ??????. ??? ???? ??????? ???? ?? ???? Excel ?????? ??????? ??????? ????? ?? 3 ???? ?????? 4:
{1, 2, 3, 4; 10 ? 20 ? 30 ? 40; 100? 200 ? 300 ? 400}
?? ???? ?? Excel interpet ??????? ??????? ????? ?? 2 ?????? ???????? 5:
{"???"? "b" ? "c" ?? "d" ?"e"; "aa" ? "bb" ?? "cc" ? "dd" ?? "???"}
???? procedue ??????? ????? ????? ????????? ?????? ????? ?? ??? ????? ???? ??? ?????? ?? Server RTD ??? ????? ??????.

?????? ????? ???? ??????? ???????:
  1. ????? ????? Visual Basic ????? RTD ??????? ?? ????? ????? ???????? ???????:
    285339????? ????? ???? RealTimeData ?? Excel
  2. ?? ???? ????? ????? RTDFunctions ??????? ? ?????? ????? ?????? ?? ???? IRtdServer_RefreshData:
    aUpdates(1, n) = oTopic.TopicValue
    					
    ??????? ???????? ???????? ?????? ?????? ?? ???????? ????????:
    Static bToggle As Boolean
    bToggle = Not (bToggle)
    If bToggle Then
       aUpdates(1, n) = "{1,2,3;10,20,30}"
    Else
       aUpdates(1, n) = "{""a"",""b"",""c"";""d"",""e"",""f""}"
    End If
    					
  3. ????? ???? RTD ?? ????? Visual Basic.
  4. ?? Excel 2002 ?? ?? Office Excel 2003 ?? ?? Office Excel 2007 ? ??? ???? ???? ?? ???? ALT + F11 ???? Visual Basic for Applications ????.
  5. ????? ???? ????? ?????? ????? ?? Visual Basic for Applications ??????? ?? ?? ?????? ?????? ????????? ???????? ??????? ??? ?????? ??????? ????????? ????????.
    Function parseArrayData( arrayData as String ) as Variant
       parseArrayData = Evaluate( arrayData )
    End Function
    					
  6. ????? Visual Basic for Applications ???? ?????? ??? ???? Excel.
  7. ????? ?? ????? ????? ????? ???? ?? ??????? ??? ???? ?????.
  8. ???? ?????? ??????? ?? ???? ??? CTRL + SHIFT + ENTER ?????? ????? ????:
    =parseArrayData(RTD("ExcelRTD.RTDFunctions",,"AAA"))
  9. ??? ????? ??????? ????? ?? ?? ?? ????? ????? ??? ??? ????. ??? ????? ??????? ?????? ?? ?? ???? ????? ??? ??? ????.

?????

?????? ??? ???? ?? ????????? ??? ?????? RealTimeData ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft:
286259??????? ?????? ??????? RealTimeData Excel
285888????? ??????? ???? RTD Excel ?? DCOM

???????

???? ???????: 286258 - ????? ??? ??????: 27/???? ??????/1428 - ??????: 3.2
????? ???
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
????? ??????: 
kbmt kbinfo KB286258 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????286258

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

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com