How would one do that, anyone know? If I record the macro manually, I
of course just get a specific date only. Thanks.

In your recorded macro, change the date to the word Date, that is VBA for
today's date.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"StargateFan" wrote in message
...
How would one do that, anyone know? If I record the macro manually, I
of course just get a specific date only. Thanks.

On Tue, 29 Mar 2005 13:18:29 +0100, "Bob Phillips"
wrote:

In your recorded macro, change the date to the word Date, that is VBA for
today's date.

I must have done something wrong.

I tried that this morning and my original recorded macro looks like
this:

Selection.AutoFilter Field:=11, Criteria1:="2005.05.06.Fri"

I then changed the actual date to the word "Date" so that macro looks
like this:

Selection.AutoFilter Field:=11, Criteria1:="Date"

I get a filtered result of zero. No records show up even there are 3
with today's date.

I removed the customized date format to Excel's regular one and still
this happened. What did I do wrong, pls?

Tx. :oD

don't put it in double quotes

Selection.AutoFilter Field:=11, Criteria1:=Date

--
Regards,
Tom Ogilvy


"StargateFan" wrote in message
...
On Tue, 29 Mar 2005 13:18:29 +0100, "Bob Phillips"
wrote:

In your recorded macro, change the date to the word Date, that is VBA for
today's date.

I must have done something wrong.

I tried that this morning and my original recorded macro looks like
this:

Selection.AutoFilter Field:=11, Criteria1:="2005.05.06.Fri"

I then changed the actual date to the word "Date" so that macro looks
like this:

Selection.AutoFilter Field:=11, Criteria1:="Date"

I get a filtered result of zero. No records show up even there are 3
with today's date.

I removed the customized date format to Excel's regular one and still
this happened. What did I do wrong, pls?

Tx. :oD

On Fri, 6 May 2005 07:56:56 -0400, "Tom Ogilvy"
wrote:

don't put it in double quotes

Selection.AutoFilter Field:=11, Criteria1:=Date

--
Regards,
Tom Ogilvy

Woops. Thanks!

"StargateFan" wrote in message
.. .
On Tue, 29 Mar 2005 13:18:29 +0100, "Bob Phillips"
wrote:

In your recorded macro, change the date to the word Date, that is VBA for
today's date.

I must have done something wrong.

I tried that this morning and my original recorded macro looks like
this:

Selection.AutoFilter Field:=11, Criteria1:="2005.05.06.Fri"

I then changed the actual date to the word "Date" so that macro looks
like this:

Selection.AutoFilter Field:=11, Criteria1:="Date"

I get a filtered result of zero. No records show up even there are 3
with today's date.

I removed the customized date format to Excel's regular one and still
this happened. What did I do wrong, pls?

Tx. :oD

On Sat, 14 May 2005 02:34:35 -0400, StargateFan
wrote:

On Fri, 6 May 2005 07:56:56 -0400, "Tom Ogilvy"
wrote:

don't put it in double quotes

Selection.AutoFilter Field:=11, Criteria1:=Date

Tom, hi. This didn't work and I'm wondering why. The macro looks
like this now:

Sub TestDueTODAY()
' Macro recorded 5/14/2005 by .
'
Selection.AutoFilter Field:=10, Criteria1:="<"
Selection.AutoFilter Field:=10, Criteria1:=Date
End Sub

Does the difficulty lie with the formatting of the date? Although I
enter with ^+; to get today's date, the cell format is in
ddd.mmm.dd.yyyy so it's easier for the user to read. Does the problem
lie there?

I get values, of course, with the < filter entry. I've tried the
above macro with just each line and the < works fine. The Date one
doesn't. (p.s., the column here is a different one that the trial I
was using before. I have the actual file with me now and that's why
it's a 10 here instead of an 11 like before, but that part's okay).

Tx.


Woops. Thanks!

"StargateFan" wrote in message
. ..
On Tue, 29 Mar 2005 13:18:29 +0100, "Bob Phillips"
wrote:

