When creating the excel template for export can we embed a macro into that template so that when the file is downloaded and the user opens the file they can then initiate a macro to convert the data as they need?We will be exporting as Excel file not CSV.
Discussion posts and replies are publicly visible
I think it'll depend on which smart service you're using to generate. The new Data Store Entity to Excel barely allows the use of a template file whatsoever (making it nearly unusable to me), and overwrites all formatting at write time.
On the other hand, the Excel Tools smart services (most of which are now deprecated with no functional replacement, grumble...) such as CDT to Excel or SQL to Excel, only overwrite the formatting on the particular cells that are written, so I'd be surprised if a macro was affected by export, but you'd need to just test it out and see what happens.
Thanks! We need to export as excel because I don't think you can embed a macro in a CSV but not sure. I agree on the test. We'll do that.
We are also facing the same issue. please let us know if there are any similar smart service or plugin that can export data from a CDT to an excel template(without overwriting the template design.)
Put the macro on a different sheet, then it won’t be overwritten. Hope that helps
Thanks. We actually were able to embed a pretty complex macro into the exported sheet. Thanks for all the feedback
so, even if we have macros in sheet1, it is working fine for your or you places macros in sheet2 suggested by Christine?
can you please guide me
Could you please let us know how did you add macro to exported sheet. We have similar requirement, reply ASAP
Can you explain how you were able to use XLSM (Excel with macro) as template and generate excel without loosing macros in it?
© 2022 Appian. All rights reserved.