Export specific columns in different order without header to csv

**w2kbug** · 06-24-2014, 03:56 AM

Hello,

right now i´m struggling with some csv-export-problems.

I want to export some columns of my worksheet to a csv-file. But i don´t want to export all of them, i just need for example: Columns B, D and G and inside the csv-file they should be in an different order like G, B, D .

Maybe someone can help me with this problem.

I already thought about using "union" to select the specific columns, but i can´t get this to work.

I would really appreciate your help with this problem!

Thank you in advance and with best regards
w2kbug

**davesexcel** · 06-24-2014, 04:21 AM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**w2kbug** · 06-24-2014, 04:42 AM

myWS.xlsm

CSV_rxport.csv

I uploaded a workbook and have an "before" and "after" sheet. The "after"-sheet looks like the csv should look like after the export. The uploaded csv-file is an example of my csvfile-macro included in the workbook.

there are 2 macros inside the sheet,"csvfile" and "csvfile2". the first one is working and able to export all data in the table. The "csvfile2" is the one i´m "working" with, but this is the one that i can´t get to work.
if someone wants to test the macro, you need to update the "target-directory" inside the macro, it uses the users desktop, but not dynamically (so you need to insert your name instead of my placeholder-letters inside the path)

if i can / should provide further informations, please leave a message. I´ll do my best to reply as quickly as i can.

Thank you in advance :-)