YTL Excel #115: Time Delayed Formula TODAY & IF functions

Hi,

I need my macro to run itself on a time delay. Is it possible to set it up to do this repeatedly so if I left the programme running it would automatically update every minute?

I have a countdown timer add in but haven't managed to successfully incorporate it. Any help or ideas would be appreciated.

Thanks,

Phil

Hi,

Does anyone know how I could make a macro run automatically every minute or so without prompting? I have tried various methods with a countdown timer but haven't had much success. Any help or ideas would be appreciated.

Thanks in advance,

Phil

I have a VBA code which displays Text from emails by looking at various folders in Outlook. I would like to have a Delayed Pause before it moves onto the next folder. Is it possible to create a Delayed Pause Break. The Delayed Pause should fit in 'PAUSE' as below:

or j = 1 To mailBox.Folders.Count
If (mailBox.Folders(j) = Sheet1.Cells(folderIndex, 1).Value) Then

Set actionFolder = mailBox.Folders(j)

For Each Item In actionFolder.Items
If (Item.UnRead) Then
Dim subjectSplit As Variant

subjectSplit = Split(Item.Subject)
Sheet1.Cells(folderIndex, 2) = subjectSplit(2)
Sheet1.Cells(folderIndex, 3) = subjectSplit(3)
Item.UnRead = False
End If
Next Item

'PAUSE'
End If
Next j

I have a date that tickets were opened, and I want to calculate a realtime number of how long the ticket has been opened (in hours) based on the system clock or the real time at that time.

Can anyone help?

I am running Excel 2003 on a brand new HP laptop with 2GB Ram and 250GB hard drive (which is more empty than full), running Vista Home Premium.

Excel 2003 has an long delay when clicking page preview, or setup in page preview and sometimes in just inserting rows or columns.

This didn't happen in XP.

Are there any options that can be changed in either Excel or Vista that will reduce this delayed response?

Any help would be most appreciated as I seem to live in Excel!

Hi there,

I've set up a worksheet with a VBE-script that tells to send an email via my Outlook upon certain conditions. That works fine.

However, I want to insert a delay (i.e. 30 days) in the sent e-mail just like you can do in Microsoft Outlook in the message options dialog box by checking the "Do not deliver for ..." checkbox. How can I utilize this "Do not deliver for ..." functionality in VBA?

Hopefully you brilliant people have any suggestions

Below is my script for sending an email from excel

Code:

 
Sub SendMail()
Dim OutApp As Object
Dim Outmail As Object
Dim strBody As String
Set OutApp = CreateObject("Outlook.Application")
OutApp.session.logon
Set Outmail = OutApp.CreateItem(0)
strBody = "Test"
On Error Resume Next
With Outmail
    .To = "test@test.com" 'change "test@test.com" into "yourownmailadres@mail.com" to make the macro really work
    .CC = ""
    .BCC = ""
    .Subject = "Test - No Reply - Automatic mail"
    .Body = strBody
    .Send
End With
On Error GoTo 0
Set Outmail = Nothing
Set OutApp = Nothing
End Sub

I have an equation can't quite figure out. Will take advice on how to setup
if I am on wrong track. Trying to get a running average over a 2 day period
(if can? using same 2 cells for each subsequent day for input, in same row).

For now example is in column format.
cell E4, enter number: 2
cell E5, enter: =AVERAGE(OFFSET(B5,-E$4+1,0,E$4,1))
and drag down a few rows.
in cell B5 "down", can put sequential numbers: 1, 2, 3, 4...

The above works as intended. What I need is to only use 2 cells in "B"
column, so equation only goes back 1 day? you get it..

Equation dragged down shows 3 results, before #DIV/0!
Example: need to put Input for, monday, in 1st cell (B5), tues in cell B6,
BUT wed uses cell B5. Is that possible?
Result needed is for a 2 day average: "Up" or "Down" to show in 1 cell.

Don't know where to start on equation. Do I need something like TODAY(), or
will a minus 1 somewhere work..
Other idea was a 5 day & WEEKDAY / WORKDAY, would be nice to figure out, but
may be more days than can use now.
Thanks for Help...

Hello,
We have a user that keeps getting an Write -Delayed Write Failed error. I've tried running all of the office updates for her,restoring the document, saving the document to the desktop first, and saving it back to the network. We also, tried deleting a lot of data to decrease the file size from 4.80MB. None of this worked. Does anyone know how to fix this issue?The only thing I have not tried is to run an excel repair.

This isnt your typical email request, in this case I would like to set a Calendar event for a list of users with a reminder (Series) in OutLook.

Has anyone tried this, is it possible?

Cross posted:
http://www.microsoft.com/office/comm...60b&sloc=en-us

Is it possible to use a today or now function in an sql query to an external datasource in excel 2007?

I have an excel 2007 spreadsheet, that I have linked to our financial database (MySql) using the database wizard. I can get the tables to display in excel no problem. One table shows how much staff have billed in each invoice period. I would like to create a query in excel, so that when this table displays in excel it shows how much each staff member has billed for the current invoice period, as opposed to all of them.

We weren't sure how to do this, so we decided to do a query to pull out the current invoice period, then we could combine this pivot table with the one for the amount billed table to give a table showing the amount each staff member has billed in the current invoice period (do this bit in excel).

The problem is we can't seem to make the query to pull out the current invoice period work. We have tried the query below, and all the variations of it that we can think of

SELECT invoice_period FROM tbl_invoice_periods WHERE STR_TO_DATE('" & NOW() & "', '%d/%m/%Y') BETWEEN start_date AND end_date;

We have also tried referencing a cell which shows the current date, but we cannot get this to work either (we may have made a mistake in the query here, we are not entirely sure how to reference an individual cell). The only way we have been able to get it to work is if you enter the current date directly into the query, but obviously this means it's no longer automated, which isn't a solution.

We can't really see where we have gone wrong, and wondered if anyone had any suggestions. The only thing we did think may cause a problem is that the dates in the database are in the format yyyy-mm-dd.

Any ideas will be gratefully received.
Thanks