RSView VBA script is unacceptably slow.

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?

There are some frequently-overlooked actions that will greatly improve the performance of tag writes from VBA in RSView32; sorry if you know them already and I'm teaching you to suck eggs.

Don't use individual tags. Better to create a tagS object and populate it using a gtagdb.queryfortags method.

Loop through all the tags in the the collection of tags and set their pending values.

Put the collection on scan (MyBigBunchOfTags.onscan roWait)

Write the pending values (MyBigBunchOfTags.WritePendingValues roWait)

Take the collection off scan

Hope this helps.

Hello,

I have same problem, could you please give me an example of VBA code?
How should it be?

Thanks