<div>
Replace Format(Date, &quot;dd mmm yy&quot;)<br />
<br />
with<br />
TEXT(TODAY()-1, &quot;dd mmm yy&quot;)
</div>


Replace Format(Date, "dd mmm yy")

with
TEXT(TODAY()-1, "dd mmm yy")

<div>
Hi experts can u assist with<br />
&nbsp;<a href="https://www.experts-exchange.com/questions/28334298/macro-to-enable-contents-on-data-connection-and-links.html" rel="ugc">https://www.experts-exchange.com/questions/28334298/macro-to-enable-contents-on-data-connection-and-links.html</a>
</div>


Hi experts can u assist with
 https://www.experts-exchange.com/questions/28334298/macro-to-enable-contents-on-data-connection-and-links.html [https://www.experts-exchange.com/questions/28334298/macro-to-enable-contents-on-data-connection-and-links.html]

<div>
<div class="content wysiwyg-content">
Hi Expert's excel 2007<br />
<br />
how would I amend so the date on the saved file is less one day from current date..<br />
<br />
<br />
, InStrRev(ActiveWorkbook.Na<wbr />me, &quot;.&quot;) - 1) ActiveWorkbook.SaveAs Filename:=&quot;\\jjjdje.com\fi<wbr />le2\&quot; &amp;&nbsp;WbkName &amp;&nbsp;&quot;_&quot; &amp;&nbsp;Format(Date, &quot;dd mmm yy&quot;) &amp;&nbsp;&quot;.xslm
</div>
</div>


Hi Expert's excel 2007

how would I amend so the date on the saved file is less one day from current date..


, InStrRev(ActiveWorkbook.Name, ".") - 1) ActiveWorkbook.SaveAs Filename:="\\jjjdje.com\file2\" & WbkName & "_" & Format(Date, "dd mmm yy") & ".xslm

amend vba to reflect -1 day

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.