lol, hacking experience :-p. Not looking to hack, just plain VBA programming.
Thank you for your answers and advice. I'll keep researching.
"JLGWhiz" wrote:
> I do not believe the VBA for Excel has that facility readily available, since
> it requires access to another user's OS. However, that does not mean it
> cannot be done using VB code. Perhaps some advanced programmer who has some
> hacking experience can supply the code.
>
> "Stephen sjw_ost" wrote:
>
> > Yes, I've read all of this. What I am understanding from this literature is,
> > I have to identify each person by, opening the file and then choosing
> > Tools>Share Workbook... and then ask the people who have the file open, to
> > close it themselves. Thats great unless they have left fo the day and their
> > PC is locked which leaves the potential of eliminating or not counting any
> > changes that they may have made but not saved. Yes this happens sometimes,
> > very annoying.
> > So, this leads me back to my original question. Is there a way to close all
> > of the opened, shared version(s) of the file programically without having to
> > ask the individuals to close it themselves and save before the close occurs?
> > Perhaps utilizing a userform that I can activate remotely to all opened
> > versions that has the ActiveWorkbook.Save and Application.Quit commands set
> > in the Activate description of the userform?
> >
> > Thanks for the reply.
> >
> > "JLGWhiz" wrote:
> >
> > > This bit out of Excel help is probably as fast a method as code.
> > >
> > > Have all other users save and close the shared workbook (shared workbook: A
> > > workbook set up to allow multiple users on a network to view and make changes
> > > at the same time. Each user who saves the workbook sees the changes made by
> > > other users.). If other users are editing, they will lose any unsaved work.
> > > Unsharing the workbook deletes the change history (change history: In a
> > > shared workbook, information that is maintained about changes made in past
> > > editing sessions. The information includes the name of the person who made
> > > each change, when the change was made, and what data was changed.). If you
> > > want to keep a copy of this information, print out the History worksheet
> > > (History worksheet: A separate worksheet that lists changes being tracked in
> > > a shared workbook, including the name of the person who made the change, when
> > > and where it was made, what data was deleted or replaced, and how conflicts
> > > were resolved.) or copy it to another workbook.
> > > How?
> > >
> > > On the Tools menu, point to Track Changes, and then click Highlight Changes.
> > > In the When box, click All.
> > > Clear the Who and Where check boxes.
> > > Select the List changes on a new sheet check box, and then click OK.
> > > Do one or more of the following:
> > > To print the History worksheet, click Print .
> > > To copy the history to another workbook, select the cells you want to copy,
> > > click Copy , switch to another workbook, click where you want the copy to go,
> > > and click Paste .
> > > Note You may also want to save or print the current version of the
> > > workbook, because this history might not apply to later versions. For
> > > example, cell locations, including row numbers, in the copied history may no
> > > longer be current.
> > >
> > > On the Tools menu, click Share Workbook, and then click the Editing tab.
> > > Make sure that you are the only person listed in the Who has this workbook
> > > open now box.
> > > Clear the Allow changes by more than one user at the same time check box.
> > > If this check box is not available, you must unprotect the workbook before
> > > clearing the check box.
> > >
> > > How?
> > >
> > > Click OK, point to Protection on the Tools menu, and then click Unprotect
> > > Shared Workbook.
> > > Enter the password (password: A way to restrict access to a workbook,
> > > worksheet, or part of a worksheet. Excel passwords can be up to 255 letters,
> > > numbers, spaces, and symbols. You must type uppercase and lowercase letters
> > > correctly when you set and enter passwords.) if prompted, and then click OK.
> > > On the Tools menu, click Share Workbook, and then click the Editing tab.
> > > When prompted about the effects on other users, click Yes.
> > >
> > >
> > > "Stephen" wrote:
> > >
> > > > I have an Excel "database" that is is used by multiple users in a Share
> > > > Workbook environment. I would like to be able to close this entire "database"
> > > > from all curent users PC and then re-open it on my PC exclusively to perform
> > > > maintenence.
> > > > I have a way of doing this with Access databases but I have no clue how to
> > > > accomplish with Excel.
> > > >
> > > > Thank you for any help.
> > > > Stephen
Similar Threads
