Record data from link (OPC) and date next to each cell recorded automatically
up vote
0
down vote
favorite
I´ve been trying to develop a code in VBA Excel that records data from PLC link OPC, I´m trying to record downtimes and the date they were recorded, I have a code but it does not seem to work properly. I just know the basics of programming. Really looking forward to get this done.
This is the code I´ve been working in, (I took it from the web)
Thank you all before hand
Code
microsoft-excel date recording
asked Nov 29 at 20:39
Oscar G.
11
add a comment |
up vote
0
down vote
favorite
I´ve been trying to develop a code in VBA Excel that records data from PLC link OPC, I´m trying to record downtimes and the date they were recorded, I have a code but it does not seem to work properly. I just know the basics of programming. Really looking forward to get this done.
This is the code I´ve been working in, (I took it from the web)
Thank you all before hand
Code
microsoft-excel date recording
asked Nov 29 at 20:39
Oscar G.
11
You mean to say that you need a Macro to down load data from Web and record Down load Date & Time also.
– Rajesh S
Dec 1 at 6:31
@RajeshS I have the PLC linked to one cell in excel through OPC Topic, the PLC data is constantly changing, I need a macro that records the previous data when the cell changes and also print the date and time the data was recorded. Regards
– Oscar G.
Dec 3 at 15:28
in that case for better response please edit the question and include that you need Macro should record previous data along with date in other sheet to audit modifications.
– Rajesh S
Dec 4 at 4:29
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I´ve been trying to develop a code in VBA Excel that records data from PLC link OPC, I´m trying to record downtimes and the date they were recorded, I have a code but it does not seem to work properly. I just know the basics of programming. Really looking forward to get this done.
This is the code I´ve been working in, (I took it from the web)
Thank you all before hand
Code
microsoft-excel date recording
asked Nov 29 at 20:39
Oscar G.
11
I´ve been trying to develop a code in VBA Excel that records data from PLC link OPC, I´m trying to record downtimes and the date they were recorded, I have a code but it does not seem to work properly. I just know the basics of programming. Really looking forward to get this done.
This is the code I´ve been working in, (I took it from the web)
Thank you all before hand
Code
microsoft-excel date recording
microsoft-excel date recording
asked Nov 29 at 20:39
Oscar G.
11
asked Nov 29 at 20:39
Oscar G.
11
edited Nov 30 at 19:03
asked Nov 29 at 20:39
Oscar G.
11
asked Nov 29 at 20:39
Oscar G.
11
asked Nov 29 at 20:39
Oscar G.
11
11
You mean to say that you need a Macro to down load data from Web and record Down load Date & Time also.
– Rajesh S
Dec 1 at 6:31
@RajeshS I have the PLC linked to one cell in excel through OPC Topic, the PLC data is constantly changing, I need a macro that records the previous data when the cell changes and also print the date and time the data was recorded. Regards
– Oscar G.
Dec 3 at 15:28
in that case for better response please edit the question and include that you need Macro should record previous data along with date in other sheet to audit modifications.
– Rajesh S
Dec 4 at 4:29
add a comment |
You mean to say that you need a Macro to down load data from Web and record Down load Date & Time also.
– Rajesh S
Dec 1 at 6:31
@RajeshS I have the PLC linked to one cell in excel through OPC Topic, the PLC data is constantly changing, I need a macro that records the previous data when the cell changes and also print the date and time the data was recorded. Regards
– Oscar G.
Dec 3 at 15:28
in that case for better response please edit the question and include that you need Macro should record previous data along with date in other sheet to audit modifications.
– Rajesh S
Dec 4 at 4:29
You mean to say that you need a Macro to down load data from Web and record Down load Date & Time also.
– Rajesh S
Dec 1 at 6:31
You mean to say that you need a Macro to down load data from Web and record Down load Date & Time also.
– Rajesh S
Dec 1 at 6:31
@RajeshS I have the PLC linked to one cell in excel through OPC Topic, the PLC data is constantly changing, I need a macro that records the previous data when the cell changes and also print the date and time the data was recorded. Regards
– Oscar G.
Dec 3 at 15:28
@RajeshS I have the PLC linked to one cell in excel through OPC Topic, the PLC data is constantly changing, I need a macro that records the previous data when the cell changes and also print the date and time the data was recorded. Regards
– Oscar G.
Dec 3 at 15:28
in that case for better response please edit the question and include that you need Macro should record previous data along with date in other sheet to audit modifications.
– Rajesh S
Dec 4 at 4:29
in that case for better response please edit the question and include that you need Macro should record previous data along with date in other sheet to audit modifications.
– Rajesh S
Dec 4 at 4:29
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1379560%2frecord-data-from-link-opc-and-date-next-to-each-cell-recorded-automatically%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
You mean to say that you need a Macro to down load data from Web and record Down load Date & Time also.
– Rajesh S
Dec 1 at 6:31
@RajeshS I have the PLC linked to one cell in excel through OPC Topic, the PLC data is constantly changing, I need a macro that records the previous data when the cell changes and also print the date and time the data was recorded. Regards
– Oscar G.
Dec 3 at 15:28
in that case for better response please edit the question and include that you need Macro should record previous data along with date in other sheet to audit modifications.
– Rajesh S
Dec 4 at 4:29