Share via

VBA Macro

Anonymous
2019-02-17T14:22:29+00:00

Hello,

I have a very simple question but still it gives me error. Need help.

The case is like -- I have a folder with PDF files named as 1,2 3,4,5....and so on.

I have a excel sheet with the names that are inside the PDF files, I mean the PDF files need to renamed according to the cell values of the excel sheet.

I need a macro that atomically picks up the cell value in the excel sheet and renames the PDF's accordingly.

There are a lot of codes on the web but those are very long and complex. 

Thanks 

Saroj

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-02-17T23:59:20+00:00

    Hi Saroj

    This will sort you problem

    Please check this links from Kamal Girdher

    xtremeexcel

    Published on 19 Dec 2016

    https://www.youtube.com/watch?v=9PPVWGJUtZ4

    Download file with macro here

    https://github.com/kamalgirdher/xtremeExcel/blob/master/FileNameChanger.xlsm

    Is very good and will definitely sort you query.

    Please Click question answered if so.

    Thanks

    Regards

    Jeovany CV

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments