CSV file delimiter

  • Thread starter Thread starter Vinay
  • Start date Start date
V

Vinay

Hi,
I have written one VBA macro which saves Excel files into .csv format.When I
import this csv file into text file then it shows comma separated values.Is
it possible to set the the delimiter while saving the csv file in VBA code ?
I want to set delimiter as ";".

Plz suggest me.

regds
vinay
 
Hi vinay

Excel uses the character you have defined in
the system Regional Settings control panel as the 'List Separator'
character.

But if you rename your .csv file to .txt, then do File|open within excel, you'll
have control on what the delimiter is and how each field should be treated.
 
Back
Top