Anonymous
Anonymous asked in 電腦與網際網路軟體 · 1 decade ago

什麼是DDE,怎應用在下單?

在下會excel也會vba的控制敘述部分,但藉由dde載資料則全無概念

爬過很多文實在講不到重點

有沒詳細的說明和範例語法?

2 Answers

Rating
  • En-Zen
    Lv 7
    1 decade ago
    Favorite Answer

    DDE是軟體內含的程式,提供軟體間的資訊交換。例如股市的即時資料連到Excel。下列說明可自Excel說明查到。

    Create a link using Dynamic Data Exchange (DDE)

    Security Dynamic data exchange (DDE) is an older technology that is not secure. If possible, use a more secure alternative to DDE, such as object linking and embedding (OLE).

    The program that contains the data you want to link to must support Dynamic Data Exchange (DDE). To determine whether your program supports DDE or to learn the DDE name and topic information for the program, contact the software vendor of the program. For more information about DDE, see the Microsoft Office 2003 Resource Kit.

    How to obtain the Office 2003 Resource Kit

    The Office 2003 Resource Kit is the definitive guide to installing, configuring, and supporting Microsoft Office in your organization. Designed for system administrators, consultants, and power users, this guide offers complete coverage whether you're running Microsoft Office on Windows or the Macintosh.

    You can obtain the Office 2003 Resource Kit wherever computer books are sold, or order direct from Microsoft Press, or online at the Office 2003 Resource Kit Web site.

    To locate your nearest source for Microsoft Press products worldwide, visit the Microsoft Press Web site.

    Select the cell you want to link from.

    Enter a formula using the following syntax: application name; document name or topic; and cell range, value, field, or data that's referred to.

    The following example shows the parts of a remote reference formula and the required separator characters:

    A pipe character (|) separates the program name from the document or topic name. An exclamation point (!) separates the document or topic name from the cell range, value, field, or data referred to.

    Press ENTER.

    Note If the name of the application, document, topic, or data item contains spaces or characters such as colons (:) or minus signs (–) that have special uses in a formula, or if a name resembles a cell reference, enclose the name in single quotation marks.

    • Login to reply the answers
  • 10 years ago

    請問:

    既然DDE有不穩的現象,

    那其他比較好的傳輸方式有哪些呢

    謝謝

    • Login to reply the answers
Still have questions? Get your answers by asking now.