dear sir,
is their any code which can create an TABLE / QUERY containing all the days
of the
current year like from 1/1/07 to 31/12/07
code will be coded from an access form to perform on excel

In A1 enter:
1/1/2007
In A2 enter:
=A1+1
copy A2 to A3 thru A365
--
Gary''s Student - gsnu200757


"balu" wrote:

dear sir,
is their any code which can create an TABLE / QUERY containing all the days
of the
current year like from 1/1/07 to 31/12/07
code will be coded from an access form to perform on excel

dear sir
its an good idea
but kindly advise me how to do it by writing the code from an access form
like first create an excelobject and worksheet and on the excelshhet
xlsheet.range("a1").value = 1/1/2007
xlsheet.range("a2").value = 2/1/2007
furher how to copy the formula for 365 cells
is autofill will help how ?
kindly advise
i will be lucky if i know how to create such table of 365 days in access
please

"Gary''s Student" wrote:

In A1 enter:
1/1/2007
In A2 enter:
=A1+1
copy A2 to A3 thru A365
--
Gary''s Student - gsnu200757


"balu" wrote:

dear sir,
is their any code which can create an TABLE / QUERY containing all the days
of the
current year like from 1/1/07 to 31/12/07
code will be coded from an access form to perform on excel