<div>
Hi Peter57r<br />
<br />
Can you kindly assist on this one;<br />
<br />
<a href="https://www.experts-exchange.com/questions/27680984/update-current-macrot-to-add-boarders-to-a-cell-range.html" rel="ugc">https://www.experts-exchange.com/questions/27680984/update-current-macrot-to-add-boarders-to-a-cell-range.html</a><br />
<br />
thanks
</div>


Hi Peter57r

Can you kindly assist on this one;

https://www.experts-exchange.com/questions/27680984/update-current-macrot-to-add-boarders-to-a-cell-range.html [https://www.experts-exchange.com/questions/27680984/update-current-macrot-to-add-boarders-to-a-cell-range.html]

thanks

<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
How would you change the current macro that saves the Active.Workbook to a save function and data stamp the save file..<br />
<br />
Currently:<br />
<br />
.ActiveWorkbook.Save<br />
<br />
Waht to change to<br />
<br />
.ActiveWorkbook.SaveAs xl Path = &quot;\REPORT_1_&quot; &amp;&nbsp;Format(Now(), &quot;&nbsp;dd-mmm-yy&quot;) &amp;&nbsp;&quot;.xls&quot;<br />
<br />
I believe the above is not correct....<br />
Thanks
</div>
</div>


Hi Experts

How would you change the current macro that saves the Active.Workbook to a save function and data stamp the save file..

Currently:

.ActiveWorkbook.Save

Waht to change to

.ActiveWorkbook.SaveAs xl Path = "\REPORT_1_" & Format(Now(), " dd-mmm-yy") & ".xls"

I believe the above is not correct....
Thanks

Change ActiveWorkbook Save to Save As

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.