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: 112
Default Merge csv file from many folders

I retrieve data from a cash register on a daily base. The data are saved as
follows: C:\dd_mm_yyyy\hh_mm\plu.csv

every day a different folder and subfolder is created with different date
(main folder) and different time(subfolder).

in the .csv file is not stored the date.

What i have to do: tell excel to go to the main folder get the date go to
the subfolder and get the file plu.csv and copy few data and return them in
an excel LIST copy the data say in col B and put the date in column A and
copy through the end of the list. second step back to the main folder (the
one of the day after) and do the same loop untill all the date are retrieved.
PS csv file are closed. i looked at ron debruin web site but i was not able
to get a solution

Thanks
Andrea
 
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 and pasting one file into several different folders james Excel Discussion (Misc queries) 2 May 12th 10 04:31 PM
how to open a file with a same name but in different folders excelbuff Excel Discussion (Misc queries) 1 January 31st 07 09:27 PM
List folders to file SS Excel Discussion (Misc queries) 13 August 28th 05 07:44 PM
need help importing photos from file folders wraithlead[_6_] Excel Programming 1 October 22nd 04 02:10 AM
Help on file and folders Please Aliandro Excel Programming 1 April 28th 04 10:29 AM


All times are GMT +1. The time now is 08:15 AM.

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"