TTom
Well-known Member
- Joined
- Jan 19, 2005
- Messages
- 518
I use QuickBooks Pro to export data to a pre-existing workbook that I already have
macros written in that I what to execute after data has finished loading from the export.
I have been able to set a timer 'on open' to delay my macro run for a pre-set amount of
time, but I must guess at the transfer time of new data and always plan for the longest
possibility. That often waste time if the transfer is very small.
Does VBA have the capability to sense if data is still being written and not activate my
macro procedure until the data transfer procedure is complete? If so, how would I go
about this?
<i>Using Excel 2003 / Office SP3</i>
macros written in that I what to execute after data has finished loading from the export.
I have been able to set a timer 'on open' to delay my macro run for a pre-set amount of
time, but I must guess at the transfer time of new data and always plan for the longest
possibility. That often waste time if the transfer is very small.
Does VBA have the capability to sense if data is still being written and not activate my
macro procedure until the data transfer procedure is complete? If so, how would I go
about this?
<i>Using Excel 2003 / Office SP3</i>
