Hi everyone

I'm using the Write and Print statements to write out data from a
Excel spreadsheet to text files that need a very specific format.

When I have cell in the Excel spreadsheet which is a Date Type, th
format of the value is not written out the way I want it. I want th
output text file to look exactly the way it looks in the Exce
spreadsheet. I may have a cell formatted as "[hh]:mm:ss". But a cel
with "00:00:00" then looks like just "0" in the text file. And a cel
that looks like "-00:00:05" in the Excel spreadsheet shows up a
"-5.78703703703704E-05" in the text file..

How can I tell VBA to write out the cell value exactly as it appears i
the worksheet?

If I use "Save As" to save the file as a .csv file, it DOES print th
cell values exactly the way they appear in the cells. This is what
want. (Unfortunately, my text files also have to contain a bunch o
other formatting that the "Save As" function can not do, so I need m
own program to do it.)

Please let me know if you have any ideas.
Thanks!

Emm

--
embirat
-----------------------------------------------------------------------
embirath's Profile: http://www.excelforum.com/member.php...fo&userid=3720
View this thread: http://www.excelforum.com/showthread.php?threadid=57157

My bet is you're writing .value. Try writing .text.

mycell.value
is replaced with
mycell.Text



embirath wrote:

Hi everyone

I'm using the Write and Print statements to write out data from an
Excel spreadsheet to text files that need a very specific format.

When I have cell in the Excel spreadsheet which is a Date Type, the
format of the value is not written out the way I want it. I want the
output text file to look exactly the way it looks in the Excel
spreadsheet. I may have a cell formatted as "[hh]:mm:ss". But a cell
with "00:00:00" then looks like just "0" in the text file. And a cell
that looks like "-00:00:05" in the Excel spreadsheet shows up as
"-5.78703703703704E-05" in the text file..

How can I tell VBA to write out the cell value exactly as it appears in
the worksheet?

If I use "Save As" to save the file as a .csv file, it DOES print the
cell values exactly the way they appear in the cells. This is what I
want. (Unfortunately, my text files also have to contain a bunch of
other formatting that the "Save As" function can not do, so I need my
own program to do it.)

Please let me know if you have any ideas.
Thanks!

Emma

--
embirath
------------------------------------------------------------------------
embirath's Profile: http://www.excelforum.com/member.php...o&userid=37202
View this thread: http://www.excelforum.com/showthread...hreadid=571570

--

Dave Peterson

Ah.... Thank you!!!!!

I love when there are such simple solutions :-) :-)
Emma


--
embirath
------------------------------------------------------------------------
embirath's Profile: http://www.excelforum.com/member.php...o&userid=37202
View this thread: http://www.excelforum.com/showthread...hreadid=571570