How can I generate a code to print out a folder with word documents?

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?

I cant figure stapling out but you should be able to to set that be for you run the macro this might work for what you want/need for the print out

Please Login or Register  to view this content.

Hi Meabrams

Thank you very much for your help. However I have tried to run it and I am wondering if there are more parts I need to edit and personalise in the code in order for it to run and print the documents in the folder '2015 Approved'. Now the documents in THE folder are named "OCMRA 001" to "OCMRA 026". When I have run it by pressing F8 it does stop at 'Path = ActiveWorkbook.Path & "\" I think there is something I am doing wrong in trying to justify the code.

Thank you If you can help me that would be much appreciated