Copy and rename PDF files

Hi All,

I was wondering if someone could help; I have a PDF file called Original.PDF and then a excel spreadsheet with 2 columns. The first is called class e.g. 10sxAC the second is called Name e.g. Chris Smith, there are about 400 entries. What I want to do is use this spreadsheet to automatically create a copy of the Original.PDF and rename them using the class and name so the resulting PDF file will be called something like "10SxAC-Chris Smith"

I have seen discussions about this but not too sure how to go about it, I have good understanding of excel and a little understanding of macros (But cant write my own)

Many thanks for any help

Olly

Try this macro

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007.