LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Excel 2002 recalculation while executing VBA Procedure

I am running DDE real time data into sheet one, linking to a series of sheets
with fair amount of formulas. This still recalcualted reasonably OK though it
appears to be close to the edge.

If I now try to run a VBA procdure for more complex analysis the
recaluclation appears swamped and DDE also usually crashes.

Even a simple VBA function to show current tim ( TIMER$) give the dreaded
hourglass and stop the rest in its tracks (shows the right time though with
second ticks,,,,)

Any thought how I can run the VBAprocs without crashing the DDE incoming
stream nor the recalculation system as the data comes in.

Many thanks for any help.

Happy Easter,

Ed Leshik
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Executing a bat file from Excel Mr BT[_2_] Excel Worksheet Functions 9 April 16th 07 09:18 PM
Executing of excel Macros. KarthikK Excel Discussion (Misc queries) 4 June 28th 05 12:00 PM
Excel recalculation R Ormerod Excel Discussion (Misc queries) 3 May 4th 05 01:56 PM
Executing sub procedure when Excel starts strataguru[_18_] Excel Programming 2 September 23rd 04 11:27 PM


All times are GMT +1. The time now is 09:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"