Documentation on programming Excel from Vis. Studio StandardEdition.

[zaster39sap]

I've written a VB.NET app using Visual Studio 2008, Std. Edition. I
want it to create and write to an Excel 2007 file. I have it doing
most of the operations I want it to do. This article by Ken Getz gave
me enough information to get started.

http://msdn.microsoft.com/en-us/library/aa537184(office.11).aspx

But there are others operations I need, like setting column width,
that I can't find in that paper and all the other documentation I find
for automating Excel is for users of Visual Studio Tools for Office
which comes only with VS Pro Edition. Looks like the principal way to
automate MS Office is by using Visual Studio Tools for Office. Yet
clearly some of it can be done with VS Std. Edition because I've done
it.

My question is: other than the article I cite above, where can I find
a clear statement on what I can do with Office 2007 from VS Std Ed?
Is there no documentation for VS Std Ed users?

Thanks.

 

[joel]

You should be able to do everything that you can do with regular excel in
VB.Net provided you use Application boefore the command and tthe correct
libraries are loaded in VB.Net. VB.Net is an improvement to VB6 and has more
features than the VBA in excel. But even from VBA in excel you can do
everything that yo can do in VB.Net or VB6 by calling the Wind32 DLL
functions.

If you can't find the documentation on any of the functions assume that they
will work exactly like the VB6 or Excel VBA. the only thing you have to be
carefully about is the Application. The VBA in Excel is different from the
VBA in Access. So when you open an excel application you may need to use obj
= CreateObject("Excel.Application") and when you use Access functions you
need an Access object like obj = CreateObject("Access.Application").

 

[zaster39sap]

You should be able to do everything that you can do with regular excel in
VB.Net provided you use Application boefore the command and tthe correct
libraries are loaded in VB.Net.  VB.Net is an improvement to VB6 and has more
features than the VBA in excel.  But even from VBA in excel you can do
everything that yo can do in VB.Net or VB6 by calling the Wind32 DLL
functions.

If you can't find the documentation on any of the functions assume that they
will work exactly like the VB6 or Excel VBA.  the only thing you have to be
carefully about is the Application.  The VBA in Excel is different fromthe
VBA in Access.  So when you open an excel application you may need to use obj
= CreateObject("Excel.Application") and when you use Access functions you
need an Access object like obj = CreateObject("Access.Application").

Joel,

OK so I should be able to do what I want to do but what documentation
or reference manuals can I use? Should I just use the VBA for Excel
reference doc?

Thanks.