RE: $$Excel-Macros$$ Need help to click on Ok button when message from web page

Hi, Add below line in your code. Might be it works webbrowser.Silent = True ‘webbrowser’ is your webbrowser object name like if you are using ‘ie’ so use ie instead of ‘webbrowse’ Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Need help to click on Ok button when message from web page

hi you can try adding either of foll lines... Application.SendKeys("{enter}") or Application.SendKeys("~") however its always not the same thing what we percieve, if it doent work pl share ur code to chek further... Cheers!! + *I did not do this for you. God is here working through me for

Re: $$Excel-Macros$$ Need help to click on Ok button when message from web page

Hi Ravi/Vaibhav its not working at all.. i hv button from ASP that ieobj2.getlementbyid("cmdclose").click once i click it generate alert..and my code stops debugging next, aleart is do u really want to close this.. i hv to click on ok button please siggest me further solution On Fri, Nov 28,

Re: $$Excel-Macros$$ Need help to click on Ok button when message from web page

Hi Can you share url of webpage which you are acessing.. On Nov 30, 2014 12:29 AM, "Sunil Patil" wrote: > Hi Ravi/Vaibhav > > its not working at all.. > i hv button from ASP > > that ieobj2.getlementbyid("cmdclose").click > > once i click it generate alert..and my code stops debugging next, a

Re: $$Excel-Macros$$ Need help to click on Ok button when message from web page

hi you can use following line in stead of yours ieobj2.getlementbyid("cmdclose").click IE.document.all.Item Call IE.document.parentWindow.execScript("javafunction()", "JavaScript") in above secone line replace javafunction with a function which is called by your webpage on clicking ok button...