Excel 2003 SP2: How do I close a file that is opened by someone else? 1

[herkiefan]

I have reached an new high in my "annoyance-level."

Is there a way to close a file that someone else has open?

I have a workbook that only a few people have access to i.e., been given the password to; and one of them (my boss, of course) consistently opens the file and leaves it open.

Unfortunately due to confidentiality, office politics, and other bs reasons, I can not access my boss' cpu to close the file. Plus, he thinks he needs full rights to edit the file...

Two questions:
1. How do I "remotely-ish" close the file?
2. Is there a way to add a "close if not being used for x seconds" macro to the file?

Yours truly,

"Going crazy"

“Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein

 

[AnotherHiggins]

Crazy - Someone just asked a similar question in thread68-1460841.

As I mentioned to them, please keep in mind that VBA/Macro-specific questions should be posted in forum707.

But I suggest against going for a macro-in-the-file approach anyway because the macro would have to constantly loop over and over the entire time the workbook is open. That would take up computer resources.

You could consider Sharing the workbook so multiple people could access it at once. Have a look at Tools > Share Workbook. But a word of caution about doing that: I have heard reports that shared workbooks have a tendency to become corrupted.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[herkiefan]

John,

I appreciate both of your responses. And thank you for the reminder about appropriate forum posting. I sometimes forget about Forum 707.

Anyway...I've decided to set up a "dummy" file for my boss that he can access the most current version of our model, without actually opening the "real" version.

Mike


“Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein