<div>
Thanks doh doh doh again on my part. ..<br />
<br />
excellent heads up
</div>


<div>
<div class="content wysiwyg-content">
Hi Expert's excel 2007<br />
<br />
I am saving a file using vba code<br />
WbkName = Left(ActiveWorkbook.Name, 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<br />
<br />
However, once the file saves other users are unable to open the file because you are asked to select a programme to open the file with...and also the excel icon when you save a file from the save as option is different. ..
</div>
</div>


Hi Expert's excel 2007

I am saving a file using vba code
WbkName = Left(ActiveWorkbook.Name, InStrRev(ActiveWorkbook.Name, ".") - 1) ActiveWorkbook.SaveAs Filename:="\\jjjdje.com\file2\" & WbkName & "_" & Format(Date, "dd mmm yy") & ".xslm

However, once the file saves other users are unable to open the file because you are asked to select a programme to open the file with...and also the excel icon when you save a file from the save as option is different. ..

Thanks doh doh doh again on my part. ..

excellent heads up

other users unable to open saved file

Hi Expert&#39;s excel 2007

I am saving a file using vba code
WbkName = Left(ActiveWorkbook.Name, InStrRev(ActiveWorkbook.Name, &quot;.&quot;) - 1) ActiveWorkbook.SaveAs Filename:=&quot;\\jjjdje.com\file2\&quot; &amp; WbkName &amp; &quot;_&quot; &amp; Format(Date, &quot;dd mmm yy&quot;) &amp; &quot;.xslm

However, once the file saves other users are unable to open the file because you are asked to select a programme to open the file with...and also the excel icon when you save a file from the save as option is different. ..

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