Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Save and rename | Excel Discussion (Misc queries) | |||
How do I rename files that are related. | Excel Discussion (Misc queries) | |||
Help to rename files | Excel Worksheet Functions | |||
Rename Excel Files | Excel Programming | |||
Rename Files | Excel Programming |