Hi,
I'm using the output filename as filepath in my macro. Using this output-I'm using the text to column field to extract certain details like filenames and broad categories-based on filepath. On running the macro-i'm getting these details-but when I insert it in my workflow and call it in by the interface question-Filepath itself-neither the filepath details are coming up nor any of the fields I derived from it in my macro. For my filepath in my macro-I have selected the File-Value=(current filepath) in the action tool. Based on what I read on the community-for the extracted fields as well -I hardcoded the current values in a formula tool and then connected them to action tools as well-in-order to a) show these fields in my workflow and b) update their values. The purpose of my workflow is to read in multiple excel files-so I want to filepaths and the extracted fields to change, but that's not happening. I tried degugging my macro-the hardcoded fields come as blanks there. I'm a newbie, so may have been missing something basic here. Attaching screenshots for reference. In my workflow-my interface question is the same filepath-I want to display the file path as well as extracted fields and make them change dynamically as different excel inputs come in from my directory tool. Currently I'm getting a parse error: Unknown Variable "H"-which is the starting letter of my filepath.
