VB.Net automation server & OfficeXP as client

Microsoft OFFICE

    Sponsored Links

    Next

  • 1. Hard-Coded FileName
    Is it possible to edit a hard-coded filename based on Application.GetOpenFileName? I am writing an application that will have many users. The network structure is constantly in flux, so the full name (ie: \\server\path) will likely change over the usable life of this application. I would like to store the path to external data in the application code, but make it editable. I guess, in short, I'm asking if it's possible to write a VBA code that will edit VBA code. -- Adios, Clay Harryman
  • 2. Adding reference to System.Data.Dataset for use in Outlook Macro
    Hi folks, I'm having a dickens of a time trying to use System.Data.Datase, I just can't seem to properly set a reference to the appropriate DLL|| TLB||OLB. It doesn't show up in the references window within the Script Editor, and if I attempt to add a reference by navigating to C: \WINDOWS\Microsoft.NET\Framework\v2.0.50727 and then clicking on System.dll or System.Data.dll or System.tlb, all I get is an error message stating that a reference could not be added. I obviously don't know what I'm doing. Hayelp! ccunning
  • 3. Removing Comment's reference text
    Hi, In order to insert a comment you need to highlight a character and then insert a comment. When I create the document, also I am insert a lots of comments and text for the comments. The text is a reference to my data source. I am opening a document in C# and the document and accessing the comments. I am using the comment as a reference to my data source. I get the collection of comments by using foreach (Word.Comment comment in WordDoc.Comments) { comment.Reference.InsertBefore("Value" + Mydata.ToString()); } and replace my data in the referenced location but I also want to remove the highlighted text from the document. Can any one knows how to do this? Thank you in advance.

VB.Net automation server & OfficeXP as client

Postby Dennis Wetherall » Fri, 02 Jan 2004 11:44:55 GMT

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.



VB.Net automation server & OfficeXP as client

Postby Dennis Wetherall » Mon, 05 Jan 2004 03:38:19 GMT

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

Re: VB.Net automation server & OfficeXP as client

Postby Thomas Winter » Wed, 07 Jan 2004 06:57:15 GMT





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



RE: VB.Net automation server & OfficeXP as client

Postby johnei » Wed, 07 Jan 2004 07:49:19 GMT

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://www.**--****.com/ 

185731 HOWTO: Call a VB ActiveX Server from a VBA Application
 http://www.**--****.com/ 

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" < XXXX@XXXXX.COM >
| 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.
| 
| 
| 


RE: VB.Net automation server & OfficeXP as client

Postby johnei » Wed, 07 Jan 2004 09:01:39 GMT

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://www.**--****.com/ 
 
317113 HOW TO: Automate Microsoft Access From Visual Basic .NET
 http://www.**--****.com/ 
 
303294 HOWTO: Use Automation to Get and to Set Office Document Properties 
with
 http://www.**--****.com/ 
 
You can search for specific topics from 
 http://www.**--****.com/ ;EN-US;KBHOWTO
 
Thank you for choosing the MSDN Managed Newsgroups,
 
John Eikanger
Microsoft Developer Support


Re: VB.Net automation server & OfficeXP as client

Postby Cindy M -WordMVP- » Thu, 08 Jan 2004 03:34:46 GMT

Hi Dennis, 

As Thomas mentioned, you don't need Office XP Developer for 
anything you've mentioned. Both VB6 and VB.NET can automate 
Office applications.

The question you need to pursue is: which environment is 
going to give you the best results?

The Office application are based on COM, as is VB6. VB.NET 
has to jump through a number of hoops (in the background) to 
communicate with COM-based applications.

Deployment and distribution of NET solutions is also more 
complicated than something made with VB6, especially if it 
is meant to be used "out of house" or across multiple Office 
versions.

If what you want to do is basically Office-oriented, and 
doesn't need the NET Framework as such, then it would 
probably be better to stick with VB6.


Cindy Meister
INTER-Solutions, Switzerland
 http://www.**--****.com/ (last update Sep 
30 2003)
 http://www.**--****.com/ 

