You want to export to an existing file starting at a specific cell? Or are the target cells named? Or is there a pattern of cells (every nth column)? Your requirement is not stated specifically enough for me, I'm afraid. I consider the first option to be fairly easy, the second less so and the 3rd the hardest. As ranman256 suggests, you might want to go at it the other way. If not, a basic description of the process would be to open the workbook, create a recordset from the source query or table and loop through it, writing to the spreadsheet as you go, then saving and/or closing the workbook.