AnsweredAssumed Answered

vrf Programming Webcam with VEE using ActiveX/DirectShow... any sample?

Question asked by VRFuser on Sep 24, 2008
Latest reply on Sep 24, 2008 by VRFuser
Hi VRF

I have macro which runs in vba in excel. The macro generates lots of data which it puts into cells. The workbook has charts on it when the macro is run excel continuously updates the charts slowing down the process. For example with out any charts the macro take 2.6 seconds to complete with the charts the macro takes 10 seconds.

I have already set Application.Calculation to xlCalculationManual and reset it to xlCalculationAutomatic at the end of the macro, is there a way to disable the automatic updates on the charts as well?

Thanks

Jacob Meachen


---
You are currently subscribed to vrf as: hua_jing@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".  

Outcomes