How do I create MS Excel in VB.NET?

[jbailey268]

In earlier VB one used the following.

ox=createobject("ExcelApplication")
ox.activepage.name="Pivot"
ox.columns(1).width = 15 etc. etc

I was informed that in VB.net that Createobject as such is unsupported.
I am currently using the 2005 Visual Studio.

How would one open the excel and programatically do all the low level things that I use to do.
I use to cut the macro created code and use it in another program - it worked great.

Thanks for your help.

 

[chiph]

You can use the Visual Studio Tools for Office, which is downloadable from Microsoft.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[rjoubert]

Use office interop...here's a good link to get you started...

http://www.dynamicajax.com/fr/Creating_Excel_From_VB_DOT_NET-197_209_329.html

 

[Sorwen]

I use CreateObject. *shrug*

-I hate Microsoft!
-Forever and always forward.

 

[jbailey268]

Thanks for your suggestions.

I used Createobject and it didn't work once. Maybe I gave up too soon (syntax error?); listened to others who said MS doesn't reccommend Createobject or support it. I'll try it again.

And thanks for those sites.

 

[Sorwen]

http://www.tek-tips.com/viewthread.cfm?qid=1406643

-I hate Microsoft!
-Forever and always forward.