Producing Records on a given date
 

This may sound lazy, but it will help me a great deal. I am quite new
to all this but am having some succes in learning, this site has been
massively helpful to me, and am continually grateful to all the great
advice people give.
My problem is that I have an excel spreadsheet, which sits in my
directory, it contains a list of orders that are due in and the
ammounts all orders have a due date field on them.
Would it be possible for excel to check the file for orders that are
due in that day, and then produce a list telling me what is coming in.
If anyone has any idea how to do this it would be great.

Producing Records on a given date
 

Data = filter=autofilter

Filter the due date column on today's date

Print.

--
Regards,
Tom Ogilvy


"fee" wrote:

This may sound lazy, but it will help me a great deal. I am quite new
to all this but am having some succes in learning, this site has been
massively helpful to me, and am continually grateful to all the great
advice people give.
My problem is that I have an excel spreadsheet, which sits in my
directory, it contains a list of orders that are due in and the
ammounts all orders have a due date field on them.
Would it be possible for excel to check the file for orders that are
due in that day, and then produce a list telling me what is coming in.
If anyone has any idea how to do this it would be great.

Producing Records on a given date
 

Thanks Tom

But I would like it more automatted than that so that when you open it.
It produces what is to be checked that day automatically, sorry never
explained that to well. Or if possible could it produce the list
without opeing the spreadsheet, like a work to list.

Producing Records on a given date
 

Excel code must be hosted in an open workbook to run. Either that book or
another.

the workbook_open event in the thisworkbook module can be used to fire code
when the workbook is opened and the user does not disable macros.

the steps I described can be done with a macro and the code can be obtained
by using the macro recorder while you perform the actions one time manually.

http://www.cpearson.com/excel/events.htm

You can access an excel workbook as a database

http://www.erlandsendata.no/english/...php?t=envbadac

so this can be done from any application/programming language that supports
using ADO.

--
Regards,
Tom Ogilvy


"fee" wrote:

Thanks Tom

But I would like it more automatted than that so that when you open it.
It produces what is to be checked that day automatically, sorry never
explained that to well. Or if possible could it produce the list
without opeing the spreadsheet, like a work to list.

Producing Records on a given date
 

Thank you will try that