How to Not Minmize Access Window When I Go to Excel

Hello,
I run the same query on a database but with different dates for each
run. After each run I key-in the results to an excel spreadsheet.
This works fine. What happens though is the Access window minimizes
each time I go to the excel spread sheet. I then have to expand the
access window, run the query, key-in the data to excel and repeat. Is
there a way to keep the Access window open and not minimize each time
I go to the spreadsheet?

Thanks.

JBEsr

Hi, JB,

Why not use the built-in Excel functionality to
automatically load your data? Try Menu: Data- Import
External Data-New Database Query; and put your
query there? You can return whatever columns you need
directly into Excel.

It's also possible to set your varying date into a cell
and use VBA to pass the date into the database. (Code is
available if you want to try it)

jeff
-----Original Message-----
Hello,
I run the same query on a database but with different
dates for each
run. After each run I key-in the results to an excel
spreadsheet.
This works fine. What happens though is the Access
window minimizes
each time I go to the excel spread sheet. I then have
to expand the
access window, run the query, key-in the data to excel
and repeat. Is
there a way to keep the Access window open and not
minimize each time
I go to the spreadsheet?

Thanks.

JBEsr
.

Thanks Jeff I will try that.
Would you send me the vba code you referred to. I do use macros, but
I am limited pretty much to the macro recorder and what others have
graciously provided.

JBE Sr.





(JB) wrote in message . com...
Hello,
I run the same query on a database but with different dates for each
run. After each run I key-in the results to an excel spreadsheet.
This works fine. What happens though is the Access window minimizes
each time I go to the excel spread sheet. I then have to expand the
access window, run the query, key-in the data to excel and repeat. Is
there a way to keep the Access window open and not minimize each time
I go to the spreadsheet?

Thanks.

JBEsr