I have a macro that pulls information from a database. Once all the
information is in Excel it then does some calculations. The problem is
that the information coming from the database takes a while to load,
but the macro keeps going so I get an error because it's trying to do
calculations on data that isn't there yet. I've tried
Application.Wait(Now + TimeValue("0:00:10"))
but that even stops the data coming from the database to stop loading.
Is there a way to get the data to keep loading while the Macro pauses?--~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
