litlmike Posted June 14, 2007 Share Posted June 14, 2007 (edited) My goal is to take today's date and put it into an excel file (this I can do), and then go to the next row and add 1 to the date, doing this for 365 days. So starting today, I should have 06/14/2007 through 06/14/2007, one in each row. The problem is the only way I can think to do this is to create a rule for every month because every month has a different number of days in it. So I would have to +1 to todays date, until the Day is =30, then I would have to +1 to the Month, and do that 12 times. Though it would work, it seems ridiculous, it seems that there would be a way to just +1 to today's date and loop that. (i.e. February would be +1 to the Day until Day=28, then +1 to the Month) Sorry, my help file does not work, and I am sorry if this is in the help file already. Thanks. #include <ExcelCOM_UDF.au3> For $iCC = 1 To 365 _ExcelWriteCell($oExcel, @MON & "/" & @MDAY & "/" & @YEAR, $sRangeOrRow, $iColumn) ; Date $sRangeOrRow += 1 WEnd Edited June 14, 2007 by litlmike _ArrayPermute()_ArrayUnique()Excel.au3 UDF Link to comment Share on other sites More sharing options...
GaryFrost Posted June 14, 2007 Share Posted June 14, 2007 look at _DateAdd SciTE for AutoItDirections for Submitting Standard UDFs Don't argue with an idiot; people watching may not be able to tell the difference. Link to comment Share on other sites More sharing options...
litlmike Posted June 14, 2007 Author Share Posted June 14, 2007 look at _DateAddAhhh... that sounds good. Since my Help File is broken, and since those UDF's cannot be found in the Online Documentation, could you provide me with the Syntax for _DateAdd .Thanks _ArrayPermute()_ArrayUnique()Excel.au3 UDF Link to comment Share on other sites More sharing options...
Mast3rpyr0 Posted June 14, 2007 Share Posted June 14, 2007 heres the html file from the help file in attachments. My UDF's : _INetUpdateCheck() My Programs : GameLauncher vAlpha, InfoCrypt, WindowDesigner, ScreenCap, DailyRemindersPick3GeneratorBackupUtility! Other : Bored? Click Here! Link to comment Share on other sites More sharing options...
litlmike Posted June 14, 2007 Author Share Posted June 14, 2007 heres the html file from the help file in attachments.You are awesome.. thanks! _ArrayPermute()_ArrayUnique()Excel.au3 UDF Link to comment Share on other sites More sharing options...
evilertoaster Posted June 14, 2007 Share Posted June 14, 2007 http://www.autoitscript.com/autoit3/docs/In case you didn't know... Link to comment Share on other sites More sharing options...
Helge Posted June 14, 2007 Share Posted June 14, 2007 http://www.autoitscript.com/autoit3/docs/In case you didn't know...since those UDF's cannot be found in the Online DocumentationHe obviously knew.@litlmike : You can find it in online beta-docs though : http://www.autoitscript.com/autoit3/files/...ns/_DateAdd.htm Link to comment Share on other sites More sharing options...
Mast3rpyr0 Posted June 14, 2007 Share Posted June 14, 2007 oh lol well glad it helped litlmike My UDF's : _INetUpdateCheck() My Programs : GameLauncher vAlpha, InfoCrypt, WindowDesigner, ScreenCap, DailyRemindersPick3GeneratorBackupUtility! Other : Bored? Click Here! Link to comment Share on other sites More sharing options...
litlmike Posted June 14, 2007 Author Share Posted June 14, 2007 (edited) He obviously knew.@litlmike : You can find it in online beta-docs though : http://www.autoitscript.com/autoit3/files/...ns/_DateAdd.htmI had no idea the beta helpfiles were online... ;(But thanks for letting me knowhttp://www.autoitscript.com/autoit3/files/beta/autoit/docs/ Edited June 14, 2007 by litlmike _ArrayPermute()_ArrayUnique()Excel.au3 UDF Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now