dcsimg
Results 1 to 5 of 5

Thread: ActiveX component can't Create object Excel.Applicaton

  1. #1

    Thread Starter
    New Member
    Join Date
    Sep 2018
    Posts
    3

    ActiveX component can't Create object Excel.Applicaton

    Hi Team, getting an error "ActiveX component can't Create object Excel.Applicaton" when executing .VBS file.

    Office Version is : MS Office 2016 32 bit
    OS : Windows 7 Pro

    Help me resolve this issue.

    Code:
    Dim objExcel, args
    set args = wscript.Arguments
    Set objExcel = Createobject("Excel.Application")
    objExcel.visible = True
    objExcel.Application.Run "'C:\Users\Yantrea\Desktop\Test.xlsm'!Test.TestTotal"
    objExcel.DisplayAlerts = False
    objExcel.Application.Save
    objExcel.Application.Quit
    Set objExcel = Nothing
    Name:  Error.PNG
Views: 267
Size:  17.7 KB

    Warm Regards
    A3

  2. #2
    Frenzied Member
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    1,176

    Re: ActiveX component can't Create object Excel.Applicaton


  3. #3

    Thread Starter
    New Member
    Join Date
    Sep 2018
    Posts
    3

    Re: ActiveX component can't Create object Excel.Applicaton

    I tried to execute the .VBS code %windir%\SysWOW64\cscript.exe _schedule.vbs with command line got same error ..
    Name:  error1.jpg
Views: 86
Size:  6.2 KB
    %windir%\SysWOW64\wscript.exe _schedule.vbs
    Name:  error2.jpg
Views: 85
Size:  17.4 KB

    Help much appreciated.

    Warm Regards
    A3

  4. #4

    Thread Starter
    New Member
    Join Date
    Sep 2018
    Posts
    3

    Re: ActiveX component can't Create object Excel.Applicaton

    I tried to execute the .VBS code %windir%\SysWOW64\cscript.exe _schedule.vbs with command line got same error ..
    Name:  error1.jpg
Views: 86
Size:  6.2 KB
    %windir%\SysWOW64\wscript.exe _schedule.vbs
    Name:  error2.jpg
Views: 85
Size:  17.4 KB

    Help much appreciated.

    Warm Regards
    A3

  5. #5
    Frenzied Member
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    1,176

    Re: ActiveX component can't Create object Excel.Applicaton

    Include the full path to the vbscript file in your command.

    What version of Office is installed on the computer, and is it the 32-bit or 64-bit version?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width