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 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 > -- ---------------------------------------------------------------------------------- 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
