Creating New Folder with Dynamic Name and Files in Folder

[JackieDriscoll]

 

 

Hello; I would like to be able to:

1. Create a folder with a dynamic name (ex. today's date) and save to a constant location

2. Create an excel file, with a constant name, to be saved into the folder in (1)

I am able to complete (1) and create a folder with a dynamic name in a constant location use the Run Command Tool.
I also use the Block Until Done Tool to finish (1), and then output the excel file into the correct folder. Even though the Output Tool states the file format is an Excel file, the file is not saved as xlsx, and I am not able to open it with excel. 

How can I get my file to be the correct file type?

[ChrisTX]

Instead of naming your file "Output", try "Output.xlsx|||Sheet1"

[JackieDriscoll]

That was able to get the correct file type, but now the file is being saved in the wrong location.

The "fullpath" is the location of the dynamic folder that was created in (1), and now I have the "fullpath" appending as a suffix to the file. But the file is saved in the same location as the folder, rather than in the folder itself.

[HomesickSurfer]

Hi @JackieDriscoll