Maintain Excel sheets and Macros in Alteryx Gallery Output
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi everyone,
I have developped a workflow where the output file is an Excel Macro enabled Worksheet. In this output, there is a Macro that reads from the Alteryx output sheets and writes in others sheets.
The problem is when I run the workflow on Alteryx Gallery the output contains only the Alteryx output sheets and I can't find neither the other sheets nor the vba macros.
Is it possible to have the output file with all the sheets and vba macros I need ?
Thanks,
AyouB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@AyouBK I think you should see @jarrod's post over here. Basically, you'll want to add your excel file (like C:\File.xlsm) as an asset to one of your output tools. Then you when you save to the gallery, you'll want to be sure you go to workflow options and manage workflow assets. You'll want to be sure that your file is checked. Note that this option may be available from the start, but it won't actually save the excel file unless you add it manually as an asset.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks a lot ! I've got it working.
