Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default how to import .csv to excel

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 258
Default how to import .csv to excel

Hi Greg,

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

Regards,
Ivan

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
import XML data...Is there a size limit on the import? MatthewG Excel Discussion (Misc queries) 0 February 10th 09 05:57 PM
How do I import my fill color table from Excel 2003 into Excel 200 jmn13 Setting up and Configuration of Excel 0 September 11th 08 10:23 PM
How to Start Excel in Text Import Wizard for data import rlelvis Setting up and Configuration of Excel 0 July 10th 08 08:40 PM
Data Import to Excel Issue with Excel 2007 and Excel 2003 on same Melsh Excel Discussion (Misc queries) 0 August 1st 07 09:32 PM
Import modules EXCEL caused an invalid page fault in EXCEL.EXE Janet Martin Excel Programming 6 August 1st 04 10:25 AM


All times are GMT +1. The time now is 04:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"