How to automate Microsoft Excel from Visual Basic

[rnosratabadi]

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]

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?

[Stewart Ross]

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

[rnosratabadi]

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