innodes Posted May 12, 2009 Share Posted May 12, 2009 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, Link to comment Share on other sites More sharing options...
mr_vodka Posted May 12, 2009 Share Posted May 12, 2009 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 Link to comment Share on other sites More sharing options...
innodes Posted May 12, 2009 Author Share Posted May 12, 2009 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 Link to comment Share on other sites More sharing options...
mr_vodka Posted May 12, 2009 Share Posted May 12, 2009 Your output path is wrong. You need the full path. Take a look at my earlier post again. Link to comment Share on other sites More sharing options...
innodes Posted May 13, 2009 Author Share Posted May 13, 2009 thanks! that was it. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5462 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now