Hi Everybody, i Reeeeaaaallly need you help please.
What i need to do is this, i´m working in citect with a simple program, monitoring 4 digital variables, monitoring if they are on or off, i read the data from an adam 4050 conected via an adam4520 to the computer everything works fine, but what i have to do is to register every 10 min. for example the state of each one of the digital inputs and record it in Excel.
Ive worked with this: "=Citect|Data!Motor_primario" in excel and i can see the state of each one of the entries with no problem, but it doesnt save any data it just shows in real time the state of the entries.
When i made a trend of the entries and push the save button and saves it like an *.xls i have the excel file i need but i have to push the save button, it doesn´t work automatically.
Ive read the citect manual and i guess the csv list (working with the macro ddeformu.xls) is what i need but it doesnt work.
So this is what ive done so far: ive tried to make a Visual Basic program, it works but everytime i save a data in excel i "lose" some seconds, so in an hour i end losing like 2 or 3 min. Its really a program, cause i need to monitor at least a day.
So i´m guessing the solution is working with cicode (maybe trnexportdbf), but i´m kinda new with citect and i cant do it.
It doesnt matter if the solution is with Excel or maybe with a Database like an Acces file.
Please HElP!!! i´m desperate, if you wish i can send you my visual basic program.
If you can help me and need some information my mail is [email protected]
PLease, i really would apreciate iif you can help me
What i need to do is this, i´m working in citect with a simple program, monitoring 4 digital variables, monitoring if they are on or off, i read the data from an adam 4050 conected via an adam4520 to the computer everything works fine, but what i have to do is to register every 10 min. for example the state of each one of the digital inputs and record it in Excel.
Ive worked with this: "=Citect|Data!Motor_primario" in excel and i can see the state of each one of the entries with no problem, but it doesnt save any data it just shows in real time the state of the entries.
When i made a trend of the entries and push the save button and saves it like an *.xls i have the excel file i need but i have to push the save button, it doesn´t work automatically.
Ive read the citect manual and i guess the csv list (working with the macro ddeformu.xls) is what i need but it doesnt work.
So this is what ive done so far: ive tried to make a Visual Basic program, it works but everytime i save a data in excel i "lose" some seconds, so in an hour i end losing like 2 or 3 min. Its really a program, cause i need to monitor at least a day.
So i´m guessing the solution is working with cicode (maybe trnexportdbf), but i´m kinda new with citect and i cant do it.
It doesnt matter if the solution is with Excel or maybe with a Database like an Acces file.
Please HElP!!! i´m desperate, if you wish i can send you my visual basic program.
If you can help me and need some information my mail is [email protected]
PLease, i really would apreciate iif you can help me