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

2014-11-30 Thread Vaibhav Joshi
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...

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

2014-11-29 Thread Vaibhav Joshi
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

2014-11-29 Thread Sunil Patil
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

2014-11-28 Thread Vaibhav Joshi
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

2014-11-28 Thread Ravi Kumar
@googlegroups.com] On Behalf Of Sunil Patil Sent: Friday, November 28, 2014 10:30 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help to click on Ok button when message from web page Hi there, recently i am doing IE automaton. However this is dealing with one ASP site,, and i am

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

2014-11-28 Thread Sunil Patil
Hi there, recently i am doing IE automaton. However this is dealing with one ASP site,, and i am accessing internal objects almost i am reaching to close this project, But at there end there is close claim button once i click through vba code there is one alert saying message from web page,, a