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

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

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
ToolsShare 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

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
ToolsShare 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

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
ToolsShare 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