In your recorded macro, change the date to the word Date, that is VBA for
today's date.

I must have done something wrong.

I tried that this morning and my original recorded macro looks like
this:

Selection.AutoFilter Field:=11, Criteria1:="2005.05.06.Fri"

I then changed the actual date to the word "Date" so that macro looks
like this:

Selection.AutoFilter Field:=11, Criteria1:="Date"

I get a filtered result of zero. No records show up even there are 3
with today's date.

I removed the customized date format to Excel's regular one and still
this happened. What did I do wrong, pls?

Tx. :oD

Dates, VBA and autofilter don't always work nice.

But since you know the format of the cell, this might work ok for you:

Selection.AutoFilter Field:=10, Criteria1:=Format(Date, "ddd.mmm.dd.yyyy")

(It worked for me.)

StargateFan wrote:

On Sat, 14 May 2005 02:34:35 -0400, StargateFan
wrote:

On Fri, 6 May 2005 07:56:56 -0400, "Tom Ogilvy"
wrote:

don't put it in double quotes

Selection.AutoFilter Field:=11, Criteria1:=Date

Tom, hi. This didn't work and I'm wondering why. The macro looks
like this now:

Sub TestDueTODAY()
' Macro recorded 5/14/2005 by .
'
Selection.AutoFilter Field:=10, Criteria1:="<"
Selection.AutoFilter Field:=10, Criteria1:=Date
End Sub

Does the difficulty lie with the formatting of the date? Although I
enter with ^+; to get today's date, the cell format is in
ddd.mmm.dd.yyyy so it's easier for the user to read. Does the problem
lie there?

I get values, of course, with the < filter entry. I've tried the
above macro with just each line and the < works fine. The Date one
doesn't. (p.s., the column here is a different one that the trial I
was using before. I have the actual file with me now and that's why
it's a 10 here instead of an 11 like before, but that part's okay).

Tx.


Woops. Thanks!

"StargateFan" wrote in message
. ..
On Tue, 29 Mar 2005 13:18:29 +0100, "Bob Phillips"
wrote:

In your recorded macro, change the date to the word Date, that is VBA for
today's date.

I must have done something wrong.

I tried that this morning and my original recorded macro looks like
this:

Selection.AutoFilter Field:=11, Criteria1:="2005.05.06.Fri"

I then changed the actual date to the word "Date" so that macro looks
like this:

Selection.AutoFilter Field:=11, Criteria1:="Date"

I get a filtered result of zero. No records show up even there are 3
with today's date.

I removed the customized date format to Excel's regular one and still
this happened. What did I do wrong, pls?

Tx. :oD

--

Dave Peterson

On Mon, 16 May 2005 07:52:21 -0400, StargateFan
wrote:

On Sat, 14 May 2005 02:34:35 -0400, StargateFan
wrote:

On Fri, 6 May 2005 07:56:56 -0400, "Tom Ogilvy"
wrote:

don't put it in double quotes

Selection.AutoFilter Field:=11, Criteria1:=Date

Tom, hi. This didn't work and I'm wondering why. The macro looks
like this now:

Sub TestDueTODAY()
' Macro recorded 5/14/2005 by .
'
Selection.AutoFilter Field:=10, Criteria1:="<"
Selection.AutoFilter Field:=10, Criteria1:=Date
End Sub

Does the difficulty lie with the formatting of the date? Although I
enter with ^+; to get today's date, the cell format is in
ddd.mmm.dd.yyyy so it's easier for the user to read. Does the problem
lie there?

I get values, of course, with the < filter entry. I've tried the
above macro with just each line and the < works fine. The Date one
doesn't. (p.s., the column here is a different one that the trial I
was using before. I have the actual file with me now and that's why
it's a 10 here instead of an 11 like before, but that part's okay).

Tx.

[snip]

Was wondering if anyone knew why the Date feature wouldn't bring up
entries with today's date. There are entries there, I make sure to
add some in the test file. Tx.