Sounds like you're exporting from Access to Excel.

Try putting your data into a table in Access with either an Append, Update,
or Make-Table query, then in Excel use Data- Get External Data-New Database
Query to link to the data table your database. When you need to refresh the
spreadsheet, click the Refesh Data button on the External Data toolbox (or
Refresh All if you've set up multiple queries in this fashion).

Obviously, you'll have to run the Access query first to get fresh data into
the table, and the Access database must be closed before you try to refresh
the spreadsheet, or you'll get some strange error messages.

Alternatively, you can set up your Excel spreadhseet as a linked table in
your Access database, so when Access updates or appends data, it will also be
refreshed in Excel. This is a bit trickier.

HTH

"Deb Pingel" wrote:


When trying to transfer data from a Database on one drive to an Excel
Spreadsheet on a different drive in our system, the transfer is
creating a new tab in the destination spreadsheet. We want the
information to overwrite the info on the old worksheet every time the
macro is run. Since the worksheet (tab) does not have the correct name,
our formulas won't work. What is causing this and how do we correct it?
This works when set up within the same drive.


--
Deb Pingel
------------------------------------------------------------------------
Deb Pingel's Profile: http://www.excelforum.com/member.php...o&userid=20119
View this thread: http://www.excelforum.com/showthread...hreadid=556602