Run-time error '429': ActiveX component can't create object error occurring while executing the statement CreateObject("Scripting.FileSystemObject") in MS office 2016 64bit and windows 11 64bit

srinivas siddam 0 Reputation points
2023-05-19T05:06:26.74+00:00

Run-time error '429': ActiveX component can't create object error occurring while executing the statement

Dim fso As Object

set fso = CreateObject("Scripting.FileSystemObject")

in MS office 2016 64bit and windows 11 64bit

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,661 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,935 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Limitless Technology 44,101 Reputation points
    2023-05-19T11:31:40.4566667+00:00

    Hello

    Thank you for your question and reaching out.

    This error occurs when the Component Object Model (COM) cannot create the requested Automation object, and the Automation object is, therefore, unavailable to Visual Basic. This error does not occur on all computers.

    In Visual Basic, there are several causes of error 429. The error occurs if any of the following conditions is true:

    There is a mistake in the application.

    There is a mistake in the system configuration.

    There is a missing component.

    There is a damaged component.

    To find the cause of the error, isolate the problem. If you receive the "429" error message on a client computer, use the following information to isolate and resolve the error in Microsoft Office applications.

    Reference:

    https://support.microsoft.com/topic/b6070e15-ea78-4349-2751-72bdb5f186f7

    --If the reply is helpful, please Upvote and Accept as answer--

    0 comments No comments

  2. srinivas siddam 0 Reputation points
    2023-05-24T06:20:49.6366667+00:00

    How do we check whether the mistake is in

    system configuration.

    There is a missing component.

    There is a damaged component.

    Thanks

    0 comments No comments