Run a macro that would return a dataset from SQL into Excel

Hi all,

I am trying to figure out if there is a way to create a macro that would run a SQL statment on a database and that would return the result into Excel.The macro should have a nice dialog box where users enter the date parameter (dynamic parameter) and press ok to excute the macro.I am new to macros and VB and any help or suggestion would be greatly appreciated.Thanks a lot!

Blair

You wouldn't need to create a macro for only one parameter, have a look here -
http://superuser.com/questions/19745...rom-excel-2007

Yes I know about this option,I actually use it myself. But the solution I am after is based on the assumption that the worksheet will be used by end users that have very little experience in Excel.That is why i want to automate the whole process as much as possible so that the user will only have to enter the date and push a button to get the desired results.Thanks for your suggestion anyway,I should have explained myself better

Once it is set up, all the user needs to do is change the date in a given cell (it will then return the results) - I'm not sure you can really make it any easier?