Changing File Names

[Kaval]

Is there a way to change the name of a file from within
an Excel VBA macro?

I have a number of pdf files in a directory that I want
to rename automatically from my excel macro.

Any ideas?

Regards, Kaval

 

[Dave Peterson]

Take a look at Name Statement in VBA's help.

Name "C:\my documents\myPDF1.pdf" "C:\my documents\MyPDF2.pdf"

 

[JE McGimpsey]

Look at SaveAs in XL/VBA Help.

 

[JE McGimpsey]

Disregard - I missed the "PDF"