Results 1 to 1 of 1
Thread: Transferworksheet Fuction
2001-02-07, 16:59 #1drjabearGuest
I have a table in Access called M - Calc Query that I am exporting to Excel using the Transfer Spreadsheet Function. The function works great with one exception. In my Excel workbook I already have a worksheet named M_Calc_Query that was initially Exported from Access. I would like The subsequent export to over right the original M_Calc_Query worksheet instead of creating another worksheet within the workbook named M_Calc_Query1. Can someone help me out in determining how to over right the existing worksheet?