Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening file in Excel 2003 opens multipule instances of same file | Excel Discussion (Misc queries) | |||
File:1 and File:2 -- Double Files when Opening One File | Excel Discussion (Misc queries) | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
Error:Invalid File format,while opening an Excel Template file | Excel Programming |