Automating Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fabio Coatis - 13 Nov 2003 18:41 GMT

Just created an Excel.dll with: TlbImp Excel9.olb Excel.dll

Then created the using directives:
using System;
using System.Reflection; // For Missing.Value and BindingFlags
using System.Runtime.InteropServices; // For COMException
using Excel;

But when I try to compile I got the error stating that I needed a
using directive or a reference to Assembly.

Sorry if this is basic but I´m quite new to .Net.

Thanks in advance

Reply to this Message

Scott Glasgow - 13 Nov 2003 19:52 GMT

try
using Microsoft.Office.Interop.Excel

> Just created an Excel.dll with: TlbImp Excel9.olb Excel.dll
>
[quoted text clipped - 10 lines]
>
> Thanks in advance

Reply to this Message

Phil Wilson - 14 Nov 2003 00:32 GMT

And think about using the official interop assemblies if you're using XP..

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/od
c_oxppias.asp

Signature

Phil Wilson [MVP Windows Installer]
----

> try
> using Microsoft.Office.Interop.Excel
[quoted text clipped - 13 lines]
> >
> > Thanks in advance

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...