I need to have Excel run a database querry, prompting the user for
information.

The SQL that would be used is something a lot like this:
SELECT * FROM table18 WHERE (salesdate BETWEEN N'20050315' AND N'20050331')

I need to prompt the user for the year and month, preferrably with one
prompt, asking for the data in YYYYMM format, and then append the day number
to what is entered. How would I accomplish this?

Thank you.
Joshua