doevents

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

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

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

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

<!--[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/>...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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