wisdom2004
08-31-2008, 05:40 PM
Hello,
I am new to this forum and this my first post.
I have 5 queries : qry1, qry2, qry3, qry4, qry5, before i used the macro to export the data to excel in one spreadsheet using the transferspreadsheet. now i can't; because in each query there is a field added which is field date, and each time i run one query it will prompt me to type the start date and end date. i would like to have a way to prompt me one time for all the queries and save it in one spreadsheet and worksheet for each query with today's date, per example i want the spreadsheet will benamed report083108. how can i do that.
I am new to this forum and this my first post.
I have 5 queries : qry1, qry2, qry3, qry4, qry5, before i used the macro to export the data to excel in one spreadsheet using the transferspreadsheet. now i can't; because in each query there is a field added which is field date, and each time i run one query it will prompt me to type the start date and end date. i would like to have a way to prompt me one time for all the queries and save it in one spreadsheet and worksheet for each query with today's date, per example i want the spreadsheet will benamed report083108. how can i do that.