File in use when opening VB app
 

We have a VB 6 program that one of the things that it does is open
spreadsheets as Excel.Application's, but a client of ours gets a message that
the files are in use. The files are not in use. All users have rebooted
their machines. This started occurring after they did an upgrade to Office
2003.

Other clients do not have this problem. Is there a setting that could have
been changed during this upgrade?

File in use when opening VB app
 

Did you try this?

On the server, right-click on My Computer, then select Manage, expand Shared
Folders, and click on Open Files. There you'll see a list of files on the
server that are currently opened by other computers on your network. That'll
tell you the User who has the file open. You'll need to then click on
Sessions to see what computer(s) that user is connecting from.

"Todd Virlee" wrote:

We have a VB 6 program that one of the things that it does is open
spreadsheets as Excel.Application's, but a client of ours gets a message that
the files are in use. The files are not in use. All users have rebooted
their machines. This started occurring after they did an upgrade to Office
2003.

Other clients do not have this problem. Is there a setting that could have
been changed during this upgrade?

File in use when opening VB app
 

I am not totally sure of your problem, but it sounds something like what I
ran across the other day...

I had previously created a Personal Macro Workbook and every time I have a
blank (or new) "Book1" open and try to open another new workbook, I get this
error: "File In Use" -- "Personal.xls is locked for editing by 'So and
o'" -- "Read Only" -- "Notify" -- "Cancel"

I am not sure this is your issue, but I thought I would post this
information anyway...

"JLGWhiz" wrote in message
...
Did you try this?

On the server, right-click on My Computer, then select Manage, expand
Shared
Folders, and click on Open Files. There you'll see a list of files on the
server that are currently opened by other computers on your network.
That'll
tell you the User who has the file open. You'll need to then click on
Sessions to see what computer(s) that user is connecting from.

"Todd Virlee" wrote:

We have a VB 6 program that one of the things that it does is open
spreadsheets as Excel.Application's, but a client of ours gets a message
that
the files are in use. The files are not in use. All users have rebooted
their machines. This started occurring after they did an upgrade to
Office
2003.

Other clients do not have this problem. Is there a setting that could
have
been changed during this upgrade?

File in use when opening VB app
 

Already tried that. No one has it open, it doesn't show up where you list,
and there are no excel.exe processes still running on any workstations.

"JLGWhiz" wrote:

Did you try this?

On the server, right-click on My Computer, then select Manage, expand Shared
Folders, and click on Open Files. There you'll see a list of files on the
server that are currently opened by other computers on your network. That'll
tell you the User who has the file open. You'll need to then click on
Sessions to see what computer(s) that user is connecting from.

"Todd Virlee" wrote:

We have a VB 6 program that one of the things that it does is open
spreadsheets as Excel.Application's, but a client of ours gets a message that
the files are in use. The files are not in use. All users have rebooted
their machines. This started occurring after they did an upgrade to Office
2003.

Other clients do not have this problem. Is there a setting that could have
been changed during this upgrade?