create calener code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top