I have an excel spreadsheet that has 4 columns, 1st column has a serial number that automatically adds a new serial number under the last line used in column A when you open the spreadsheet. What I want to do is write the custom properties from an open drawing document into the next three columns and import the serial number from the spreadsheet (column 1) into the open drawing document, then save & close the excel spreadsheet. I have looked on-line & downloaded numerous macros to try and edit/alter them but have had no luck. I am working with Excel 2010 and SW2011, can anyone help?

Here are the requested files, I am only looking to export custom properties "MFG", the part number, and file location. As you can see this file drawing not have a custom properties "P_Number" value, I need to import that from the spreadsheet.