Jump to content
Sign in to follow this  
innodes

excel export with calculated title?

Recommended Posts

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,

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

export.jpg

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.