Saving workbook

  • Thread starter Thread starter booshi
  • Start date Start date
B

booshi

We are sharing some excel books on netwrok by using several "my briefcase"
linking to one master file. We cannot modify the file and update to the
master file at the same time - as the computer refuse to merge them
together.
Is there any method that it can go real multiuser.
 
Hi
you may try the following:
sub save_with_cell()
Dim fname
fname = worksheets("sheet1").range("A1").value
fname = fname & ".xls"
ActiveWorkbook.SaveAs Filename:=fname
end sub

You should add some error checking to this (does the files exist, etc.)
 
Back
Top