internet explorer

Hi Gang! I have weekly reports I run which requires a manual login and pull every time. It is very tedious. I have written code so far that launches IE, and signs me into website navigating to reports page. Where I am stuck - need to select a box based on report name, than click a retrieve...

Hello everyone, I am trying to grab an ID number from my Excel sheet, navigate to a webpage, find a link using the ID number as anchor text, and extract the 'po_header_id' number from the link. This is what I have so far: Dim IE As Object Dim PoNum As String ' Create InternetExplorer...

Hi there, I can't figure out how to input a value into this date-picker. Here's the code from the website... 'Main form id < div id="date-time-picker-react" > < div data-reactid=".3" > < div class=" date-picker date-picker--custom-range date-picker--align-right" data-reactid=".3.0" > < div...

Hiya forum, I'm trying to open some files automatically, which shouldn't be too hard. Unfortunately, so far I've been really held back by the file being located on a weblink. Let's call the weblink http://classifiedlink.com/" & VRl & "type=PDB. Set sh = Workbooks(var1).Worksheets(1) With sh...

Hey Everyone, I've created a VBA code that will automatically populate fields within the website, but I'm having troubles trying to figure out the code to select a state from the dropdown list on the website. I also can't seem to figure out the code to then click on the "Find" button once the...

Hello, I'm having troubles coming up with a code that will "click" on a specific button on a webpage. The code I have so far is the following: Dim IE As InternetExplorerMedium Dim URL As String Dim E Dim btnGo As Object Sub GetData() Set IE = CreateObject("InternetExplorer.Application")...

I'm trying to use VBA script to run and use IE when Workbook is opened. I wrote following code, but IE window stays behind Excel window (only flashing in taskbar). I'm using Office 2010 (32 bit) on Windows 7 (64 bit). "Workbook_open" part of the code Sub Workbook_Open() Application.OnTime...

Hi all, I have the following code that allows me to access the website and select 100 entries per page, although I cannot figure out how to click on the button "Next 100" to access the next page. I tired just navigating to the on click event in the html but that had an error of something like...

Hi all - This is my first post to the forums although I have already found tons of useful information on here in the past. My question is related to building a web scraping macro. I have gotten as far as navigating to the website, entering username and password, selecting the 1st hyperlink...

Hello Mr. Excel folks! I have made great strides on my attempts to automate logging into, and then extracting data, from a website. I have gotten all the way to the point where the data is indeed in excel! However, the data is all going in only one column, column A, and I cannot figure out how...

I am trying to click the button that is attached to this HTML: <tr id="submit_row"> <td class="credentials_table_label_cell"></td> <td class="credentials_table_field_cell"> <input disabled="" class="credentials_input_submit" type="submit" value="Sign In">...

Hello folks I am struggling to use events with IE automation from an Excel workbook, to feed some data from a web server into Excel. The queried page takes very long, and I would like the user to initiate the query with IE to obtain the data, then once the web page is complete, return control...

Hello everyone, Bear with me as this is my first use of a forum! My goal is to use VBA to login to a secure webpage and copy/paste the data from the main table on the page. The code works perfectly except for one thing - the website's default is to show 10 items per page. I am looking to grab...

I am trying to create code that will navigate careerbuilder with internet explorer and apply for jobs automatically. I am stuck at Applying for the actual job by clicking the button which is input type. The code is below. Also I need to attach my resume which exist on my pc to career builder...

Hi All, Using IE in VBA I want to upload my Stock inventory file to Amazon there is a file dialogue box that you need to contend with. Is it possible to upload a file to the element below? I guess it seems like it might be a security risk to do this? Adding value = xxx doesn't seem possible...

I have an unusual question. I am currently using VBA to web scrape Internet Explorer. For various reasons, I can not give out the code but here is the gist, when I (and my coworker who is working independently) try to execute code, we have noticed that the compiler tends to skip lines of code...

Hello, I have a piece of code that opens a webpage in internet explorer. I then want the next section of the code (just picks information off the webpage referring to specific elements) to run only when 'the user' types in a search and navigates to the search results page. The program would...

Hello, I'm trying to fill in fields on a website with excel and am having some issues. Ideally I would like to have the value taken from Cell(1,1). I have been able to automate the login process but that pages code is far more simple. I'm able to get to the page where information needs to be...

In Excel VBA, how may I refer to already open page in Microsoft Internet Explorer?Something likeInternetExplorer.Application.Document.forms(1)I don't want to set application and navigate to specific website (automation of Internet Explorer from Excel VBA). The web page is already open in...

I'm trying to use VBA to automatically post adverts on this website called Gumtree. I've been successful with getting VBA to fill up the HTML form input fields but am now stuck at getting the description box iframe to register the new outerHTML. Here is the website: Gumtree Post This is the...