TConnolly
Lifetime Supporting Member
I have a VBA script that reads 90 tags from a file (a custom recipe) and writes those values to tags. When I tested the VBA offline in Works writing to memory tags the script ran fast. But when I run it in Runtime and write to PLC tags then the script becomes very slow, taking about 15 seconds to read the file and write to the tags, and closer to 30 seconds to read the tags and write back to the file for a recipe save.
The PLC is a ControlLogix connected over ehternet via OPC server. All the rest of the communications is lighning fast - so its not a comm problem.
Am I missing something here - or is there a way to give the VBA script more resources to it will run faster?
The PLC is a ControlLogix connected over ehternet via OPC server. All the rest of the communications is lighning fast - so its not a comm problem.
Am I missing something here - or is there a way to give the VBA script more resources to it will run faster?