Making a path and filling in the date.

[Romano_odK]

Good evening,

In my sheet there is a macro that makes an XML file especially for the software I work with. This XML needs to be written to a specific folder with a specific name. That being said, I need with the press of a button that in a cell the the text C:\Temp\yyyy-mm-dd-IKP.XML is written. The fun part is that the yyyy mm dd are indeed the current year, month and day. Is it possible to do this?

The software I use will be able to read our this date and import it on the specific date. This is now done manually. Can this be done using VBA or should I turn to Excel?

Thank you for your help

Kind regards,

Romano

 

[C Moore]

=TEXTJOIN("-",,YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()),"IKP.XML") will return what you mention for the filename piece.

 

[Fluff]

Another option is

="C:\Temp\"&TEXT(TODAY(),"yyyy-mm-dd")&"-IKP.XML"

 

[Romano_odK]

=TEXTJOIN("-",,YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()),"IKP.XML") will return what you mention for the filename piece.

Thank you for your reply, this works great.

Have a nice day.

Romano

 

[Romano_odK]

Another option is

="C:\Temp\"&TEXT(TODAY(),"yyyy-mm-dd")&"-IKP.XML"

Good evening,

As the above solution, this also works great. Thank you for your reply.

Have a nice day,

Romano

 

[Fluff]

Glad we could help & thanks for the feedback.