This reply is posted in the Newsgroup; please post any 
follow question or reply in the newsgroup and not by e-mail 
:-)


RE: VB.Net automation server & OfficeXP as client

Postby v-phuang » Tue, 13 Jan 2004 15:24:36 GMT

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. 


Similar Threads:

1.using Outlook automation in VB.NET ASP.NET

I know this is not an outlook forum, but I've sent a few posts about this
very issue and cannot get any assistance. I hope someone here can help me
through their experience.

I am trying to send email using Outlook 2000. A simple block of code to
create and send the email works fine when used as a console app.

When the exact block of code is applied in an asp.net page, processing hangs
on my Recipients.Add(email address here) call. I walked away from it at
lunch thinking it would kick in once I got back but it just sat there doing
nothing.

I am using a domain admin for impersonation. Even then the block hangs on
the Recipients.Add call.

anyone know why?


2.VB.Net calling Excel automation server

Is there a way to test an Excel application object to see 
if it is "valid"? Same question for a workbook.
Testing for "Nothing" doesn't work, because even after a 
workbook has been closed or the application quit (by the 
user) the reference variables still point to "something". 
However, any operation that I've tried tends to generate 
an exception.

In general, I have found this to be very frustrating. I 
pay a lot of money for an MSDN Universal subscription, 
and there is precious little documentation about what I 
would consider fairly simple tasks. I have found a 
handful of examples, but they are usually neither robust 
enough nor complete enough. I wonder, are other people 
similarly frustrated? Am I missing something?

3.How To Control a .NET EXE With .NET Client (Something Like Word Automation)

I want to write a single instance application with one 
main form that exposes an object model that that be 
controlled via one or more applications on the same 
machine.  Basically an out-of-process server.  

Similiar to how Microsoft Word or Excel Automation works 
but a pure .NET version for both the application and the 
client that is controlling it.

Any ideas on how this is accomplished in .NET?  It was 
really easy to do with Visual Basic 6.0 and ActiveX Exe 
project types.

Thanks for any help.

Mark

4.Word Automation using ASP .NET and VB .NET

I would like to implement word automation in my porject. I 
am using ASP .NET and VB .NET. The user will select some 
template documents from the web site and click on a 
button. The button will perform all the merging of the 
selceted documents into a single document. Has anyone come 
across this kind of requirement. If yes, please suggest me 
the way, how can I go ahead and design the system. I am 
aware of that Microsoft will not recommand the office 
automation on the web server. But I don't have another 
choice, Please help me in this.

Thanks and Regards,
Srini

5.Client- Server Programming using VB.NEt & SQL SERVER

I have to submit a project as a part of my final year project.
I consulted various domains and finally decided to implement a work on
delevoping a system for transcription work based company.

The overall flow is somewhat like this the client either and indiviudal
or a department is given access rights to a Toffice (transcription
office) and adds files to his table and connects it through a web
server (IIS)  by generating XML files and Version files and the files
are to be uploaded through FTP.
the access by the customer is either dept. wise or indiviual client
wise.
The Transcription employee logs in through the OFFICE module and
downloads the files (.avi) and edits it in his own editor into a text
file and upgrades its status as transcripted and saves it to the
database with the avi files.
The Editor logs in through the Office module and edits those files,
indexs it out for any error and loads it back for the administrator.
The administrator logs in and access the files to be uploaded back as
transcripted files to the customer or its department.
The files are generated and moved randomnly across the server and
client through employee modules, office modules, server modules and
other
The administrator logs in and grants access rights to all client and
other

This whole implementation is expected to be in WIN Forms
Can anybody out there just help in this regard.
I think a 2-tier database ot n-tier database can be sorted out, but to
initiate it i am facing a lot problems.
Can anyone out ther help me in this matter and can just pass on with
the iniital coding.

6. Outlook Automation using VB.Net

7. Client-side Word Automation from asp.net

8. Outlook 2003 Calendar functionality within VB.Net client applicati



Return to Microsoft OFFICE

 

Who is online

Users browsing this forum: No registered users and 99 guest