Need to know how to export a range to csv file

Asked By gabrielleriya 0 points N/A Posted on - 01/28/2013

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

Answered By Lerson Suzanne 0 points N/A #196565

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)

Questions
5

Answers
23

Best Answers
6

I need to find a low priced tool for censoring videos