This is a pretty basic question but how would I go about changing the format of a file without using the Output Data tool? I have 2 use cases below but ideally I both would be a macro that I could insert into the workflow.
Use Cases:
1. I have created a workflow that runs through a directory and only pulls .xlsx and .csv files. However some files are .xls. I was hoping to insert a macro into the workflow that would look through the directory and save each xls file as xlsx.
2. This is very simple but some .xlsx files need to be converted into .csv files. This needs to be a macro as it is another step in my workflow.
The problem I am having is that the Data Output tool is the end piece of a workflow and does not allow the use of a Macro Output after it. What are some possbile work arounds and or different ways of approaching this issue?
