Hi
I have files in a folder which I use the file management VBO to get a list of and place into a collection. I know one of the values that collection contains is the name of the file. How do I access that name to use in another action?
I have a similar collection using the MS Outlook VBO and when I open that collection it lists all of the field names i.e.
and I can access those field names in other actions. However in the collection created by the 'Get Files' action there is no list of filed names. I can see the list of files in the 'current values' tab
but the field columns show nothing
What I want to do is loop through each file in the collection and save the spreadsheet as a text file. The MS Excel VBO:: 'Save Workbook as' wants a filename. If I were using the email collection I could simply drag and drop the appropriate text entry
But I have no such option for file name
Anyone have any idea how I can achieve this?
thanks
Steve
I have files in a folder which I use the file management VBO to get a list of and place into a collection. I know one of the values that collection contains is the name of the file. How do I access that name to use in another action?
I have a similar collection using the MS Outlook VBO and when I open that collection it lists all of the field names i.e.
and I can access those field names in other actions. However in the collection created by the 'Get Files' action there is no list of filed names. I can see the list of files in the 'current values' tab
but the field columns show nothing
What I want to do is loop through each file in the collection and save the spreadsheet as a text file. The MS Excel VBO:: 'Save Workbook as' wants a filename. If I were using the email collection I could simply drag and drop the appropriate text entry
But I have no such option for file name
Anyone have any idea how I can achieve this?
thanks
Steve