Hello to all! I have this problem with my code, basically heres what it does > load page > get html > click button (after this some part of the pag will reload)> then get html again > then click button then a a part of the page will reload and so on repetitively... here is my code: Sub...
Dim HTMLDoc As HTMLDocument
Dim oBrowser As InternetExplorer
Sub Website_Login_Test()
Application.ScreenUpdating = False
Dim oHTML_Element As IHTMLElement
Dim sURL As String
Dim evt As Object
On Error GoTo Err_Clear
sURL = "wwww. this is where my page is.jsp"
Set oBrowser = New InternetExplorer...
my code seem to run fine on other pages, but on this page it wont run, let me give you some details, my code is basically a code that gets the html objects from a page, when I run it it opens the page but it cant get the html elements/objects. Can you point me out to the right direction so I...
Hi,
I'm using the url extension for Google's "I'm feeling lucky" functionality but want to copy the url this function opens (i.e. the direct url). I'm using the below macro which works fine but need it to loop down a list until it finds a blank cell.
I have a list of hyperlinks in column E...
Hello,
I'm having difficulty trying to get the class id, name id etc on Internet Explorer.
I'll try to use this as an analogy of a tree.
In IE when I press F12 on the keyboard, I'm able to search "Monthly Operational Reports" - the 14th branch (I tried to attach a print screen, but it seems...
Hi there,
I am looking to create a small utility which 'scrapes' data from one IE session, and pastes that to another form in a seperate IE session. The difficulty I am having is that the administrator has locked access to the source and as such I am unable to inspect the HTML code directly in...
Hello - first post here :)
I'm a VBA newbie and haven't really started with the easiest project! I'm trying to pull some data out of a website using a VBA macro and would like it to use an existing IE window (as it requires user intevention to find the correct page in the first place - this...
Hi All,
I've searched all over but can't find any code that works for me on this!!!!!
I need to open a URL and then choose a specific button followed by a refresh of the webpage
I can't share the web page but the radio button I want to choose is called RblSlotDTD_3 (I assume from the HTML...
I have a few questions regarding internet explorer automation. I am using Excel 2010. I am trying to automate an internal web application. Unfortunately the web application from what I can tell is a series of java script functions. I would post the source code but for obvious reasons I am not...
As the titles says I am interested in finding a coding option to using the search/highlighting feature of IE. I am working with a heavily framed java database that I need to automate via VBA. I have tried the usual iframe/frame solutions to selecting text or clicking in textboxs, etc, but with...
Hello Still stuck on a problem. I'm trying to loop through a table on a webpage. I'm referencing my excel sheet's B1 cell. Everytime my B1 value matches the webpage tables first column value. I want to copy a specific cell from that row.
The following code only works for the first row. I...
Hi all,
So here's where I'm at: I have a macro that will open IE, navigate to my page, fill in the fields, and generate a file for me, but here's the problem:
There's some Java (I think) going on behind the scenes in my page that creates the Excel file that I need to download when I press a...
Hi, I am trying to get price for an item (can be seen by following url below) using VBA:
Natasha Sybil Collar Necklace | Dillards.com
While going through source code, I found element which refers to price as :
<div id="price" style="display:none;">
$78.00...
All:
First and foremost I just want to say how vital this website is as a tool for someone who is trying to learn without a formal programming education. I have been lurking on this site for months now and in that time I have learned enough to actually start writing my own codes. After reading...
Hi, I have the following code which sends a google web search to Internet Explorer. What I need is to then automate "Edit with Microsoft Word" which is found in the IE File menu. Does anybody have any suggestions for this?
Sub HyperSearchDan()
Dim Google As String
Dim NoVerb As String
Google =...
Hello again forum.
Yesterday I've managed to navigate through a webpage via vba, but I can't figure out the last step, or the one before it.
I need to click on a submit type button, but I can't figure out how to do it.
The problem is, I can't get the element by name, because all 3 share the...
Good day Guys,
Every day I gotta enter information in my work´s website (intranet), however I dont know that much about manipulate with VBA the Internet Explorer application, for example once I enter information in the website, I gotta enter an ID after that I gotta select the date, then I...
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.