Results 1 to 3 of 3

Thread: xlApp = GetObject line error

  1. #1
    Herry Markowitz's Avatar
    Herry Markowitz is offline VB.NET Forum Enthusiast
    .NET Framework
    .NET 4.0
    Join Date
    Oct 2015
    Posts
    38
    Reputation
    20

    xlApp = GetObject line error

    1.Ended all EXCEL.EXE processes from Windows Task Manager
    2.
    Run following code.
    Code:
    Process.Start("Excel.exe","/embedded ""C:\Book1.xlsx""")
    Threading.Thread.Sleep(5000)
    Dim xlApp As Excel.Application =Nothing
    xlApp =CType(GetObject("Excel.Application"), Excel.Application)

    3.
    See following error.
    Code:
    Cannot create ActiveX component 


    Any idea?
    Supported links:
    https://support.microsoft.com/en-us/kb/291288
    https://support.office.com/en-us/art...ID=HA102919739
    I am VBA expert.
    I am trying to be vb.net expert.

  2. #2
    JohnH's Avatar
    JohnH is offline VB.NET Forum Moderator
    .NET Framework
    .NET 4.5
    Join Date
    Dec 2005
    Location
    Norway
    Posts
    15,083
    Reputation
    2803
    How to format posts with code blocks etc - present the problem/post properly

    Visual Studio Community 2017

  3. #3
    Herry Markowitz's Avatar
    Herry Markowitz is offline VB.NET Forum Enthusiast
    .NET Framework
    .NET 4.0
    Join Date
    Oct 2015
    Posts
    38
    Reputation
    20
    I have tried all of them but there is no solution.
    I am VBA expert.
    I am trying to be vb.net expert.

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
  •