Re: How to activate the Query parameters toolbar

I had the same problem. My solution was to run the query with starting and
ending dates. I then replaced the dates with variables. Unfortunately, the
query often broke accross the dates so that I had to re-query doing things
in a different order. Remember, the Select statement is a string. You need
to add quotes when you are separating out the dates as variables. HTH

Kim

"Alvaro Montoya" <amontoya@sawtek.com> wrote in message
news:0f4c01c33ce1$8d6a2dc0$a301280a@phx.gbl...
> I'm writing a macro for retreiving data from a database.
> But I want the query to be limited by a starting date and
> an end date wich are typed in two different cells.
> Excel's Help tells I can do it by using the Query
> Parameters option of the External Data toolbar, but this
> option is deactivated and I can't make it active.
> If I can do this, I'll ask the VBA editor to record the
> macro and it will be done. If anybody can tell me how to
> do it by code, it will fine also.
>
> Thank you guys, wherever you are.
>
> Regards from Costa Rica, land of beaches, sun and girls.
>