If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
How to Not Minmize Access Window When I Go to Excel
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 . |
#3
|
|||
|
|||
How to Not Minmize Access Window When I Go to Excel
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 |
Thread Tools | |
Display Modes | |
|
|