+ Reply to Thread
Results 1 to 2 of 2

Run-time error '430' Class does not support Automation issue, please help!

  1. #1
    Registered User
    Join Date
    10-04-2016
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    2

    Run-time error '430' Class does not support Automation issue, please help!

    This code works on 9/10 of the computers, however on one of them I keep getting this error:

    "Run-time error '430' Class does not support Automation or does not support expected interface"


    If anyone know why this is please let me know!

    Please Login or Register  to view this content.

    gYhF0tk.png

    Thank you!

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Run-time error '430' Class does not support Automation issue, please help!

    Open the VB editor and go to Tools -> References. Make sure Microsoft Shell Controls and Automation is checked.
    Attached Images Attached Images
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Class does not support Automation or does not support expected interface
    By ccs_1981 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2015, 05:57 AM
  2. Class does not support automation
    By mikeTRON in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-07-2013, 10:12 AM
  3. runtime 430 error- Class does not support Automation or does not support...
    By kimcole5 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2012, 01:27 PM
  4. Class does not support Automation
    By donyc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-17-2011, 10:29 PM
  5. Class does not support automation (err 430) - on copyfromrecordset
    By tjharlan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2007, 03:31 PM
  6. Error 430: Class does not support automation...
    By pagates in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2005, 03:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1