I think, it is time you to study error handling procedures. Example.
ON ERROR GO TO RESUME RESUME NEXT Go Ahead. Regards, Kishan Reddy, K On May 9, 1:15 am, hanumant shinde <arsfan2...@yahoo.co.in> wrote: > Hey guys, > > its been 2 days but not even single reply. is it too tough or its not at all > possible. > i am not asking u to develop a macro n give it to me. just gimmi some hints to > proceed. > > i hope this is fine with you guys.i m relying on you guys a lot. > > Thanks > > ----- Original Message ---- > > From: hanumant shinde <arsfan2...@yahoo.co.in> > > To: Excel Group <excel-macros@googlegroups.com> > > Sent: Sat, 7 May, 2011 1:37:54 AM > > Subject: $$Excel-Macros$$ Macro to monitor another Macro > > > Hi Guys, > > > lets say there are 2 workbooks wkbk_run and wkbk_monitor. wkbk_run has > > macro > > which runs automatically and sometimes it throws OLE error for which we > > need > >to > > > MANUALLY click OK button. i want wkbk_monitor to monitor that wkbk_run and > > whenever that OLE error occurs it should click OK automatically. i know > > there > >is > > > some API to click OK button but i dont know anything about it. > > > is it possible to create such a macro to monitor another macro. > > there are N numbers of Macros like wkbk_run so i cannot keep that code in > > all > > the workbook. so i want another macro to monitor all the macro which runs > > automatically. > > > so it will be like monitor macro will run when 1st macro starts running and > >that > > > will stop running when last macro gets over. > > > thanks guys. > > > please let me know if is it possible? > > > -- > >---------------------------------------------------------------------------------- > >- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > >http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
