ActiveX error

[woakman]

I have a little problem opening a word document on a LAN drive. The code I am using works fine if I am using one of my local drives but gives me this error when I switch to the LAN ("ActiveX component can't create object")

Here is the code:

'Documents.Open (SearchDirectory & "\" & File)'

Searchdirectory is the path and file
is the filename to be opened.


Does anyone have any idea why this wont work on a lan? or what to do to fix it?

By the way....I am using NT

Any help would be greatly appreciated..

Thanks

you may need to strip part of the path...in other words the object is not being found because..maybe your path includes a drive or path specification not in line with the LAN setup...

your setup
path = "C:\MyFiles\File"

the LAN
path = "\MyFiles\File

or
path = "MyFiles\File"

it's clearly a path problem and nothing more.