Auto-Populate Excel Document - Workflow

I have since worked this out. Very similar to my Microsoft Word Document.

I create an Excel Template and attach as a "Template" to a Document Library.

I then "Create Columns" in my Library Settings and these become "Document Properties - Server".

A workflow carried data from my Jobs list into the Risk Assessment Document Library.

Not as easy as Microsoft Word's Quick Parts - Document Properties from SharePoint, I have to use Macros to draw the data from the Document Properties. As these are not actual typical Document Properties the Excel Coding I use is something like this:

"

Sub SharePointProperties()
Dim WB As Workbook
Set WB = ThisWorkbook

With WB.Sheets("Site Hazard Check list")

.Range("C8").Value = WB.ContentTypeProperties("Access on to and within site")
.Range("D8").Value = WB.ContentTypeProperties("Access on to and within site (Details)")
.Range("F5").Value = WB.ContentTypeProperties("Site Manager")

"

Once this code runs, all cells are pulling the Document Properties they've picked up from SharePoint. MY code then deletes the module so once the Contractors get this document there are no macros, no code, just data in cells.

Im sure there are other ways do this, my lazy playing about with different ideas has worked out in the end though, this is the easiest way I have seen online. I could not do the others.