Search results

Thank you very much for your help, much appreciated :)

oooh I could kiss you on the head lol! Yes it works! Excel stays open however, with just a blank screen, is it possible to actually totally quit excel from an Access command, such as application.xlapp.quit as a guess?

So you mean in Access - add the line to close the excel application? What would the code for this be? And also for setting the excel application to nothing, would this be something like set xlapp = nothing? Thanks Gary

Hi I have an Access button which runs 3 exports of queries to 3 seperate pages in an existing Excel file. This works fine. What i wanted to do was have Access send the data from the 3 queries to an Excel template file automatically but it seems its easier for Excel to do this. So the...