I am using a tag through RSlinx to trigger a macro in an excel spread sheet. When the tag goes high I want to log the date and time into a column. The macro works if I manually enter the 1 but when the tag goes high and changes the value to a 1 it doesn't log the data.
Excel macro not running
- Thread starter coltbean
- Start date
tarik1978
Member
what Rslinx version do you have?
the lite version wont work
here's a good tutorial on to setup the communication between Rslinx and Excel
https://theautomationblog.com/getting-allen-bradley-plc-and-pac-data-into-excel-using-rslinx/
the lite version wont work
here's a good tutorial on to setup the communication between Rslinx and Excel
https://theautomationblog.com/getting-allen-bradley-plc-and-pac-data-into-excel-using-rslinx/
Ken Moore
Lifetime Supporting Member
A quick search gave me this:
https://support.microsoft.com/en-us...un-a-macro-when-certain-cells-change-in-excel
https://support.microsoft.com/en-us...un-a-macro-when-certain-cells-change-in-excel
tarik1978
Member
Similar Topics
Hello. For a PLC data logging application at a candy factory, a customer requested me to setup an add-in for MS Excel called "MX Sheet" which is...
I have not been able to crack this one out, even after much thinking and googling:banghead:. I would be so grateful if I can get some guidance...
Since this is a large collection of very smart people, hopefully someone here can help out my dumb self.
I have an excel sheet that has 3 columns...
Hi Everyone,
I am currently trying to collect data from Siemens PLc S7-300 with Excel using Libnodave.dll
With the exemple of program from the...
I am taking data from a AB PLC and recording it in excel. When a certain time is reached the macro prints to pdf and then should close out...