View Single Post
  #15   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

Hello KL,
I've tested this code with the F8-function key and now I have seen that
the lines 'LSet txt = "305"' and the next line are being jumped over.
The program jumps to the line 'End If' and again to 'Next nRec'. There
did nothing change in the files.
I'v here an example from a piece of text from my text file:

Width = 52;
Height = 52;
Cut = Off;
Thickness = 1.70;

YOffset =10;
MaxHeight = 503;

Shift(1,-1)

The meaning is to change the text 503 (in all files with filenames
containing KART) in the text 305.

Regards,
Pieros