Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dear experts:
I got 80 single ods-files (created by Excel but then saved as ods- files). They are all stored in the following directory: C:\Graphics\ The file naming convention of these 80 single ods-files is as follows: Martin_Graphics_10.ods Martin_Graphics_12.ods Martin_Graphics_16.ods ..... Martin_Graphics_100.ods The folder C:\Graphics contains 80 subfolders where all these files are to be copied into. Their naming is as follows: Chapter_10_ready (C:\Graphics\Chapter_10_ready) Chapter_12_ready (C:\Graphics\Chapter_12_ready) Chapter_16_ready (C:\Graphics\Chapter_16_ready) .... Chapter_100_ready (C:\Graphics\Chapter_100_ready) Now here comes my question: Is it possible to copy these files into their respective folder, using VBA? The numbers are not incremented by 1 but irregular, but they are sorted. So are the folders where the files should be stored. Any professional help would be much appreciated. Thank you very much in advance. Regards, Andreas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy files in sub folders to a specific directory | Excel Programming | |||
Copy Excel files from sub-folders but restricted to one level | Excel Programming | |||
Can excel automatically create folders | Excel Discussion (Misc queries) | |||
Files\folders in VBA | Excel Programming | |||
Open files in different folders | Excel Programming |