1. K

    Web Scrapping - Download PDF after submitting Policy

    I want to download the PDF file after pressing "Continue" with below code... ================================Code========================= Sub automaticformfilling() Dim ie As Object Set ie = CreateObject("internetexplorer.application") '1 GoTo website With ie .Visible =...
  2. K

    VBA Help

    Can anyone help with the below code. I keep getting an error of "This will cancel a pending data refresh. Continue?" even though all the tables have updated and then when the save happens I am getting a box to ask if I want to save changes. I thought what I had below would just save the...
  3. H

    Web-Scraping Selecting Dropdownlist in website

    After button element "ContentPlaceHolder2_btnSearch" is click, element "cbSite_I" returns to blank. I want element "cbSite_I" to have value "Cát Lái" after element "ContentPlaceHolder2_btnSearch" is click. Pls kindly help me accordingly. Thanks. Visible Text on websit : Button : "Search"...
  4. S

    General Macro Assistance Request

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...
  5. Johnny C

    How do I return focus to Excel after copy to Powerpoint?

    I've written some code to copy charts and ranges to Powerpoint. Powerpoint can't be saved and closed at the end. How do I get focus back to Excel after the final paste? here's the code. I've tried a few things at the end. 'First we declare the variables we will be using Dim ppApp As...
  6. Johnny C

    Excel VBA - copying range to Powerpoint crashes Powerpoint instantly

    This isn't a question, I resolved it after a morning googling and watching Powerpoint stop working. I thought it might help someone else. We have large PPs with a financial forecast (say 60 slides) and large workbooks (100 sheets) that feed them. They go through multiple iterations through...
  7. J

    Get Website Login

    Hi, found this code to get the html coding box for username, password when i run get the error: compile error Next without for, please help. code: Private Sub GetWebsiteInfo() On Error Resume Next Dim ie As Object Set ie = CreateObject("InternetExplorer.Application") ie.navigate...
  8. ExcelNooberino

    HTML Macro to print documents

    Hello everyone! So I've come up with the idea of trying to create a macro that allows me to open a few PDF documents from a intranet website here in the company I'm currently working in. The code below is what I have so far, and it's working perfectly but, I need to sort the table by one of the...
  9. W

    Code doesn't work unless delay is added

    Hi all, I can't wrap my head around this. I have a userform that will resize frames and listboxes based on the number files in the folder. However the resize doesn't work unless I input either 'DoEvents' or 'Wait' into the code. The code is in the form and not in a separate module. Private...
  10. A

    select given value from dropdown list and click to add button

    I can login on my website then then navigate to a web page where I need to select a value from a drop down box then need to click on add button. (using <code style="margin: 0px; padding: 1px 5px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit...
  11. A

    add value in textbox in webpage using vba

    i am new to this forum. please solve my below query. i want fill text box with my given value and click on search button. i cant provide the url as it will not work outside the office. i tried but getting object dose'nt support propery error and method. text box inspect element is : <input...
  12. A

    need to click search button on webpage but dont have button id, class name or any value

    I am new to this forum ... please solve my below problem: i want to click search button to open new page where i can search but i am unable to click the search button as only button name is given in inspect element code. below is the element code.<code> <button type="button"...
  13. steveuk87

    IE browsing and user field manipulation

    Hi All, I have the following code: Sub NewTest() Dim IE As Object Set IE = CreateObject("InternetExplorer.application") With IE .Visible = True .navigate ("my website") While .Busy Or .readyState <> 4: DoEvents: Wend...
  14. steveuk87

    IE browsing and user field manipuilation

    Hi All, I have the following code: Sub NewTest() Dim IE As Object Set IE = CreateObject("InternetExplorer.application") With IE .Visible = True .navigate ("my website") While .Busy Or .readyState <> 4: DoEvents: Wend...
  15. W

    Calling a function inside a sub routine

    Hello friends, After several searches on google, it looks that MrExcel is the best place to get VBA Excel help. I am trying to login to different websites automatically. The goal is create a function that will handle all repetitive tasks inside the sub routine, so the code for each different...
  16. L

    VBA - Click menu button in Frame

    Good Afternoon, I am new to this forum and also very new to VBA. For the past few weeks I have been trying to automate pulling data from a company webpage with no luck. I have got as far as logging on to the webpage, navigating a dealer select drop down and onto the main dashboard. The bit i...
  17. Y

    VBA Web Form filling works but values not recognized by website

    Hi guys I'm new here and struggling with online form automation. My task is to use this website to generate IBAN codes: I have all the necessary data listed in a Database. Done a lot of research and managed to fill the form, but, even though correct, the...

    Ie loading but code is not vba is not resuming

    Dear team the below code is written to open a URL and post comments. when i run the code the URL is opening and a debugg is comming mentioning "run time error 91" ( object variable or block variable is not set). if i open the code and press F5 then the code is resuming correctly. below is my...
  19. R

    Enter data into webpage

    Hi, I am getting "Automation Error, The object has disconnected from clients" error while i am trying to enter the data in webpage. Here is the code, Sub GetIE() Dim objIE As InternetExplorer Dim OrgBox As HTMLInputElement Set objIE = New InternetExplorer objIE.Visible = True...
  20. S

    Problem while filling a web form

    I am new to VB and tried this code to fill a web form and it did not work (ie the web opened but was unable to fill in the fields) . Can some one please help me ...plssss. Following is the code: Private Sub IE_Autiomation() Dim IE As Object Set IE =...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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
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 "".
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