EXPORT MARCO - PDF DWG and REV Management

So i been working a macro to speed up some data entry,  for the production side of our operations, and have produced this marco.

it export drawing file, and file the old version into superseded folder (that was a fun problem) , along with checking if a file is open ,

it also update an excel workbook to grab a job number and does basic data entry to , along with grab and saving production,  in the required folder and drop in basic info about the product.

have a look and tell me what you think, i know i gotten a bit lazy about near to the end, it does need a rewrites in places  

SolidworksApi macros