ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy/paste from file (https://www.excelbanter.com/excel-programming/342060-copy-paste-file.html)

nc

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.

Ron de Bruin

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.





All times are GMT +1. The time now is 03:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com