Skip to Content
0
Former Member
Sep 09, 2010 at 10:12 AM

VBA event

48 Views

Hi,

If I send data to the database with the setting 'manual calculation' in Excel the time is much faster than with 'Automatic calculation'.

My problem is: I need the automatic calculation when the users enter data (because of EV_SUM). Is there an VBA event I can trigger before I send data to the database?

Thanks,

Lars

Edited by: Platon BPC on Sep 9, 2010 12:13 PM