PDA

View Full Version : Change pdf name



preseb
08-16-2011, 01:02 PM
I use a Vba code to pull files from a specific location and email them out. is it possible to use vba through excel to go to a specific location and name of a file and change the name?

so if my files were located on: C:\test files
and i had a list of pdf's called: test_Part1.pdf, test_Part2.pdf, test_Part3.pdf, etc. can I change test_Part1 to be: finance.pdf
test_Part2.pdf to be sales.pdf
test_Part3.pdf to be manufacturing.pdf

Kenneth Hobs
08-16-2011, 02:13 PM
Use Name().