"Dan T" .(donotspam) wrote in message
...
I'm writing a routine to write to a test file. I've had two suggestions;
delimiter=Char(9). This gives me an invalid function all. And;
Const DELIMITER As String = CHR(9), this gives me an error of "Const
expression required"
It does not seem to be accepting the chr(9) or the char(9) as a valid
literal to set the delimiter to.
Any ideas why?

Hi Dan,

The first instance is the one you want, but you have the function name
spelled wrong. It's Chr not Char. You can't use the results of a function to
create a constant, so the second option will not work.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *