hello,
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:
Bookmarks