View Single Post
  #4   Report Post  
rcmodelr
 
Posts: n/a
Default

Yes, it IS connected to the companies network. NO.. I am UNABLE TO try
re-booting the server. I have Administrator access privelages on the
computer I work at, but have NO access rights to the main server system.

I had thought of BYPASSING Windows and DELETING the files through DOS.

However, TWO of the files are named with Windows accepted LONG filenames
(DOS will show as Truncated/serialized filenames) Any EASY way to figure out
what DOS would find on the computer's hard drive as the filename? (the files
themselves ARE saved on the hard drive of the computer I work with and NOT
some drive somewhere else in the network.)

If it would help... without directory paths, here is ONE of the filenames as
Excel and Windows see it:

Daily Live Bird Weight Sheet (BOTH SHIFTS)0811.xls

And there are literally DOZENS of files on the SAME directory by the ALMOST
SAME name (Only difference being that the 0811 is the plant's run-date Month
and DAY) and there are currently about 3 month's worth of similarly named
files in that directory so a file from 2 - 3 months ago can be opened to find
average driver turn-around time from the farm they are catching birds at so
arrival time estimate for third load from farm can be calculated when the
plant starts running low on birds and starts calling me asking when the next
load will be there.

"Dave Peterson" wrote:

Is that file on a network share?

If yes, maybe rebooting that server would help.



rcmodelr wrote:

Before you say I should:
Type "C:\Program Files\Microsoft Office\Office\Excel.Exe" /regserver
(include the quotes) -- adapt to fit your path. (to force Excel to
RE-register itself...)

I already tried that, and both Excel AND Windows still say I am already
accessing those files so they can be opened as READ ONLY, but I STILL CAN NOT
DELETE or rename the files.

"rcmodelr" wrote:

This morning, at work, I was using Excel to track data on trucks at work.
During break, I opened another Excel document to view. Shortly after the
second Excel document was opened, another truck came in. When I tried to go
back to the spreadsheet file to record the info for the truck that came in,
Excel went idle for 30 seconds, then came back with a READ ERROR saying it
had tried reading a memory address that was un-readable. When I clicked OK
on the read error message box, Excel SHUT DOWN COMPLETELY...

When I RE-started Excel, and tried loading the truck info file that was
supposed to be activating when the memory read error occurred, Excel reported
that I (well, MY UserID) was accessing that file elsewhere, and Excel would
therefore ONLY open it as a READ-ONLY file. It gave the SAME "protection"
message when it tried opening my Personals.xla file.

To be able to record the info on the trucks, I had to save the file under a
NEW NAME so the data could be saved.

Afterward, I even tried RE-BOOTING the computer, THEN accessing the file,
and Excel STILL says the Personals and truck file have been RESTRICTED by MY
UserID so they are STILL only accessible in READ-ONLY mode. So I tried
DELETING them with Windows Explorer, which says the files CAN NOT BE DELETED
because my userID has restricted access to these files through Excel.

How can I get Excel AND Windows to REMOVE the protection from these NO
LONGER NEEDED files? I have a couple new macros to add to my Personals file,
but Excel won't allow me to do so, stating that the Personals file is already
in use BY ME so it can be opened ONLY in READ-ONLY mode, and I CAN NOT save
it if I want to.


--

Dave Peterson