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

This might give you a good starting point

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

--
Don Guillett
SalesAid Software

"JulieD" wrote in message
...
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

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

"Don Guillett" wrote in message
...
This might give you a good starting point

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

--
Don Guillett
SalesAid Software

"JulieD" wrote in message
...
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

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.

--
Don Guillett
SalesAid Software

"JulieD" wrote in message
...
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

"Don Guillett" wrote in message
...
This might give you a good starting point

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

--
Don Guillett
SalesAid Software

"JulieD" wrote in message
...
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

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

"Don Guillett" wrote in message
...
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.

--
Don Guillett
SalesAid Software

"JulieD" wrote in message
...
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

"Don Guillett" wrote in message
...
This might give you a good starting point

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

--
Don Guillett
SalesAid Software

"JulieD" wrote in message
...
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