G
Geoff E
I am having trouble converting an integer to text. I need to place a
leading zero next to the number when it is less than 10.
Trying to change this:
Print #1, "<html><title>pic" & i & "</title>"
To this:
Print #1, "<html><title>pic" & TEXT(i,"00") & "</title>"
does not work because the "TEXT" function is not a VBA function.
Any suggestions greatly appreciated.
Geoff
leading zero next to the number when it is less than 10.
Trying to change this:
Print #1, "<html><title>pic" & i & "</title>"
To this:
Print #1, "<html><title>pic" & TEXT(i,"00") & "</title>"
does not work because the "TEXT" function is not a VBA function.
Any suggestions greatly appreciated.
Geoff