C
Craig Sira
I am using the TransferSpreadsheet macro in MS Access to
replace data in a specific sheet in an MS Excel
workbook. At first this was working very well. Then it
began to create new sheets with a "1" at the end or gave
me an error message saying the sheet already exists. If
I point the macro at a new workbook it will work fine for
awhile (replace the data in the sheet with the new data)
and then it begins to turn bad by adding a "1" at the end
of the sheet name or error out.
Thank you,
Craig Sira
replace data in a specific sheet in an MS Excel
workbook. At first this was working very well. Then it
began to create new sheets with a "1" at the end or gave
me an error message saying the sheet already exists. If
I point the macro at a new workbook it will work fine for
awhile (replace the data in the sheet with the new data)
and then it begins to turn bad by adding a "1" at the end
of the sheet name or error out.
Thank you,
Craig Sira