Jen
Have a look here
http://www.dicks-clicks.com/excel/Ex...htm#Parameters
and here
http://www.dicks-clicks.com/excel/Ex....htm#ChangeSQL
--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com
"Jen" wrote in message
...
Hello,
I have an Excel spreadsheet that uses MS Query to pull
data from a SQL database. Each month the user has to go
in to each separate query (there are 12) to enter the
appropriate date range. I'm looking for ideas on how to
automate this. Either have a pop-up box where they enter
the date one time, or somehow have the queries refresh
with the most current month end. I need some ideas on
where to even begin. I know a little VBA, but only from
recording my macros and then editing the code. I've never
coded from scratch.
Any ideas would be great!
Thanks!
Jen