VS Tools for the Microsoft Office System... 1

[pzmgmb]

I was wondering if anybody has used the Microsoft Visual Studio Tools for the Microsoft Office System. The question I have is this... Would it be easier to export data to an excel worksheet using COM objects or Microsoft Visual Studio Tools for the Microsoft Office System. I would like to be able to "autofit" the columns and maybe some basic formatting in the export. I dont need any VBA code behind the spreadsheet nor will i be using buttons or macros or anything fancy.

I hope this is clear enough. I guess what i saying is that i want an easy to export a spreadsheet without there being any VB .NET hooks in the spreadsheet after i'm done exporting.

 

[ThatRickGuy]

I would jump for joy if there were a non-COM way of working with Office from .Net. That being said, what is this "Microsoft Visual Studio Tools for the Microsoft Office System" you mentioned?

-Rick

----------------------

http://www.ringdev.com

I believe in killer coding ninja monkeys.

 

[pzmgmb]

Try This Link

Visual Studio Tools for the Microsoft Office System

 

[Dimandja]

It looks like another name for "automation", when using the .NET framework:

http://blogs.officezealot.com/chris/archive/2004/03/26/1092.aspx

__________________________________________
Try forum1391 for lively discussions

 

[Dimandja]

>I guess what i saying is that i want an easy to export a spreadsheet without there being any VB .NET hooks in the spreadsheet after i'm done exporting.

Look at this code:

http://support.microsoft.com/kb/219151

__________________________________________
Try forum1391 for lively discussions

 

[ThatRickGuy]

/does a bouncy dance

and there will be much rejoicing after a solid block of research.

-Rick

----------------------

http://www.ringdev.com

I believe in killer coding ninja monkeys.

 

[pzmgmb]

ThatRickGuy,
Keep me posted. I'll let you know what i uncover also

 

[pzmgmb]

ThatRickGuy,

Just curious what you have learned about the VS Tools for Office.