View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
pieros pieros is offline
external usenet poster
 
Posts: 32
Default Text replacement with VBA Excel in several files

Here is an example of the path: "C:\Documents and
Settings\Desktop\Temp\TEST TemplateOntw"
In this folder there are several subfolders named: "Cop00005000" ,
"Cop00013000" and more.
In these subfolders are the files located with the text to be replaced;
some filenames are "00005008_001_KART_V1.fmt",
"00005008_001_KART_V2.fmt", "00005194_001_ACET_V1.fmt" and so on.
The text to be replaced is located in only the "KART" files.

Gr.,
Pieros