Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scripting.FileSystemObject Networking
Dear colleagues,
I have a problem to reference the FileSystemObject object through the simple LAN connection. For example of this problem let's say that I am working on the Computer named "comp1" & trying to reference some VBA objects on another Computer on the network named "comp2". Generaly LAN is working correctly even when using VBA the : Statement ChDir "\\comp2\c" works with no problem Function Dir("\\comp2\c") works with no problem Copying files through the network(using VBA) from "c\MyDoc" to "\\comp2\c" works with no problem So, the actual problem is how to reference the FileSystemObject object on the "\\comp2" from "\\comp1" (or from any Dir on "comp1" ie just from "c\MyDoc") Variables: Dim fso as Object '(=FileSystemObject) The statement Set fso = CreateObject("Scripting.FileSystemObject", "\\comp2") returns the error: "Run-time error '462' The remote server machine does not exist or is unavailable" The statements: Set fso = CreateObject("Scripting.FileSystemObject") Set fso = CreateObject("Scripting.FileSystemObject", "\\comp1") both works & returns the FileSystemObject on "comp1" Althought I think that there is no problem with network just brief network info: - on both PC's ("comp1" & "comp2") there are Win98 & Office 2000 - connection Planet_ENW9504_PCI_networkCards, UTP cable, via Switch, protocol IPX/SPX -Services File&PrinterSharing & ClientforMicrosoftNetworks So far I have trying (unsuccessfuly) to find solution on the following web sites: CPearson; ErlandserData; J-Walk; StephenBulXLS; DaveMcRitchie & offcourse Office2000 VBA-Help So anyone who knows: - the solution of this problem, or - the relevant web site which enlight this theme please reply. Thank You in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NETWORKING DATABASE | Excel Discussion (Misc queries) | |||
Excel networking help needed for backup | Setting up and Configuration of Excel | |||
Networking excel spreadsheets error | Excel Discussion (Misc queries) | |||
Scripting.FileSystemObject | Excel Discussion (Misc queries) | |||
Networking problems... | Excel Programming |