Hi guys

Basically I have a folder on this path :

G:\HEALTH AND SAFETY\1 HEALTH AND SAFETY MANAGEMENT SYSTEM\4- RECORDS\4.2 OCM RECORDS\RAMS\RISK ASSESSMENTS\RISK ASSESSMENTS\2015 Approved - Site Mock

I have created a button in excel and I am looking for a way to run a code that when I click it will print out all of the documents in the folder and staple them well. Once it is all done everything stays the same and the same process gets repeated once every quarter.

The only drawback I can say at the moment is that the word documents are linked to one master word document that populates all the other pages. This means that everytime I open the word document you have to action the dialogue box that asks whether you want the document to be updated and thats always a yes and I am trying to find a way to stop that from popping up.

Is getting VBA to print possible?