Need to know how to export a range to csv file

Asked By 0 points N/A Posted on -
qa-featured

Hi,

I'm quite a novice in visual basic for application programming.

I'm trying to create a script which exports a range selection in Microsoft excel 2007 to a CSV file applying comma as a field separator.

I don't understand how to get the export working with the comma separator.

Need to have a solution. 

Thanks 

SHARE
Answered By 0 points N/A #196565

Need to know how to export a range to csv file

qa-featured

To export a range to CSV file, these are the steps:

1. Select the range, then applying this utility by clicking Enterprise > Import/Export > Export Range to File.

2. Go to Export Range to File dialog box then check CSV(Comma delimited) which is under the File Format.

     Under CSV file options, you need to specify the following options:

     1.1. Save the actual value which display the actual values of the final file, and

             Save values as shown onscreen which display the values in the final file as the same you read them on computer                       screen.

      1.2. Open the file after export which automatically open the file after exporting the range.

3. Click OK. (note: you must specify the name and location to export range)

Login/Register to Answer

Related Questions