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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    ayescas 
×

Important Information

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