+ Reply to Thread
Results 1 to 5 of 5

Run-time error'-2147221080 (800401a8)': Automation error

  1. 08-28-2014, 03:40 AM #1
    baig123
    baig123 is offline
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Run-time error'-2147221080 (800401a8)': Automation error

    i am trying to save inthe path but it showing an error why

    please help me out

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 08-28-2014, 03:48 AM #2
    nathansav
    nathansav is offline
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Run-time error'-2147221080 (800401a8)': Automation error

    I think its cause you are setting WS then opening another workbook. Try setting WS before you do the search.

    The line of code works fine.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me
    Reply With QuoteRegister To Reply
  3. 08-28-2014, 04:02 AM #3
    baig123
    baig123 is offline
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: Run-time error'-2147221080 (800401a8)': Automation error

    please let me know were i little bit confuse
    Reply With QuoteRegister To Reply
  4. 08-28-2014, 04:08 AM #4
    nathansav
    nathansav is offline
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Run-time error'-2147221080 (800401a8)': Automation error

    Set ws = Worksheets("sheet1")

    If info = False Then
    Workbooks.Open ("C:\Documents and Settings\usman\My Documents\workstation")
    End If
    Reply With QuoteRegister To Reply
  5. 08-28-2014, 05:12 AM #5
    baig123
    baig123 is offline
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: Run-time error'-2147221080 (800401a8)': Automation error

    thanks its working
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Facing 'run-time error -2147217871 (80040e31) Automation error' in excel VBA
    By junaidanjum in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2013, 03:48 AM
  2. Run-time error '-2147417848 (80010108)':Automation error.The object invoked has disconnect
    By hydz1213 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-15-2013, 09:02 AM
  3. 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
  4. -2147221080 800401a8 Automation error
    By JoanExcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-10-2009, 05:46 AM
  5. [SOLVED] Run-Time Error'-2147221080(800401a8)': Automation Error
    By BEEJAY in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2006, 10:15 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1