Hi All,
I have a Macro workbook that has multiple sheets, its a weekly task & needs to be updated on a weekly basis. I am trying to update the file & have tried multiple options but not working,
Ex: When i use Append to existing sheet, it gives me an error saying Microsoft access database engine could not find the object - Then it specifies that the specific sheet does not exist
When i change output option to Overwrite file, it deletes the older sheets & just copies the data in a new sheet
One more thing, sheets that i am trying to update have additional macro columns (apart from the general columns that needs to be updated )
Have you tried to specify the range, like "FileName.xlsm|||Sheet1$A1:Q10"?