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

Alex

Try here

http://www.google.com/groups?threadm...%40tkmsftngp02

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"AlexJ" wrote in message
...
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

Thanks, Dick.
I'll be able to follow up in the next day or so.
AlexJ
"Dick Kusleika" wrote in message
...
Alex

Try here

http://www.google.com/groups?threadm...%40tkmsftngp02

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"AlexJ" wrote in message
...
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

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 ToolsReferences 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

"Alex J" wrote in message
.. .
Thanks, Dick.
I'll be able to follow up in the next day or so.
AlexJ
"Dick Kusleika" wrote in message
...
Alex

Try here

http://www.google.com/groups?threadm...%40tkmsftngp02

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"AlexJ" wrote in message
...
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