Hi Steve, I'm not an excel expert but I believe something like this should work.
Dim i, name i = 1 Do While i < VBAProject.ThisWorkbook.Worksheets.Count name = VBAProject.ThisWorkbook.Worksheets.Item(i).Name loop On 7/4/07, Steve Onnis <[EMAIL PROTECTED]> wrote: > > Can anyone tell me a way to return a list of work sheets from an excel > file? > > Steve Onnis Director / Head Developer > > [EMAIL PROTECTED] > > +61 3 9001 2258 > > 0401 667 996 > > www.inevative.com.au > <http://www.novahost.com.au> <http://www.threesquares.com.au> > <http://www.smsonline.com.au> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
<<inline: phone.jpg>>
<<inline: inevativeLogo_small.jpg>>
<<inline: email.jpg>>
<<inline: web.jpg>>
<<inline: novahost.gif>>
<<inline: smsonline.gif>>
<<inline: threesquares.gif>>
<<inline: mobile.jpg>>
