Romano_odK
Active Member
- Joined
- Jun 4, 2020
- Messages
- 379
- Office Version
- 365
- Platform
- Windows
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
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