I'm with MS Office 2013 32 Bit.
MS Excel column has its own naming system .
I wrote a simple function to make it.The 1st one is "A"
The 2nd one is "B"
...
..
.
The 16384th, the last, is "XFD"
Actually, I saw it somewhere in Internet (sorry, I forgot the source link. It is C#)
So, this code it just simple porting.
Code: Select all
Loop, 16384
myResult .= ExcelColumnNumberToName(A_Index) " "
FileAppend, % myResult, myFile.txt
Run, myFile.txt
Return
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
ExcelColumnNumberToName(x)
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
{
If(x < 1)
Return
Return ExcelColumnNumberToName(Floor((x - 1) / 26)) Chr(Mod(x - 1, 26) + Asc("A"))
}
Regards