Emerson Exchange 365

v8.4.1 upgrade to 12.3.1 issue with VBA

Just upgraded a system to 12.3.1 from 8.4.1 and have an issue with some overview graphics using some VBA scripts to update a batch prompt. When the graphic opens in 12.3.1 it stops responding or is updating the information very very slowly. It appears to be a script which update a graphic symbol of any batch prompts. Simple enough script using frsReadValue under a 2 second event timer. If we remove the script graphic is ok so it is definitely related to this.

Does anyone know of any information relating to VBA and changes between DV versions?

• VBA
• frsReadValue

pjs6557

• 4 Jul 2016 1:59 PM
• Cancel

3 Replies

• chip.burge

  

  • 5 Jul 2016 2:10 PM

  I'm not sure of VBA changes between versions. Wouldn't visibility animations be a cleaner way to do this?

  • Cancel
• pjs6557

  

  • 11 Jul 2016 3:22 PM

  In reply to chip.burge:

  Just discovered that in the v12.3.1 upgrade .chm file it states that the frsReadValue and frsWriteValue when used in loops can cause slow response. I'm not sure why this client hadn't used animations but the solution is to add DoEvents in each loop, dirty but should work!

  • Cancel
• pjs6557

  

  • 1 Aug 2016 10:25 AM

  In reply to pjs6557:

  Update: DoEvents does not improve that situation. Whilst it does allow command buttons to be pressed but whatever script is behind them does not run.

  • Cancel