Update specific sheet in Workbook or Excel with multiple sheets
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Sahil7
5 - Atom
‎08-31-2023
08:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 )
Labels:
- Labels:
- Datasets
1 REPLY 1
Prometheus
12 - Quasar
‎08-31-2023
10:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Have you tried to specify the range, like "FileName.xlsm|||Sheet1$A1:Q10"?
