In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Update specific sheet in Workbook or Excel with multiple sheets

Sahil7
5 - Atom

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 )

1 REPLY 1
Prometheus
12 - Quasar

Have you tried to specify the range, like "FileName.xlsm|||Sheet1$A1:Q10"?

Labels
Top Solution Authors