Retrieving Datataker data direct into an Excel Worksheet in real time for any Excel process including real time data graphing was once a very simple process, setup by using a Datataker supplied ActiveX Control [datataker.ocx].
Maybe it still is an easy process, but I haven't been able to find any contemporary documentation on the subject.
What made the dataker.ocx so useful was that it allowed for any number of Datataker RS232 and TCP/IP Connection details to be created automatically [on detection of a Datataker connected to a serial port] and saved in the computer registry by Connection name.
Datatakers could then be easily connected to from within other applications [notably Excel] by simply referencing only the Connection name. The connection would then allow any Datataker action to be performed from within an Excel macro, such as any data retrieval directly into worksheet cells.
This opened up a world of useful possibilities in Excel including formula manipulation of real time updating data, interactive graphs, reports, complex maths etc., and much more. Both email and SMS can easily be sent direct from within Excel by formula or macro and this provided for great versatility in moving specific data around to recipients as required and in any report format. In real time.
This datataker.ocx will not work with the DT80M though; it belonged to previous genre Datatakers. The OCX was old school and set up for RS232 connections only. The same principles though might be adaptable to USB and the new datataker models, but this would need an expert opinion. I still have it on an old machine - and working well.
Has anyone been down this track with a DT80M and Excel and have any advice to share with the forum please?
Lawrence
Retrieving Datataker data direct into an Excel Worksheet in real time for any Excel process including real time data graphing was once a very simple process, setup by using a Datataker supplied ActiveX Control [datataker.ocx].
Maybe it still is an easy process, but I haven't been able to find any contemporary documentation on the subject.
What made the dataker.ocx so useful was that it allowed for any number of Datataker RS232 and TCP/IP Connection details to be created automatically [on detection of a Datataker connected to a serial port] and saved in the computer registry by Connection name.
Datatakers could then be easily connected to from within other applications [notably Excel] by simply referencing only the Connection name. The connection would then allow any Datataker action to be performed from within an Excel macro, such as any data retrieval directly into worksheet cells.
This opened up a world of useful possibilities in Excel including formula manipulation of real time updating data, interactive graphs, reports, complex maths etc., and much more. Both email and SMS can easily be sent direct from within Excel by formula or macro and this provided for great versatility in moving specific data around to recipients as required and in any report format. In real time.
This datataker.ocx will not work with the DT80M though; it belonged to previous genre Datatakers. The OCX was old school and set up for RS232 connections only. The same principles though might be adaptable to USB and the new datataker models, but this would need an expert opinion. I still have it on an old machine - and working well.
Has anyone been down this track with a DT80M and Excel and have any advice to share with the forum please?
Lawrence
