When trying to transfer data from a Database on one drive to an Exce
Spreadsheet on a different drive in our system, the transfer i
creating a new tab in the destination spreadsheet. We want th
information to overwrite the info on the old worksheet every time th
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 Pinge
-----------------------------------------------------------------------
Deb Pingel's Profile: http://www.excelforum.com/member.php...fo&userid=2011
View this thread: http://www.excelforum.com/showthread.php?threadid=55660