Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy and pasting one file into several different folders | Excel Discussion (Misc queries) | |||
how to open a file with a same name but in different folders | Excel Discussion (Misc queries) | |||
List folders to file | Excel Discussion (Misc queries) | |||
need help importing photos from file folders | Excel Programming | |||
Help on file and folders Please | Excel Programming |