I process a lot of documents that are all formatted the same. I need to rename the documents using the information contained within particular cells. Here is an example of the documents I work with:





For this example, I need to name the file 25891245 VENDER NAME IC 72-31-03-900-005. This information changes from document to document, but will always be in the same cell.

I do this all day, every day. I'm curious if a Macro can be written that will grab the information from those specific cells and save the document accordingly.

Any help from you would be greatly appreciated.