Search results

Hi I have whacked together a code from my limited knowledge to run some queries using parameters in a table then export the query results onto excel with different sheets. However I am getting an error message 'Item not found in this collection'. I believe it has to do with not being able to...

Thanks RKay I will give it a go.

Hi I am very new to visual basic and require some serious help. I have an Access database with 10 queries set up. I have some code to run these queries and automatically populate excel. The 10 different queries need to go on 10 different sheets in excel. There are currently 10 functions in...