Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Microsoft ISV Community Center Forums >> Visual Basic for Applications (VBA)

Unable to create FileSystemObject in Access VBA

I have encountered an error when trying to create a FileSystemObject. This code has been running fine for about a year and a half, but now on one system my user is recieving:

"Run-Time error '429'

ActiveX component can't create object"

The error occurs on this line:

Dim fso as Object

fso = CreateObject("Scripting.FileSystemObject")

[480 byte] By [WolvenGarde] at [2007-12-23]
«« passing commands to VBA in PPT?
»» IO Completion Listener Worker appears to be non-yielding Message
# 1
First thought that occurs to me is that the Reference to the Scripting
library may be broken on that machine (perhaps it's not even installed?)
Open the VB editor, view the project, go to Tools/References and see if
it's still activated.

CindyMeister at 2007-8-30 > top of Msdn Tech,Microsoft ISV Community Center Forums,Visual Basic for Applications (VBA)...
# 2

I have the same problem. But with what appears to be several hundred reference libraries to choose from which one should i attemp to activate?

dave_paradies at 2007-8-30 > top of Msdn Tech,Microsoft ISV Community Center Forums,Visual Basic for Applications (VBA)...
# 3
Dim fso as Scripting.FileSystemObject

set fso = new Scripting.FileSystemObject

Also reference the MS Scritping Runtime. That's all I can do.

magicalclick at 2007-8-30 > top of Msdn Tech,Microsoft ISV Community Center Forums,Visual Basic for Applications (VBA)...
Microsoft ISV Community Center Forums
Visual Basic for Applications (VBA)

Microsoft ISV Community Center Forums Hot Topic

Microsoft ISV Community Center Forums New Topic

Microsoft ISV Community Center Forums

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified