Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
nc nc is offline
external usenet poster
 
Posts: 119
Default Copy/paste from file

I have a few csv files in a folder. I would like to copy the data from all
the files in that folder and paste them on one sheet in a workbook using
macros.

Any help will be appreciated.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Copy/paste from file

Start here nc

This example is for xls files
http://www.rondebruin.nl/copy3.htm

FNames = Dir("*.csv")



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


"nc" wrote in message ...
I have a few csv files in a folder. I would like to copy the data from all
the files in that folder and paste them on one sheet in a workbook using
macros.

Any help will be appreciated.



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
Copy, paste without file name referenced after paste AusTexRich Excel Discussion (Misc queries) 6 September 23rd 08 02:57 AM
Protecting a file from Copy/Paste ReportSmith Excel Discussion (Misc queries) 2 July 20th 07 06:38 PM
How can I allow only copy of a file not cut and paste? fernwood Excel Discussion (Misc queries) 1 October 4th 06 01:59 PM
copy/paste from one file to another without file name reference slvrblt Excel Discussion (Misc queries) 4 February 6th 05 08:57 PM
Copy/Paste to file of same name Otto Moehrbach[_6_] Excel Programming 12 January 18th 04 02:29 PM


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