delay

Hi guys. I'm trying to loop through a table to send several emails at once with a delayed delivery for each email. The code works great up until I get past for first loop. When I run the code, it displays the first email just like it should, but none of the other emails come up. The weird...

Hello, I am trying to see if it is possible to create an intentional delay when executing a macro. Basically I would like to pause the macro for 5 seconds and then continue with the rest of the code. Is such a thing possible with Excel? Thanks, Andrew

Hello, I have a daily worksheet where the grand total sales will carry from day to day. (cell B3) in cell B2 I put in the new grand total amount that I got from my register report. With that put in, B6 calculates the total sales for the day (B2-B3). My problem with this, is that until a...

I have this performing the tasks needed, however when ever data is changed or the file is saved, Excel takes 30-60 seconds to complete the task. I'm sure there is a more effcient way of performing the same task, but I'm at a loss. I've linked to an example with 50 rows of fake data to...

Hi Everyone, I can't seem to get a time delay to work. I thought it wouldn't be too difficult but all i want to do is: as part of a macros that is triggered by a calculation result equalling 1, at first cell A4 = 0 and then at the end of the macros, after a 10 second pause cell A4 = 95. Why...

So I've created an Excel workbook to start and stop an external stopwatch and automatically copy the time to Excel, and everything works perfectly except the Stop function. Half the time it activates and the other half it doesn't. I used the ALT+TAB VBA SendKeys command which works fine, but...

I am working on writing a VBScript to run an excel macro only if a particular file exists in a specified directory. If the file does not exist, I would like the script to wait 10 minutes and check for the file again. Ideally, this script would continue running until a file is dropped into the...

I am trying to refresh the data or wait for the formulas to calculate before going to, Next Help Sub Update() Range("AU2").Select Dim cl As Range For Each cl In Range(Cells(2, 47), Cells(60000, 47)) Select Case cl.Value Case "s" if_s Case "b" if_b End...

Hi! I am using Sendkeys for Hyperion Planning Excel Add-In User Interface in order to automate retrieving data from the database. Sometimes the UI is too slow and I'd need a little pause between Sendkeys commands. The most helpful solution was provided by TsTom year 2003 in this Forum, see...