Jump to content

Using the Date as an Excel Filename


Recommended Posts

Hi,

Just wondering if anyone can help I'm using a V350 with TRA22 expansion. I'm trying to use the date as a file name for saving a CSV excel file?

Currently I use the RTC (dd/mm/yy) to ASCII and save the result in an ML and try to use this as an indirect input into the delimited line but this gives status error 2: Fail to Open File. I think its to do with the "/" that gets stored in the ASCII number, as i tried experimenting with this using constant text and got the same error status. I'm wondering if there is a work around for this?

I think i can use either vectors to fill in the date using the relevant SI bits(32 and 33) but im not sure how to fill up the vector correctly? Or I could use the String Remove function to remove the "/" from the RTC to ASCII conversion but again i'm not sure how to do this correctly?

Hoping someone can point me in the right direction :)

Cheers,

Innov

Link to comment
Share on other sites

  • 9 years later...

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.

×
×
  • Create New...