View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Braca[_2_] Braca[_2_] is offline
external usenet poster
 
Posts: 2
Default Rename files and save them as pdf

On Feb 10, 10:21 pm, "Rod Gill" <rod AT project-systems DOT co DOT nz
wrote:
Try recording a macro of you doing this manually. The recorded code will
give you a great head start.


Tried it already. Recorded macro will not show me the most important
part - how to extract the name of each subfolder and assign it to the
renamed text file, and how to do all that in a loop until the last
subfolder is reached.