continue and stop

Dice · May 9th, 2002, 10:17 AM

Here is my problem

When I run a macro that update files from the internet, the macro stops if one of the files are missing.

I would rather have it to give me a message saying "The file something.txt is not updated yet".

I would also like to make a choice when this message appear.

Something like "Continue" and "Stop"

Can anybody help me with this one??

Juan Pablo González · May 13th, 2002, 12:44 AM

Is the macro programmed to stop ? is it using Error handling ?

For the second question... if you NEED those two words you would have to create a Userform... I would suggest instead using a MessageBox (With answers vbYesNo) asking the user if he wants to continue.

May 13th, 2002, 12:44 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Is the macro programmed to stop ? is it using Error handling ? For the second question... if you NEED those two words you would have to create a Userform... I would suggest instead using a MessageBox (With answers vbYesNo) asking the user if he wants to continue. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 10:17 AM	#1
Dice New Member Join Date: May 2002 Location: Norway Posts: 41	Here is my problem When I run a macro that update files from the internet, the macro stops if one of the files are missing. I would rather have it to give me a message saying "The file something.txt is not updated yet". I would also like to make a choice when this message appear. Something like "Continue" and "Stop" Can anybody help me with this one??