application.wait

I have below code, which is not working as expected. What I want is to wait a code for 2 sec before going to another line, but when I run the code, it shows in VBA window as running and does not do anything except when I press "ESC" from keyboard, and code runs in one go without waiting for 2...

I have a code to fill in multiple PDF files from data in an excel sheet. It gets data from the first row and fills in the pdf and saves it. Then I need it to go to each line and fill in a new pdf and save it. When it creates the first pdf and saves it, a preview of the pdf comes up. Then the...

Hi there. My code is running and generating the necessary timestamps to viewership data from a YouTube link, however I can't seem to get the viewership to copy and print. Any help to extract this information from the YouTube code would be much appreciated. Thanks Here is a link as an example...

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

i have the following code below..im trying to auto download a file from web then save it to a specific location..however the last part of my code doesnt work.. i highlighted it in RED. thanks. Sub Downloadfile() Dim ie As Object Dim TempFileName As String Dim ProfileID As String...

hello all, New to this, found a random tutorial online, tried to alter it do it be useful to me. Im getting error mentioned in title. Please advise Option Explicit Sub PDFTemplate() Dim PDffldr As FileDialog Set PDffldr = Application.FileDialog(msoFileDialogFilePicker) With PDffldr...

Afternoon All, I have the following Macro for the sample Table below. I would like the Macro to loop until it reaches the end of the table, at the moment i have the shortcut entered at the end but this requires me to be infront of the computer at all times to end the macro by pressing ESC...

I have some code that runs flawlessly on my computer, but when i try it on a co-workers computer, the new IE window opens up in the background and the sendkeys lines of code dont work. Any ideas on why it works on mine but not theirs? I have searched and tried just about anything i could think...

Hello, I am having trouble coming up with a macro that searches google based on a cell value, then returns the Google review score. I tried modifying the below code to suit my needs but keep getting a Run-time error 91 Object variable or With block variable not set. Any help would be greatly...

Hello everyone, I try to figure out how to get a value (id) from a website url. I've created a table with 2 columns, name and id. I've filled the name column (95 rows) and try to get the id from the website url. The code below does function (i'm sure it could be done better, but i don't have...

Hi, Im using this code below but im stuck in the loop until i press ESC. Can someone help me write into this code that it stops when ESC is pressed Sub rrrr() Do button24hr Application.Wait Now + TimeSerial(0, 0, 5) BUTTONNOW Application.Wait Now + TimeSerial(0, 0, 5)...

Hello everybody. I'm struggling with scraping data from the web with sendkeys method. I'm now in a situation where, apparently SendKeys "^c" works but SendKeys "^v" has not effect. I mean: at the end of the failing macro, if I manually do ctrl+v, in sheet 3 cell A1 appears what I've copied...

I'm creating an automated sheet for a rather rude colleague and as a bit of fun I've made it so if she types an incorrect value in a table, the table then flashes red and blue like police lights, I want to have a pop-up box that informs her the value is incorrect but the issue is this interrupts...

Hi Everyone, I have this code to import data from a PDF to Excel Sheet. The problem is it imports all the data as one column is there something im missing ? anyone know of a way to import from a pdf and have it look the same? here my code Sub PDFinport1() Dim wsLog As Worksheet, wsOutp...

Hi All and HNY2019 Is there simpler and cleaner way to code this to make the Status Bar appear to flash? Sub StatusFlash() Do Until c > 5 Application.StatusBar = "Setting up - " Application.Wait (Now + TimeValue("00:00:1")) Application.StatusBar = "Setting up -...

Hello, I am really going to do my best to explain this problem I am having, Also I have searched this site and others found nothing but maybe I am searching with the wrong terms. I have a main workbook that uses several other workbooks to save/archive information, several of the operations...

On my Excel spreadsheet: web address is in B, username in C, password in D, UN ID in E, PW ID in F, Button ID in G, land page (to go to after logged in) in H. Right click triggers below macro for that particular row. Succeeds in opening address in B, however not seeing log in credentials being...

Am I doing it correctly ? x = Shell("D:\A-Sides\doit.bat", vbNormalFocus) 'wait for bat to finish Application.Wait (Now + TimeValue("0:00:10")) The wait is working but Doit.bat doesn't run. Is something else needed?

Hi all, can anyone help with the below? I can't get it to repeat the code but I don't know why. 'START LOOP HERE Do Until Sheets("Sheet1").Range("A4").Value = "" Set mytextfield = IE.document.all.Item("txtJobNo") mytextfield.Value = Sheets("Sheet1").Range("A4").Value 'Next 'Press submit...

I have an Excel 2016 VBA macro that changes the "Office Theme" under: File>Account>Office Theme; to the next theme. This macro should work as when I try and perform the macro's sequence of actions manually the sequence of actions is successful in changing the "Office Theme" - would anyone might...