Loop through alphabet 3

[UnsolvedCoding]

I am supposed to be making a way to go into workbooks on a drive that all end in a letter of the alphabet.

What would be nice is if there is a way to increase the letter of the alphabet for each loop. Making a number increase by one is easy, but nothing found indicates how to increase the alphabet by one.

Ideas?

 

[mintjulep]

chr()

 

[SkipVought]

Hi,

Check out the ASCII character values and the Chr() function.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Burser]

Dim iChar as Integer
For iChar = 65 To 90
    Debug.Print Chr(iChar)
Next iChar

ASCII and you shall recieve. (Fnah fnah)

 

[SkipVought]

THREE replys in the space of TWO minutes, lead by mintjulep, was certainly NOT an ascot.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[UnsolvedCoding]

Thanks!