Writing to file

[sparx]

I am running code in vba that is using the Write command, and I am creating a text file that is delimited by * and is also fixed width. After every line, there is a separate delimiter which is the semi-colon. But the problem I have is that by default, quotations get added at the beginning and the ending of every line. My question is, is there any way to remove these quotation marks when writing the file?

Here is a sample of the outputted file:

"*99*000001*CP000000*08*0000000323120* ;"

Any help would be greatly appreciated,

Thanks,

Erik

 

[Shadez]

This is beacuse you are using the Write method,

Try using the Print method instead.

ie

Print #1,"Some text to print"

this does the same job but without the ""

 

[sparx]

It's funny how things can be just too simple, thanx for your help.

 

[Shadez]

The simplest problems are the hardest to find

Good luck M8