Stop dialog box appearing as it stops macro

[jackthejock]

Hi all,

Am sure this is easy one for someone... hopefully.

I have a macro which runs to import info from an external file into Excel (I'm using Excel 2003 as it is easiest for my purposes). If the source file isn't running, my Excel macro errors and shows an 'End'.. 'Debug' dialog box. This then stops the macro from running once the source file is running again.

Is there any way I can tell the macro to not show dialog and thus carry on or, just keep checking for file and import as normal when it's available?

TIA

Jack

[wallyeye]

You can wrap the section of code:

Please Login or Register  to view this content.

If the file could be tied up for a period of time, you might want to consider using application.ontime to retry every few seconds/minutes. The version above will get pretty cpu intensive quickly. A sample timer:

Please Login or Register  to view this content.

Understand I've not tested this, it will probably need debugging.

[jackthejock]

Thanks for the reply, I'll look at that.