How to automate Microsoft Excel from Visual Basic

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rnosratabadi
    New Member
    • Jun 2014
    • 2

    How to automate Microsoft Excel from Visual Basic

    hi,
    i have Office 2013.
    i don't have this items. i have Microsoft Office 15.0 Object Library in the References list. i tick this but dose not work this codes .
    please help me !
  • Luk3r
    Contributor
    • Jan 2014
    • 300

    #2
    Maybe you need to add a reference to Microsoft.Offic e.Interop.Excel (From the .NET tab in references), then at the top of your project add Imports Microsoft.Offic e.Interop?

    Comment

    • Stewart Ross
      Recognized Expert Moderator Specialist
      • Feb 2008
      • 2545

      #3
      You need to tick the reference to Microsoft Excel Object Library itself. The one for Office that you mention just gives you access to the common office dialogues etc.

      -stewart
      Last edited by Stewart Ross; Jun 18 '14, 08:24 AM.

      Comment

      • rnosratabadi
        New Member
        • Jun 2014
        • 2

        #4


        thank you,

        i dont have .NET tab in references and Imports Microsoft.Offic e.Interop.
        i dont have Microsoft Excel Object Library myself, just is Microsoft Office 15.0 Object Library in the References list. i tick this but dose not work this codes .

        this version of visual basic is vb6.0

        Comment

        Working...