VB.Net automation server & OfficeXP as client

[Dennis Wetherall]

I coded a system that uses OfficeXP (Word XP, Access XP,
and Outlook XP) and MS Project 2000 as automation
servers. Currently I use MS Project 2000 VBA as the
automation server, but my question has to do with porting
it to either VB6 or VB.Net.

Last week, I purchased an MSDN Universal subscription, so
that I could port it to VB6, meaning, I planned on
creating a VB6.exe to be my automation server.

As it turns out Office XP developer became "retired
download content" on 12/23/03, before I could download
it.

So I am assessing the feasibility of using VB.NET to act
as an automation client.

It possible to mix VB.NET and Office XP in the following
way: VB.Net = automation server and Office XP (Word,
Access and Outlook) =automation client?

By the way this is first time I have ever posted to any
newsgroup whatsoever, so I hope I am posting this
question correctly.

 

[Dennis Wetherall]

The second sentence should read :Currently I use MS
Project 2000 VBA as the

 

[Thomas Winter]

I coded a system that uses OfficeXP (Word XP, Access XP,
and Outlook XP) and MS Project 2000 as automation
servers. Currently I use MS Project 2000 VBA as the
automation server, but my question has to do with porting
it to either VB6 or VB.Net.

Last week, I purchased an MSDN Universal subscription, so
that I could port it to VB6, meaning, I planned on
creating a VB6.exe to be my automation server.

As it turns out Office XP developer became "retired
download content" on 12/23/03, before I could download
it.

So I am assessing the feasibility of using VB.NET to act
as an automation client.

It possible to mix VB.NET and Office XP in the following
way: VB.Net = automation server and Office XP (Word,
Access and Outlook) =automation client?

By the way this is first time I have ever posted to any
newsgroup whatsoever, so I hope I am posting this
question correctly.

I cannot address the VB.NET question, but you don't really need Office XP
Developer to write a VB6 app for Office XP. You really only need VB6 and
Office XP. The documentation for the Office XP object model comes with
Office XP.

-Tom

 

[John Eikanger [MSFT]]

Hi, Dennis

By Office XP Developer, do you mean the developer edition of Office XP? If
so, let me know and I will see if we can work something out.

There are a number of Knowledge Base articles on how to control Office
applications from both VB6 and VB.Net. Similarly, you can reference VB6
and VB.Net server DLLs from Office applications. Here are a couple of
articles that may prove helpful for starters:

301982 HOWTO: Automate Microsoft Excel from Visual Basic .NET
http://support.microsoft.com/?id=301982

185731 HOWTO: Call a VB ActiveX Server from a VBA Application
http://support.microsoft.com/?id=185731

If you could provide more information about what you are trying to
accomplish, we can probably help you out.

Thank you for choosing the MSDN Managed Newsgroups,

John Eikanger
MSDN Communities Team
Microsoft Developer Support
--------------------
| Content-Class: urn:content-classes:message
| From: "Dennis Wetherall" <[email protected]>
| Subject: VB.Net automation server & OfficeXP as client
| Date: Wed, 31 Dec 2003 18:44:55 -0800
| X-Tomcat-NG: microsoft.public.office.developer.vba
|
| I coded a system that uses OfficeXP (Word XP, Access XP,
| and Outlook XP) and MS Project 2000 as automation
| servers. Currently I use MS Project 2000 VBA as the
| automation server, but my question has to do with porting
| it to either VB6 or VB.Net.
|
| Last week, I purchased an MSDN Universal subscription, so
| that I could port it to VB6, meaning, I planned on
| creating a VB6.exe to be my automation server.
|
| As it turns out Office XP developer became "retired
| download content" on 12/23/03, before I could download
| it.
|
| So I am assessing the feasibility of using VB.NET to act
| as an automation client.
|
| It possible to mix VB.NET and Office XP in the following
| way: VB.Net = automation server and Office XP (Word,
| Access and Outlook) =automation client?
|
| By the way this is first time I have ever posted to any
| newsgroup whatsoever, so I hope I am posting this
| question correctly.
|
|
|

 

[John Eikanger [MSFT]]

Hi, Dennis

The object model of the server is what controls how you access one of the
Office server apps. The code is pretty much the same in VB6 as it is in
VBA. VB.Net is a different, but not all that different. Here are 3
articles on automating Outlook, Word, and Access from VB.Net

313789 HOW TO: Create a Meeting Request by Using Outlook Object Model in
Visual Basic .Net
http://support.microsoft.com/?id=313789

317113 HOW TO: Automate Microsoft Access From Visual Basic .NET
http://support.microsoft.com/?id=317113

303294 HOWTO: Use Automation to Get and to Set Office Document Properties
with
http://support.microsoft.com/?id=303294

You can search for specific topics from
http://support.microsoft.com/default.aspx?scid=fh;EN-US;KBHOWTO

Thank you for choosing the MSDN Managed Newsgroups,

John Eikanger
Microsoft Developer Support

 

[Peter Huang]

Hi Dennis,

Did you have any concern on this issue?
If so please post in the newsgroup.

Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.