View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DStrong DStrong is offline
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