alpha counter?

J

JulieD

i want to process quite a large amount of data so i want to run the macro
for all records starting with A, then run it again for B & C & ... Z

how can i loop so it works through the alphabet on its own?

Cheers
JulieD
 
D

Don Guillett

This might give you a good starting point

Sub doalphabet()
For i = 65 To 90 Step 1
MsgBox Chr(i)
Next
End Sub
 
J

JulieD

Hi Don

sorry what i need to do is open up 350 excel spreadsheets & copy one field
from them .. i have code to cycle all the files in a directory but i don't
want to do them all in one hit .. so what i want to do is process all the
files beginning with a & then save the workbook as a.xls then do the b and
save it as b.xls & then c ...
but i was trying to avoid having to type out a select statement that went
through all the letters of the alphabet and was wondering if there was a
short cut way of doing it.

Cheers
JulieD
 
D

Don Guillett

If you ran what I gave you, you will see
a, b, c, d, etc.
Then you can incorporate that into a loop and have another loop within to do
what you want.
 
J

JulieD

Hi Don

1000 apologies - was exactly what i was looking for ... didn't really read
it the first time :(

thanks for your assistance.

Regards
JulieD
 
Top