Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting/copying files from a folder using VBA
Hi all,
I have a folder (i.e. c:\current) that contains around 5000 csv files, and I have a list of around 200 off these files that I need to copy and paste to a new folder i.e. (c:\new). Rather than find each file manually or use the search function, is there a way i can tell vba to search through c:\current for the filenames that I specify and then copy and paste them to c:\new? Any help would be much appreciated. Kind Regards, Bhupinder. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling pdf files from general folder to specific folder | Excel Discussion (Misc queries) | |||
copying data from folder to folder | New Users to Excel | |||
Copying Cells from CSV files in folder into one worksheet | Excel Discussion (Misc queries) | |||
Copying all files in a folder to new folder | Excel Discussion (Misc queries) | |||
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) |