View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
krumme krumme is offline
external usenet poster
 
Posts: 1
Default How to export a range to CSV

Hi

I am fairly new to VBA programming, however I feel confident that
something like this should be possible.

I want to create a script that exports a range selection in Excel 2007
to a CSV file (data.csv) using comma as field separator.

I have no problem making the selection and everything, my problem is
how to get the export working with the comma separator. My Excel uses
semicolon as default!

I really hope you can help me?

Thanks!