writing to csv file

Results 1 to 2 of 2

Thread: writing to csv file

  1. #1
    Join Date
    Dec 1969

    Default writing to csv file

    I&#039;m using opentextfile to open a .csv file. I&#039;m then writing values to the file seperated by commas. The first value is 011 but when it writes it, it gets saved as 11 because the csv file believes its numeric.<BR>Is there away to define the cells of the file as text before writing?<BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: writing to csv file

    If you&#039;re using Scripting.FileSystemObject.OpenTextFile, then it won&#039;t interpret your data in any way.<BR><BR>It has no idea that you&#039;re writing "cells".<BR><BR>I&#039;m afraid this looks like something else converting "011" to "11". <BR><BR>Craig.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts