Thank you for the help I have had in the past, however I have another problem trying to write a module. I have a macro that runs four queries that open in separate excel workbooks, one after the other. What I have been trying to write is a simple module that will then save and close the spreadsheets in templates to be used at a later time. At present you have to click save and close manually and I don't really want that to be the case. The code I am presently trying, and isn't working is
[Public Function SaveChanges()
appExcel.Workbooks("G:\Databases\Working Copies\SC\ASC\ASC Template.xls").Close SaveChanges:=TrueEnd Function]
I have tried different ways posted on the net but no-one seems to be trying to do exactly what I want and I dont seem to get the right combination of coding.
Any hlp would be greatly appreciated.