+ Reply to Thread
Results 1 to 4 of 4

Automation Error - Unknown Cause

  1. #1
    Registered User
    Join Date
    03-19-2018
    Location
    Goulburn
    MS-Off Ver
    MS Office Professional Plus 2016
    Posts
    35

    Question Automation Error - Unknown Cause

    Hey Everyone,

    I have two buttons that do almost the same thing, they both start different one (add songs) ports straight to a userform the other (new practice list) creates a new sheet then ports to the userform.

    I have add songs working perfectly, but new practice list comes up with automation error in the userform.

    I don't want to adjust it because one works and i certainly don't want to create another one, i'm assuming something is changing in the gobal variables that wouldn't normally in the other.

    Could someone have a look over it and find what i have missed


    You will need to download both sheets into the same folder (don't change their names) as one doesnt work without the other. The workbook i am working on is practice lists, on the interface page


    Thanks

    Bensley
    Attached Files Attached Files

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Automation Error - Unknown Cause

    It looks like the program doesn't know what pst is
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    03-19-2018
    Location
    Goulburn
    MS-Off Ver
    MS Office Professional Plus 2016
    Posts
    35

    Re: Automation Error - Unknown Cause

    Ok i see that in there, but why ? both set what pst and dtb are exactly the same why isn't it able to call upon it that way ?

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Automation Error - Unknown Cause

    Excel is literally minded and everything must be exactly defined

+ 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. Loop Nesting is returning Run-Time Error '-2147221080 (800401a8)': Automation Error
    By ChristopherBrandonKi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2014, 02:36 PM
  2. [SOLVED] Run-tim error -2147467259(80004005): Automation error Unspecidied error
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2014, 12:12 PM
  3. Replies: 5
    Last Post: 10-08-2013, 04:33 PM
  4. Getting automation error the interface is unknown when navigating IE thru VBA
    By belle08 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2013, 05:37 AM
  5. Replies: 7
    Last Post: 05-15-2013, 09:02 AM
  6. run-time error ;2147023179 (800706b5) time automation error interface unknown
    By karthik72 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-02-2012, 09:31 AM
  7. [SOLVED] Help with this error Unknown reason for error with Range().Select
    By Brad Sumner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2005, 12: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