Looping through all records in excel?

Wrox Programmer Forums

		Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Pro VB 6
Looping through all records in excel?

Pro VB 6 For advanced Visual Basic coders working in version 6 (not .NET). Beginning-level questions will be redirected to other forums, including Beginning VB 6.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

July 26th, 2005, 03:18 PM

dhl365

dhl365 is offline

Registered User

Join Date: Jul 2005

Posts: 2

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Looping through all records in excel?

How can I loop through all records in an Excel spreadsheet similar to when using the recordset object?

You know, like:

While Not rs.EOF
rs.MoveNext
Wend

Can this be done with an Excel spreadsheet in VB6? Thanks.

dhl365

Old

July 26th, 2005, 03:39 PM

dhl365

dhl365 is offline

Registered User

Join Date: Jul 2005

Posts: 2

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Nevermind. I found the solution on another post. Thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
skipping records while looping	stealthdevil	Access VBA	3	October 26th, 2006 10:22 AM
Looping through subform records	V	Access VBA	8	April 20th, 2004 08:10 AM
Looping through Excel Workbooks collection	clickco	Excel VBA	0	April 14th, 2004 12:21 PM
where is cursor after looping through records?	monstermash	Classic ASP Basics	7	July 22nd, 2003 03:55 AM
looping through return records in sproc	jtyson	SQL Server ASP	5	July 14th, 2003 10:16 AM