LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default I need help with VBA and a CSV file output

I am using Excel 2003 in XP Pro.

I am trying to export/saveas one tab from a workbook that contains one tab
and one column of data into a CSV file.

My data is in column A in multiple rows and looks like the following on each
row:
0,123456,0,0,99,0,0,0,0,0,0,0,0,0,5,11/11/2009,0,0,0,0,0,0,


I have everything working fine except for one large issue, excel adds " "
to the begining and end of each cell of data and looks like the following:
"0,123456,0,0,99,0,0,0,0,0,0,0,0,0,5,11/11/2009,0,0,0,0,0,0,"

These quotes are an issue for what this file will be used for. I know that I
can manually remove these later in the CSV file, but I want Excel to output
with out them. My CSV is being entering to a DB for fast entry and I need to
make this a very simple process. For the life of me I cannot get it to work.

I have tried adding a single ' quote to the begining in my vba. I have
formatted as text. I have tried using something recommended to me of CStr in
my code all to no joy. Can anyone help me on this? PLEASE!
--
Thanks,
David

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Output to .TXT-file? Charlotte E. Excel Programming 2 August 28th 08 07:54 AM
how can i output the file [email protected] Excel Programming 1 January 25th 07 05:14 AM
Open CSV file, format data and write output to a text file. BristolBloos Excel Programming 1 October 18th 05 03:50 PM
Output to a file? Kevin Burton Excel Programming 4 October 4th 05 03:57 AM
VBA help to output a file Paula Weill Excel Programming 2 September 20th 04 02:12 PM


All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"