Rk,
The Text Write Program at
http://www.smokeylake.com/excel/text_write_program.htm will do
that for you interactively (no code required, though you could copy the code into your own
macro if you wanted to. Set"Bracket all fields" to yes.
--
Regards from Virginia Beach,
Earl Kiosterud
www.smokeylake.com
Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Rk" wrote in message
...
hi , does anyone know how to out put data from a excel spread sheet so it is
in the following format
in spreadsheet 1 2 3 4 5
output
"1","2","3","4","5"
tried .csv but that is just 1,2,3,4,5
--
thanks