PDF to PDF using VBA, the purpose is to change the name of PDF

[adekinteristi]

Hy all

i have this code

Please Login or Register  to view this content.

this is to convert word to pdf

what i want to ask is, can it modify convert PDF to PDF?
the purpose is to change the file name for many file in instant

or maybe any other quick way?

thanks in advance

i attached some sample

[macropod]

You don't use code anything like that to rename a file. Try:

Please Login or Register  to view this content.

[adekinteristi]

that's work
thanks, but the original file is gone too?

[bakerman2]

What exactly are you trying to achieve ?
Do you want to rename the converted files in column E (pdf-files) ?

[adekinteristi]

if possible, the new name in the diffrent folder and still have the old pdf file

[macropod]

the original file is gone too?

Well, you did say:

the purpose is to change the file name

[macropod]

If you want to make a copy of the file, change:
If Dir(OldName, vbNormal) <> "" Then Name OldName As NewName
to:
If Dir(OldName, vbNormal) <> "" Then FileCopy OldName, NewName

[adekinteristi]

well then, sorry that's my fault
thank you so much

[bakerman2]

Put new filenames (including new path)in column F.

Please Login or Register  to view this content.