Saving workbook

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.
 
F

Frank Kabel

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.)
 
Top