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