Replace date in Workbook Name
<p>I've got a simple question about an idea how to do something.
My macro needs to save currently opened workbook as a new one. Normally it is simple, but in case that file name contains some date, it needs to be changed to today date.</p>

<p>Some examples: </p>

<ul>
<li>(...) 2015-01-01.xls needs to be saved as (...) v2016-04-08.xlsm</li>
<li>(...) 01-01-2015.xlsm needs to be saved as (...) v2016-04-08.xlsm</li>
<li>(...) &amp; every other date format needs to be saved as (...) v2016-04-08.xlsm</li>
<li>(...).xls needs to be saved as (...) v2016-04-08.xlsm</li>
</ul>

<p>My question is how can i do it as simple as possible? Should i code a bunch of IFs? And finally how to replace it? In IF i can use LIKE operator, but in replace i need to provide raw string in argument..</p>

<p>Thanks for your time and help!</p>