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