DDE
Jeg prøver på at overfører data fra VTplus som følger med WinTv hauppaunge. Men jeg kan ikke få det til at virke. Så hvordan henter jeg i EXCEL 2000, en side?f.eks. side 100 på INFOkanalen uden filter
Dette står om DDE i VTplus:
1. Command port:
Several Script commands from VTPlus can also be executed via DDE. Connect your destination program with VTPlus | System and transport the commands in brackets with DDEExecute.
For example:
Sub MAIN
Kanal = DDEInitiate(\"VTPlus\", \"System\")
DDEExecute Kanal, \"[GET 100]\"
DDETerminate Kanal
End Sub
starts under Word-Basic the reception of Page 100.
The execution of your command may be denied, ask from VTPlus the (item) Status via the DDERequest. The feedback you get could be \"Ready\" or \"Busy\".
For exampe:
...
a$ = DDERequest$(kanal, \"STATUS\")
MsgBox a$
...
displays under Word-Basic, whether VTPlus is ready to execute a command.
2. Data port:
Data is fetched with DDE directly from the displayed windows. A list of these windows you get with a DDERequest for the item Topics under the topic System.
Connect your program with VTPlus | window (for example VTPlus | ARD422). First you can check whether the selected page including all subpages have been received in your destination window. Ask with DDERequest about the item Status. The feedback you can get are \"Ready\" for complete reception or \"Busy\" for not received completely.
There are two basic possibilities to read in the data.
Manual You fetch the data by a single request yourself. The used terminology depends on the used program, for example DDE-Request, Linkmode 2 or Cold Link. You will get an error feedback, when one or several selected subpages are not yet available. We advise you therefore, after you have requested data via the command port, to establish an automatic connection with VTPlus and to ask for Status.
Automatic When the data changes, VTPlus will deliver the data automatically. This is always experienced when all affected subpages are being received and at every update, when the option update continuously is marked. You have to build a continuous connection, the often used terminology depends again on the used program and may vary from, for example DDE-Advise, Linkmode 1 or 3, Warm Link, Hot Link.
The requested item has to be transferred with the following Syntax:
f,l,fi,fp
f first subpage from 1 ... 64 (Preset 1). If you use -1 here, the actual displayed subpage is transferred. In this case the parameter l is ignored.
l last subpage from 1 ... 64 (Last available preset)
fi A filename of an optional referred filter with complete path information, which has been created with the VTPlus Filter editor , or command file for an external Filter function.
fp Parameter for an external filter function, optional in \"\".
The element fp may be optionally enclosed with (fp) or \'fp\'.
Examples:
=VTPlus|ard422!\'1,2,c:\\tt\\ard422.vtf\'
stands for an Excel connection to VTPlus, where a filter is being used. When you mark your complete working space on your Excel worksheet and change with the command ctrl + shift + Enter a so called \"Array\" is created. You will find more extensive information in your Excel-manual.
{DDEAUTO VTPlus ard422 1,2}
creates a Winword connection to VTPlus. No filter is being used in this example.
Note:
The DDE connection is ended to a window if this receives another name. This happens for instance when you enter the command receive or any other similar action in this kind of manner.
