excel export with calculated title?

[innodes]

Is it possible (and how?) to set the file title of an exported file via a calculation?

IE - "MSL_" & Get (CurrentDate) & ".xls"

Is it possible (and how?) to set the tab title of an exported file via a calculation?

IE - "MSL_" & Get (CurrentDate)

thanks,

[mr_vodka]

In your Save as Excel script step, you can specify the Excel "Options". You can rename the default workbook tab but not any new ones.

See this recent thread on how to incorporate the date.

http://fmforums.com/forum/showtopic.php?tid/201066/post/316964

[innodes]

Thanks. It looks like it is mostly there, but dies at the export. The debug says #100 - "file is missing". Seems like it is looking for a file to overwrite verses to create a new file.

( see attachment )

innodes

[mr_vodka]

Your output path is wrong. You need the full path. Take a look at my earlier post again.

[innodes]

thanks! that was it.