Transfer Spreadsheet
 

Hello All,
I have an Access macro that uses the Transfer Spreadsheet command to Excel
Before the macro runs, I have to delete the worksheet. In that file another
worksheet "master" contains references to the Access transfer worksheet, so
when I delete the Access worksheet, I get a #REF error in the master. Can
one refer to a worksheet that does not exist? If so, how do you phrase the
formula?

Or, must I copy the formulas back in from another file every time? The best
case would be for Access to overwrite the old worksheet, but I can't find
that command. Does anyone know the easiest solution? Hope this is clear -
thank you!!
:)