I have a macro that runs an online report, the report has an option to export the report to excell. My macro tells the report to do so, but then I have a 2nd macro to split the data up. However it takes time to down load the online report so I need a pause. Application.wait doesnt work because it stops the download process. So I need something else! Any ideas?