FileSystemObject Error

[AlexJ]

Help!

I have programed a couple of vba functions using the fso
on a stand-alone machine successfully. Migrating to a
network based PC causes the following error

for the code:

Dim fso as Obect
Set FileSystemObj = CreateObject
("Scripting.FileSystemObject")

Error Message:
Run-time error '429': ActiveX component cannot create
object

I have tried to follow the Microsoft Knowledge Base
Article - 244264 on verifying driver versions, and all are
in sync.

Has anyone solved this one successfully?

TIA,
AlexJ

 

[Dick Kusleika]

Alex

Try here

http://www.google.com/groups?threadm=u7cZIbelCHA.1492@tkmsftngp02

 

[Alex J]

Thanks, Dick.
I'll be able to follow up in the next day or so.
AlexJ

 

[Alex J]

Well .....
It turns out that the machine we were testing on had not installed the
driver for FileSystem Object correctly. (Other machines on the same network
operated just fine).

On the troubled PC the driver (scrrun.dll) was up to date and in the correct
(System32) directory, but the Microsoft Scripting Runtime selection box
under VBE Tools>References was not available. Selecting <Browse>,<
scrrun.dll> makes the driver available in the list.

Before trying the early-binding example Dick has referenced, we tried the
late-binding approach as originally coded, and this now works.

Thanks, Dick, for pointing us down the right path!

Alex J