I have a macro in Access that should update my worksheet called "Sum". However instead of updating the sheet it creates a new worksheet called "Sum1".
In Access I am using the TransferSpreadsheet operation for the Macro.
Any clue as to why it will not update the existing "Sum" worksheet but instead creates one called "Sum1"?
In Access I am using the TransferSpreadsheet operation for the Macro.
Any clue as to why it will not update the existing "Sum" worksheet but instead creates one called "Sum1"?