Re: $$Excel-Macros$$ Re: How to pause the Excel VBA macro at certain point and then start again

2014-06-12 Thread Sukanta Datta
it Sub > End If > MsgBox "Complete" > End Sub > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the peo

Re: $$Excel-Macros$$ Re: How to pause the Excel VBA macro at certain point and then start again

2014-06-12 Thread Paul Schreiner
Sukanta Datta >To: excel-macros@googlegroups.com >Cc: schreiner_p...@att.net >Sent: Thursday, June 12, 2014 11:18 AM >Subject: Re: $$Excel-Macros$$ Re: How to pause the Excel VBA macro at certain >point and then start again > > > >I did not mean to say Application.W

Re: $$Excel-Macros$$ Re: How to pause the Excel VBA macro at certain point and then start again

2014-06-12 Thread Sukanta Datta
t; ------------------------- > > *From:* Sukanta Datta > > *To:* excel-...@googlegroups.com > *Sent:* Wednesday, June 11, 2014 6:04 PM > *Subject:* $$Excel-Macros$$ Re: How to pause the Excel VBA macro at > certain point and then start again > &g

Re: $$Excel-Macros$$ Re: How to pause the Excel VBA macro at certain point and then start again

2014-06-12 Thread Paul Schreiner
y - From: Sukanta Datta >To: excel-macros@googlegroups.com >Sent: Wednesday, June 11, 2014 6:04 PM >Subject: $$Excel-Macros$$ Re: How to pause the Excel VBA macro at certain >point and then start again > > > >Thank you very muc

$$Excel-Macros$$ Re: How to pause the Excel VBA macro at certain point and then start again

2014-06-11 Thread Sukanta Datta
Paul, I want to mentioned that the code I provided fine if I am in break mode and execute line by line but it does not work when I run without break mode. It never set wb4 and goes in infinite loop situation. I have to kill the process to get out. Thanks, Sukanta Datta On Tuesday, June 10, 2

$$Excel-Macros$$ Re: How to pause the Excel VBA macro at certain point and then start again

2014-06-11 Thread Sukanta Datta
Thank you very much for the reply but Application.Wait does not work. Paul, I try to implement your method but the problem is the file is not created yet. Can you tell me how to save the file I am creating to save automatically in a directory? Whenevr I try to activate the new file it does n