Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Documentation on programming Excel from Vis. Studio StandardEdition.
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/libr...ffice.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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Documentation on programming Excel from Vis. Studio Standard Edit
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"). " wrote: 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/libr...ffice.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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Documentation on programming Excel from Vis. Studio Standard Edit
On Apr 30, 6:26*am, joel wrote:
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"). " wrote: 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/libr...ffice.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, 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Studio and Excel | Excel Programming | |||
excel 2003 and c++ API documentation? | Excel Programming | |||
Visual Studio .Net C# and Excel | Excel Programming | |||
Look up VBA documentation using Excel Help | Excel Programming | |||
Documentation 4 Excel Web Component | Excel Programming |