how to import .csv to excel

G

Guest

I.m trying to import from a .csv file with 8 columns of data into an excel
spreadsheet. The positions in the .csv string have to be shuffled around a
little. For example, string position 1 needs to import to column 5 in excel.
I would be grateful for some help with the code.

Many thanks
 
I

Ivan Raiminius

Hi Greg,

import the .csv file, turn on macro recorder and rearange the columns.

Regards,
Ivan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forcing Excel to Import .CSV data 2
Automate Excel export to a CSV file 1
import csv data in excel using vb 1
User select folder name 1
copy recordset to CSV file 1
Access Importing csv daily files into access 2007 1
import multiple CSV files into one Excel file 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1

Top