LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel Network Problems


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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Network drive problems DMB Excel Programming 2 January 27th 06 03:34 PM
Save to Network Drive Problems. Expanding Current code mcgrad Excel Programming 3 January 25th 06 02:21 PM
The operation failed due to network problems Andrew2005 Excel Discussion (Misc queries) 0 November 16th 05 11:01 AM
Excel in network Max Potters Excel Programming 2 August 21st 04 08:45 AM
Copying files ...Network to Network Eric[_6_] Excel Programming 2 July 18th 03 08:59 PM


All times are GMT +1. The time now is 09:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"