Macro tools functions

[SH_94]

Hi Community, 

I had used the macro to run the workflow that was posted by other community members as per screenshot below .

May i know what is the functions for the first and second screenshot that we put the formula as below ?

Thank you.

[danilang · Accepted solution]

Hi @SH_94 

The first one adds <List of sheet names> to the path of each file returned from the directory tool.  This probably used in the following macro to extract all the data from every sheet in the workbook.

The second one returns the filename+ext from the returned path, without the directory path or the sheet names

Dan