View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ajtessy ajtessy is offline
external usenet poster
 
Posts: 1
Default Search files and copy with destination on file

I have a worksheet with the following:
ColumnA ColumnB ColumnC
*total*.* C:\douments c:\total_cost
*puchases*.* C:\douments c:\purchases_cost
*sales*.* C:\douments c:\salesl_cost.

What I want is a macro to search for the files(with the wildcard) in column
A in source folder (Column B) and copy all files found into destination
folder (column C). Kindly help !!!!!