ermilemerson Posted July 3, 2009 Share Posted July 3, 2009 Guys may i know how to generate numbers (1-infinity) in a column in ms excel using autoit? e.g. A 1 2 3 4 5 5 6 7 8 9 10 11 . . . . . 10000 Thanks Link to comment Share on other sites More sharing options...
Minikori Posted July 3, 2009 Share Posted July 3, 2009 Guys may i know how to generate numbers (1-infinity) in a column in ms excel using autoit?e.g.A12345567891011.....10000ThanksIf this is what I'm thinking... Look in the help file at For...Next loops and do that with typing the variable then sending down and repeat. For those who are asking questions, look in the help file first. I'm tired of people asking stupid questions about how to do things when 10 seconds in the help file could solve their problem.[quote name='JRowe' date='24 January 2010 - 05:58 PM' timestamp='1264381100' post='766337'][quote name='beerman' date='24 January 2010 - 03:28 PM' timestamp='1264372082' post='766300']They already have a punishment system for abuse.[/quote]... and his his name is Valik.[/quote]www.minikori.com Link to comment Share on other sites More sharing options...
Malkey Posted July 3, 2009 Share Posted July 3, 2009 Try this. A modified example from help file. ; *************************************************************** ; Modified Example 1 - Write to a Cell after opening a workbook and returning its object identifier. Then Save and Close file ; ***************************************************************** #include <Excel.au3> Local $oExcel = _ExcelBookNew();Create new book, make it visible For $x = 1 To 100 _ExcelWriteCell($oExcel, $x, $x, 1);Write to the Cell Next ;MsgBox(0, "Exiting", "Press OK to Save File and Exit") ;_ExcelBookSaveAs($oExcel, @TempDir & "\Temp.xls", "xls", 0, 1); Now we save it into the temp directory; overwrite existing file if necessary ;_ExcelBookClose($oExcel); And finally we close out ; 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