求助:为何Excel与Intouch不通讯 点击：2500 | 回复：9
发表于：2001-12-12 11:50:00
2楼
in Excel to get InTouch data,
= view|tagname!"$second" and so on.
{view is application name,
tagname is topic name,
$second is actual tagname in your InTouch DB
}
in InTouch to get Excel data
Excel|Sheet1!R1c1
{Excel}Sheet1 is your Access name
R1c1 is your item name
}
发表于：2002-05-20 17:59:00
4楼
Dear Johnny:
Thank your for your explaination!
I passed the test for reading tags within Excel to Intouch but failed to make a value setting in Excel which is to be read by intouch.You are being kindly requested to make a more detailed example to display a velue window which is to read from excel table cell input.
Thanks in advance.
发表于：2002-07-05 16:56:00
5楼
Dear Johnny:
Could you please send me a example to show me how to program a macro in Excel to store datas which are read from intouch,e.g.,I want to store such as current ,temperature,voltage,speed,ect.sorts of variables into a Microsoft Excel sheet,and the store duration can be selected by operator,normaly it is 30 minutes,and the whole sheet will be ended to 23:30 oclock.
Thanks in advance.
发表于：2002-07-05 17:55:00
6楼
you can refer this execl macro,
or find detail menu from excel book.
============================
Option Explicit
Public Sub Macro1()
rem
rem Macro1 巨集表
rem Johnny Cheng 在 10/23/2001 錄製的巨集
rem
Dim view
view = DDEInitiate(app:="\\johnny\view", topic:="tagname")
Range("b7") = DDERequest(view, "$datestring")
Range("c7") = DDERequest(view, "$timestring")
DDETerminate view
rem
End Sub
=======================
热门招聘
相关主题
- 组态王的自定义函数.
[2367] - 我有三菱GPPW软件有谁需要？[2462]
- 怎样将WinCC V5.0项目移植到...[4889]
- PLC试题参考[25316]
- 安装好WINCC的电脑修改计算机...[3767]
- 组态软件排名[4568]
- eplan生成报表以后加载不出来...[2805]
- s7-300与组态王通讯[3038]
- 为什么通讯总是中断？？[3192]
- 求助：关于组态（上位机）与PLC...[3938]
官方公众号
智造工程师
-
客服
-
小程序
-
公众号
工控网智造工程师好文精选
