N
Nik
I'm using Excel as a flat database for my website data file, and a VBA
routine to output the html pages for me. So far, so good.
I came across some strange behaviour last night, which I had to use an
ugly hack to get around - the weirdness is demonstrated by:
Sub printError()
Dim MyNumber As Integer
MyNumber = 3*7
Debug.Print "This thing is "; MyNumber; "mm long"
End Sub
This will print "This thing is 21 mm long". In the code I'm outputting,
the space between the number and the following letters is invalid.
I've since discovered that declaring MyNumber as a string will still
allow me to set it to the value of a calculation(?!), and that the space
is then omitted.
Any ideas why this would be?
TIA
Nik
routine to output the html pages for me. So far, so good.
I came across some strange behaviour last night, which I had to use an
ugly hack to get around - the weirdness is demonstrated by:
Sub printError()
Dim MyNumber As Integer
MyNumber = 3*7
Debug.Print "This thing is "; MyNumber; "mm long"
End Sub
This will print "This thing is 21 mm long". In the code I'm outputting,
the space between the number and the following letters is invalid.
I've since discovered that declaring MyNumber as a string will still
allow me to set it to the value of a calculation(?!), and that the space
is then omitted.
Any ideas why this would be?
TIA
Nik