FileSystemObject Error

  • Thread starter Thread starter AlexJ
  • Start date Start date
A

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
 
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
 
Back
Top