Hi guys, just a quick one if possible.

I have a macro that opens word prints out a template then closes word, but it always asks whether i want to save the word doc, i just want it to close word withouit saving. Is there a bit of code to add to do this?

The code I have at the moment is as follow:

Set wdApp = New Word.Application
wdApp.Visible = True
wdApp.Documents.Open Filename:="C:\Documents and Settings\bh\Desktop\StockLabel.dot"
wdApp.Run "PrtLbl"
wdApp.Quit - this is where I want it to quit without saving
Set wdApp = Nothing
Thanks people!!