This is being called elsewhere, but it fails at the transferspreadsheet. The rest of the code that calls it just does a bunch of docmd's to run queries to update/append/clean up. Those dont do anything "special".Are you sure that this is the problem code? Are you calling that code from other code? Can you show the 'whole' code?