Not that I have that error but there are various causes which seem more tied
to VBA than Excel:
http://www.google.co.uk/search?hl=en...on%22+%2BExcel
Check the references of the WB both when on the network and when copied to
the laptops.
NickHK
"ging18" wrote in
message ...
Hello All!
I have developed a large excel workbook in Excel 2000 on Windows 2000
that is heavily automated with VBA.
The workbook is used like an interface to view and modify a host of CSV
files. No actual data is stored within the workbook, just code to load
the files, manipulate them and the save the CSVs back to the network.
The excel file is stored on a network drive that is accessed by
different users on their machines
Part of the functionality of the workbook allows users to work remotely
from the network. Unfortunately the security implemented on our network
prevents wireless access so a piece of code copies all the required CSV
files from the network to the users local machine where they can then
unplug the network cable and work away from the network on the
machines. When the user has finished they reconnect their machine to
the network, click a button and the workbook copies the updated CSV
files back to the network drive.
As users needs have changed I have been adding extra features to the
workbook so that more functionality is available but I have not changed
the code used to control the disconnecting and reconnecting to the
network.
Now I find that when a user has reconnected to the network (I check
that a folder on the network exists to ensure the connection is active
before starting the operation) the errors below occur at different
points in the execution.
“Error Accessing File. Network Connection May have been lost”
“Could not find specified Object”
These cause the toolset to crash and the user either gets trapped in
the workbook or Excel freezes.
My initial thoughts are that the workbook may have grown too big for
excel to store in memory and the components are not loaded, but with
the network connection being present why is it not just loading the
components from the source?
I’m also finding that the original version is also starting to have
occurrences of the error.
I have found that different machines have different success levels with
the function, in some cases this workbook works fine and the error
passes to other workbooks that were open when disconnected to the
network
Does anybody have any ideas as to the likely cause and possible
solution to this problem?
Cheers
Christian.
--
ging18
------------------------------------------------------------------------
ging18's Profile:
http://www.excelforum.com/member.php...o&userid=36990
View this thread: http://www.excelforum.com/showthread...hreadid=567145