Moving data

[ppatane]

I have a workflow that produces a field containing the path + File name + sheet name.  How can I open this file as the input data tool does not have an input anchor?

[binuacs]

@ppatane If all your process are in one workflow you don't need to open the output file and passing to the input tool instead you can use the same flow for further processing like below, the below workflow creates the output then using the same flow for further processing, 

[KGT]

And if you are just trying to dynamically input a file... try the Dynamic Input Tool where you can pass the path to it. It does get a little funky if you're dealing with changing schemas, but that should get you started.

If you are creating the file in the same process though, go with @binuacs solution. Do not write out a file and read it back in the same workflow.

[ppatane]

@binuacs @KGT I should have provided more information, I need to open the file so that i can save it to another file with the same tab name.
Example: incoming \\data1\user2\ppatane\Test1.xlsx|||Excel Format to be saved to \\data1\user3\jsmith\Test2.xlsx|||Excel Format