Renaming PDFs in VBA

[trichmondcpa]

Found a lot of examples of how to rename PDFs using VBA. I did a nice detailed code using variables for the old name and then another column would have the new name. Kept getting "file not found error." By process of elimination I started to simplify and hardcode the file path, etc. to see what was the issue. I'm still a little shaky sometimes with VBA.

I eventually got to the point where even the simple command below gives me the file not found error. I even changes a letter in the new name thinking it couldn't overwrite itself.

Any hints or suggestions?

Name "C:\Users\richt\Downloads\1004-2868_001_010822_99R.pdf" As "C:\Users\richt\Downloads\1004-2868_001_010822_99R.pdf"

 

[Trebor76]

Hi trichmondcpa,

Welcome to MrExcel!!

The code works for me

If you copy the full path C:\Users\richt\Downloads\1004-2868_001_010822_99R.pdf and paste it into File Explorer does the pdf file open?

Robert