Have Input Values in Output File

[tally]

I have a macro/app where I use start date, end date and a list of numbers as an input.

The dates are selected using a date picker and the list is taken in from a text box.

How can I use these values to create a sheet for the inputs within the output file?

Example:

Input Values:

Start Date; 2021-01-01

End Date; 2021-01-02

List; 5, 6, 7, 8

Desired Output:

Type: Excel File

Sheet Names: Output, Input Values

The Output sheet will contain the data that is calculated by the workflow, I would like to add another sheet that only contains the input names and input values. Is this possible?

Thanks,

T

[mceleavey]

Hi @tally ,

Yes this should be relatively straightforward but we will need a sample of the data and your macro, so we can build it for you. It's easier that way.

M.

[tally]

Hi @mceleavey ,

Thanks for your quick response! 

Sharing the data will not be possible, in addition to this, the workflow uses In-DB connections right until the data stream out tool is used, so sharing the workflow will also not work as there will be no access to the data.

Would it be possible to get an example of how the inputs can be put into an output file and I can try to recreate it?

Thanks,

T

[mceleavey]

In that case it will be difficult as I can't see what you're trying to do.

Can you just mock up some data in a text input to illustrate what you're trying to do?

M.

[tally]

I will try to create some mock data for you some time this week so that we can come to a solution. 

[apathetichell]

As I 'm reading your problem - something like this intertwined with your workflow should work to save the inputs and put them in their own excel sheet with the rest of your output. This assume the rest of your workflow will have it's own path set as well obviously and that you group on those paths.