View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rod Gill Rod Gill is offline
external usenet poster
 
Posts: 9
Default Rename files and save them as pdf

Try recording a macro of you doing this manually. The recorded code will
give you a great head start.

--

Rod Gill

"Braca" wrote in message
oups.com...
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?