Hello,
I wanna ask about vba for internet explorer automation
I use it on e-commerce web (shopxx) to scrape buyer link from other seller.
I have made script & it worked but I have a problem to refresh the Button object.
The step is:
- open IE for other seller rating page
- grab all the link...
Hello Guys,
i have below code that copy table on current webpage but when i change that page it not getting new table. note both the tables have same format, with little change in content,
Dim i As SHDocVw.InternetExplorer
Set i = New InternetExplorer
Dim clipboard As MSForms.DataObject...
Hello all,
current issue is that i am working on one website where it run JAVA script to load data and i need to copy that data once it complete loading. now loading time is not fixed so my code run before it completes loading. do some event and readystate=4 is not working on this.
is there...
Hi,
I need to select option "Assigned to anyone" from below code. it looks like drop down list. HTML for it is as below
<select class="form-control ng-pristine ng-untouched ng-valid ng-not-empty" ng-model="viewOptions.assignedToMe" ng-options="opt.value as opt.label for opt in...
Hi all,
Could you please provide me a macro that record all keys pressed in anywhere in system. It will also fine if it record all key pressed in Internet explorer only.
Thanks,
Nitesh
Hello,
Long time creeper, first time poster!
I've seen similar questions about IE automation on this board and need help adapting code I have found to my situation.
I have code that currently opens IE, navigates to the desired URL, interacts with the form by clicking checkboxes that fit my...
Hi,
We recently had a product delivered which was created by a third party. This product is web based and has a static URL but is essentially a system to sell and administrator policies (probably as much as I can say!).
I'm currently building a VBA module that contains small navigation and...
Hey guy,
I am trying to perform some web scraping, but I cannot get the dropdown list filled. I already serached many websites and forums without any success.
In the code below I demonstrate some of the attempts that I have tried unsuccessfully, but doesn't mean that I ran the code that way...
I am trying to scrape a table from the website fltplan.com. I have been able to login utilizing VBA. I run into issues when trying to scrape the active flight plan table. The code I am utilizing to login is:
Sub GetTable()
Dim ieApp As InternetExplorer
Dim ieDoc As Object
Dim...
""This is my first post in this forum"" Would be great if some can help me on this..
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Set objCollection = IE.Document.getElementsByTagName("a")
For Each...
Hi All,
I have a website page which has table formatted buttons to download data with it. below is the source code of website.
I have kept the source code of website in this link. Sorry I was not able to post it in forum thread (it is converting code into webpage ). Let me know if you still...
hi,
I have a web application where i want to select a drop down value based upon the input provided in the excel file. I just cant seem to make it work.
Here is the source code that shows the different values of the drop down:
<tr>
<td width="170px"...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.