internet explorer

  1. M

    VBA Radio Button Selection in IE

    I am trying to select a drop down radio button in Internet Explorer but keep receiving the "Run-time error '424': Object Required" error. Here is the code I am using Sub Select_Cartons() ' Set a reference to 'Microsoft Internet Controls' under the VBA Tools\References menu Dim IE As...
  2. G

    How to navigate through multiple links on website using vba internet explorer

    I want to select options on multiple pages using vba internet explorer and i am able to open multiple tabs and multiple links using vba but only able to navigate on first page. Please check the coding given below for your reference:- <code>Sub mmtlink2() Dim IE As New SHDocVw.InternetExplorer...
  3. M

    Paramaterized Power Query/PowerPivot data import problem

    Hi I have created a powerpivot report in Excel 2016 that imports data from several parameterized SQL Stored Procedures. The purpose it to allow individual users to only view relevant data; the model is quite data heavy so I want to limit the number of records at source. I have created 2...
    • monsoonnut
    • Thread
    • internet explorer parameters powerpivot powerquery sql
    • Replies: 1
    • Forum: Power Tools
  4. Ombir

    Exccute Javascript in IE

    Hi, I want to click on button on a webpage which doesn't contains button tag. I think it is associated with javascript code execution. Below is the Html Code of complete webpage. <!DOCTYPE html> <html> <head> ****** http-equiv="Content-Type" content="text/html; charset=utf-8" /> ******...
    • Ombir
    • Thread
    • allocation button internet explorer vba web scraping
    • Replies: 4
    • Forum: Excel Questions
  5. P

    Click a link in the internet

    Hello all, I`m trying to click a link in Internet Explorer using VBA. Tried a lot of things I could think of, but nothing seems to work. I tried everything I could think of or find in the internet, but nothing worked so far. I know that normal .Click is not working in this website, so I use...
    • pupsia
    • Thread
    • button click focus internet explorer sendkeys
    • Replies: 0
    • Forum: Excel Questions
  6. B

    Need help opening IE browser and searching Google from Excel

    I created a macro in VBA to open an Internet Explorer window, go to Google, and search Google based on what is the the active cell when you trigger the macro. The macro also Maximizes the IE browser window. The problem is that the macro does not run correctly every time. Often it will go to...
  7. C

    IE automation: saving file from website

    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...
    • cfsoule
    • Thread
    • automation http ie automation vba internet explorer xml
    • Replies: 7
    • Forum: Excel Questions
  8. O

    VBA controls for IE and clicking buttons on a page

    Hi, So i have been searching hundreds of forum threads for an answer to this, but its been convoluted due to the website layout that i am working with. I have code that goes to a website and needs to click on a button, but the button doesnt seem to have the same labels that i normally see in...
    • ozborn
    • Thread
    • click click a button html internet explorer vba
    • Replies: 0
    • Forum: Excel Questions
  9. A

    VBA IE question

    I'm able to search the website html text for a specific string. I'd like to go one step further and, if that string is found, then return the word(s) that follow the found string. Example web text: "The player's final review: Excellent" I would search for "final review:" and would want to...
  10. B

    VBA to Identify Webpart. Need IE HTML Expert.

    Hello, I am trying to scrape data from a web query using VBA. The problem I have run into is that I can't find a way to copy the data I actually want. I have tried everything I could find on the forums (document.body document.innertext, document.outerHTML, etc.), but nothing is capturing the...
  11. L

    loading HTML doc with ajax on page using XMLHTTP60

    I am using internet explorer at the moment and its an absolute pain. Can you use XMLHTTP60 to load the html doc if the page contains ajax which loads after the page has? Because when i use the XMLHTTP60 it isn't contained in the document. Any one got any ideas?
  12. N

    Interact with Internet Explorer's open tabs

    Hello there, I'm building a macro to manage some tickets and I now want the application to get some data from a website. 1st I need it to sort out which tab to use, the only value that's unique is the ticket number, in this case "INC0347911" I've seen...
  13. M

    Using the same IE session from different routine

    Hello, I have a main sub called 'NameandDOB'. In there I call a sub routine 'ackchecker' which opens IE, goes to a website and checks if there is an acknolwedgment warning. If there isn't, it brings me to the login page. If there is, it checks the box and brings me to the login screen. The...
  14. S

    Using VBA to select option from IE dropdown menu

    Hello mr excel community!, Im a newbie to VBA, I usually work with VBA to create simple excel macros, but right now, I am working on a new project where I am opening a webpage and filling out some fields, I managed to fill textboxes, but right now I am having trouble to select options from drop...
  15. M

    VBA to Check IE Checkbox

    Hi, I'm attempting to check a form control checkbox using VBA. Here's the html for the item I want to check: Above that HTML there is this HTML: Here's what I've tried to check it: Set objinputs = aExplorer.document.getElementsByTagName("form") For Each ele In objinputs...
  16. M

    Print Child (Popup) Internet Explorer Window:

    What is the correct method for targeting and printing a child (Internet Explorer) web browser window using VBA from within Excel 2016? I've tried a couple of different methods and so far none of them have worked. Try 1: This prints a page to the printer but it targets the parent window to...
  17. L

    Multiple Rows into an Open IE Form

    Hello! I've got a worksheet with around 47 names. This will vary as staffing fluctuates. I've got a secure website where each of these names are entered and/or searched for, at least once or twice a day. Hitting alt+tab, I can copy from the worksheet, move to IE, move back to Excel while IE...
  18. M

    Excel VBA with Internet Explorer help- fill in fields and export data

    So I apologize if there is a comprehensive guide to this somewhere.. I have scoured the internet and these forums searching for everything I can, but I cannot find what I'm looking for. I am not new to macros at all, but I am unfamiliar with using them to automate IE. Essentially what I need...
    • mnty89
    • Thread
    • internet automation internet explorer macros vba
    • Replies: 0
    • Forum: Excel Questions
  19. Ombir

    VBA code stops midway after Interacting with Internet Explorer

    I was trying to help someone with automation of file upload via Internet explorer. I've compiled an Autoit script to upload the file. The problem is that code stops at media.click and ask for user interaction to select the file from Select file dialogue window. I want to execute Upload.exe...
  20. S

    Save file through Internet Explorer

    Hi guys, I am trying my hardest to figure out how I can save a pdf file on a website automatically. I have got to the point where I am prompted to Open/Save/Cancel the file. I want to be able to save the file automatically into a folder whose path is specified by a cell. Thanks for any help...
    • swarmo
    • Thread
    • internet explorer save file save pdf from website
    • Replies: 0
    • Forum: Excel Questions

We've detected that you are using an adblocker.

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.
Go back
Back
Top