LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Convert multiple csv files into one excel file

Can anyone help me. I want to convert a number of csv files (all in the
same folder) into an excel file. I would like each csv to be a worksheet in
the excel file with the sheet name the same as the csv file name but without
the .csv file extension.

I guess it would be easy if I was prompted for which folder I want to use as
source as I have to do this over and over again!!

--
Chris Lewis


 
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
Convert multiple excel files with multiple sheets to PDF - how? Phil J W Excel Discussion (Misc queries) 3 November 5th 09 02:16 PM
Convert one .csv file to multiple excel files singh Excel Discussion (Misc queries) 1 October 9th 07 01:02 AM
How do I convert pdf files into an Excel file JED Excel Discussion (Misc queries) 0 August 29th 07 12:54 AM
Convert Multiple CSV Files to XLS Files (Again) Dave Excel Discussion (Misc queries) 1 July 11th 07 04:43 PM
convert word files to excel file ghalayma Excel Programming 0 January 20th 04 07:15 PM


All times are GMT +1. The time now is 10:42 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"