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

The main folder, say c:\main contains subfolders c:\main\one, c:\main
\two..., and in each of these subfolders there is one text file named
summary.txt.

The macro needs to:

1. get the summary.txt from each folder
2. rename the file to the name of the subfolder from which it was
opened
3. convert/print renamed file to a pdf file with the same name, e.g
one.pdf, two.pdf...
4. save pdf file to the specified folder, say c:\renamedfiles

Can you please suggest the code?