other users unable to open saved file
Posted on 2014-01-09
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. ..