Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to process first row.
How do I change the setup in my spreadsheet or change the code below
so that the first row of the spreadsheet is processed. If I run this code now it starts out with row 2. Thanks. Sub ScratchMacro() 'Set Reference to "Microsoft DAO 3.51 (or 3.6) Object Library". Dim db As DAO.Database Dim rs As DAO.Recordset Dim i As Long Set db = OpenDatabase("C:\Book1", False, False, "Excel 8.0") Set rs = db.OpenRecordset("SELECT * FROM `mySSRange`") 'Loop through each recordset. While Not rs.EOF For i = 0 To rs.Fields.Count - 1 MsgBox rs.Fields(i).Value Next i rs.MoveNext Wend 'Clean up. rs.Close db.Close Set rs = Nothing Set db = Nothing End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to automate process | Excel Discussion (Misc queries) | |||
If/then Process? | Excel Discussion (Misc queries) | |||
How to count process running time ( process not finished) | Excel Programming | |||
How to count process running time ( process not finished) | Excel Programming | |||
step into process | Excel Programming |