i am trying to parse a word document and convert to Excel.
for example if the input word document name is Test.docx i want the same name for excel output as Test.xls. is there any way i can automate that ? Appreciate the support.
Hi @jmedidi
Configure your Input Tool to 'Output File Name as Field: Full Path, then use the following expression in a Formula Tool before your Output:
FileGetFileName([FileName])+".xlsx"
Thanks for the response.
As input Data Tool doesn't support Word Docs i am using a macro to read a word doc file. Will this complicate it or i can use the logic at output side alone for this to work ?
