doevents

  1. J

    VBA to wait untill first refresh finishes then continue the second refresh

    Hi guys, I have a report that needs to be refreshed twice before I can work on other stuff. So what I usually do is go to Data - > Refresh All Then once the first refresh is completed, I press Ctrl+Alt+F5 to refresh for the second time. Its refreshing multiple power queries with multiple...
  2. 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 =...
  3. 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...
  4. 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"...
  5. 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/>...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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"...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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: https://iban-generator.appspot.com/#/make 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...
  19. NARAYANAN

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

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