i have vb code extracting data from a sql server to the excel sheet.
what i need to do now is have a box on the excel sheet to run the macro.. and when you click the box it should ask for a prompt of the too and from dates you want to run query the data.
the too are from dates i use in the query below are

2007-10-06 19:00:00 until 2007-10-13 19:00:00

i need to be able to input these into box on the main sheet and then that would substitute the dates into the code.

Anyone help?

the way i have it now is:

Please Login or Register  to view this content.