Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Import multiple csv files into current workbook as separate sheets

hi Santosh

Also Is there any simple way to interactively get the name of the
directory from user ?


See how I do it in this macro
http://www.rondebruin.nl/windowsxpzip.htm#Browse

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Santosh" wrote in message oups.com...
Thank you Ron. It works great.

Also Is there any simple way to interactively get the name of the
directory from user ?

Thank a lot.

Santosh



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
Auto saving sheets from a workbook as separate files. Colin Hayes Excel Worksheet Functions 2 May 18th 10 06:50 PM
Automated multiple text files into multiple sheets in one workbook Dr Dan Excel Discussion (Misc queries) 14 November 4th 07 11:32 AM
workbook sheets into separate files markx Excel Worksheet Functions 1 June 28th 05 04:02 PM
How do I save sheets in a workbook to separate files? Omzala Excel Worksheet Functions 2 January 13th 05 06:23 PM
Import several txt files into separate sheets within 1 workbook Steve[_56_] Excel Programming 0 January 15th 04 10:31 PM


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