This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm trying to run a data cleaning workflow, then write the data in an excel file with a lot of pivot tables and formula. It's a read-only file so I'm trying to create a copy of it and output my data in one of the hidden sheets in that file. Is that possible?
I tried the method in this thread but the file created is also a read-only file so I cannot write my output in it.
It would definitely be a batch command to do so. Essentially you could use a macro within the file to do a save as where read-only is false. I would need to look up the VBA code that does it. You could even use the Events tab in Alteryx to run the command before your workflow so it would do this before any of the files. If it is like the attached need and you need to create a new file based on what is the most recent file, the Events command may not be the best idea, but just a simple copy/save/remove read-only this should work.
Thanks for the suggestion! I just need to make a copy of a template and append a new sheet in it.
The problem is that the template file is a read-only file and it has macros and pivot tables. I don't know how to turn off the read-only mode so I'm testing on another template file now but whenever I try to write anything in, it corrupts.
If you have any batch command that can make copy and remove read-only, please let me know.
I don't have a template where I have needed to do this and all my run command templates have proprietary information in them so I cannot share them at this time. I did find a sample of some script that may be helpful to you in creating the .vbscript file or .bat file at the following link: