Hi Guys,
I am writing a web macro using VBA. I was entering values in the pages like this..
Set IeBro = New InternetExplore r
IeBro.Navigate( "www..")
..
..
Set IeDoc1 = IeBro.Document
IeDoc1.property .value = ...
etc..
but in one of the pages on the click of a link a popup comes up where I am stuck. I dont know how to enter values in the text box in this popup....
User Profile
Collapse
-
Entering values in popups using VBA Macro
-
Hi..
Its working now..
I gave the code as document.form.o bject.selectedi ndex.=n
where n is the index of the required value..
I dont understand if it can get so simple..anyway its working..:-)... -
Hi..
Its working now..
I gave the code as document.form.o bject.selectedi ndex.=n
where n is the index of the required value..
I dont understand if it can get so simple..anyway its working..:-)...Leave a comment:
-
-
hi,
I am writing the code in VBA and the dropdown menu is in an external web page..
I cant fiddle with the HTML code there...
I have submitted the query in VB forum as well..
Thanx for your help..
Balu435...Leave a comment:
-
programmatically select an option in dropdown
Hi friends,
I have an (VBA) application which programatically fills the values in a web page.
In the web page there is a dropdown menu whose options are selected during run-time by using a function.Is there anyway by which I can select the option in the dropdown menu programatically ?
If the dropdown menu in the web page had its options explicitily mentioned (like <option value="1">1</option>...)... -
programmatically select an option in dropdown
Hi friends,
I have an (VBA) application which programatically fills the options in a web page.
I have an dropdown menu whose options are selected during run-time by using a function.Is there anyway by which I can select the option in the dropdown menu programatically ?
If the dropdown menu had its options explicitily mentioned (like <option value="1">1</option>...) I could have used document.form.o bjectname.selec tedindex=n... -
Hi..
Thanks for your reply..it was an error with the way I passed the values...I am sorry......Leave a comment:
-
how to retrieve a cell value from HTML page using VBA
Hi friends..
I have a VBA program which opens up a webpage. I want this program to retrieve a value inside a particular <td></td> tag and store it in the excel sheet.I came across a method called object.getEleme ntsByTagName but its not exactly working.How to use it (do I have to add any particular reference for this DOM method) or is there any other method..can anyone help by giving the exact wayout..
With... -
Hi..
thanx for the reply.
My qn wasn't proper though..I was trying to click the link from a VBA application.I used the .innertext property to retrieve the name of the link and then used the onclick event to simulate the click event.Its working now.
Thanx for ur help.....Leave a comment:
-
to replicate the click of a link
Hi friends,
is there a way where by I can programmaticall y click a link in a web page?.if its a button I can use document.formna me.element(i).c lick where element(i) might represent the button.Is there a similar action for a link?
Thanx in advance,
Balu435 -
firing javascripts events
Hi,
I have a VBA program(macro) which automatically goes to a web page and fills the details in that page.There is a month listbox on the selection of which a date listbox gets repopulated.But when I programmaticall y change the month list box value using object.selected indexvalue=x the value of the date listbox field is not getting repopulated.I feel the onchange event of the month listbox is not getting fired.Can anyone kindly help?... -
passing data to an already open browser using VBA
Hi
I used the following code to enter values to an already open browser using VBA.
Dim IeBrow As InternetExplore r
Dim IeDoc As Object
Set IeBrow = New InternetExplore r
IeBrow.Visible = True
IeBrow.Navigate ("www.rediffmai l.com")
IeDoc.loginform .login.Value = userid
IeDoc.loginform .passwd.Value = passwd
..
..
this helps me to open a browser and enter the values...
No activity results to display
Show More
Leave a comment: