Run-time Error 429 on Scripting.FileSystem object after scrrun.dll registered

Question

There are quite a few entries on here about Error Code 429, but I want to make it clear that this is a slightly different question. This is a VBA excel program.

The code causing the problem :

Dim i As Integer
Dim j As Integer
Dim builder As String
Dim file As Object
Dim csv As Object

Set file = CreateObject("Scripting.FileSystem")
Set csv = file.CreateTextFile("configexport.csv")

The program breaks on the

Set file = CreateObject("Scripting.FileSystem")

I have a reference to scrrun.dll

I have registered scrrun.dll using an administrator command prompt and the command 'regsvr32 scrrun.dll'

I have restarted my computer

I am still seeing the error

NOTE: All other questions on this topic get resolved by this point so I do not consider this a duplicate. Any help would be appreciated.

What happens if you directly run a script that does this in VBScript and run it from a command window? Does it work from there? — Ken White
– Ken White, Commented Jun 28, 2013 at 17:01
@KenWhite It failed doing it that way as, Same error message(ActiveX component can't create object), error code : 800A01AD — SmashCode
– SmashCode, Commented Jun 28, 2013 at 17:42

Andy G · Accepted Answer · 2013-06-28 19:02:12Z

4

I assume you meant FileSystemObject, and I wouldn't use file as your variable name:

Set aFile = CreateObject("Scripting.FileSystemObject")

answered Jun 28, 2013 at 19:02

Andy G

19.4k5 gold badges49 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

SmashCode Over a year ago

You've got to be kidding me, this was it. I just wasted a couple hours. Thanks.

StayOnTarget Over a year ago

This is one reason why "early binding" can be an advantage. If that typo were made in an early binding scenario it would have failed to compile and probably highlighted the line. You could even initially test / proof of concept with early and then switch to late binding for release purposes if there is some good reason for using late in a scenario like this.

Collectives™ on Stack Overflow

Run-time Error 429 on Scripting.FileSystem object after scrrun.dll registered

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related