N/APosted on - 01/28/2013
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.
Need to know how to export a range to csv file
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)