ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   create calener code (https://www.excelbanter.com/excel-discussion-misc-queries/166519-create-calener-code.html)

balu

create calener code
 
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




Gary''s Student

create calener code
 
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




balu

create calener code
 
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





All times are GMT +1. The time now is 09:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com