473,322 Members | 1,566 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

MS Office and .NET framework

Helllo,

is there a version of Microsoft Office, where you can link .NET Dll's (
assemblies ) with it, instead of COM Dll's? If not, does anybody know when
there will be?

Thank you for any info,

Me.
Jul 21 '05 #1
4 1589
There is no version of Office at present that exposes a .Net interface to
its object model, but Microsoft has primary interop assemblies available for
calling Office objects via COM from .Net. But unfortunately it has to go
thru the COM Interop and the marshalling can be painfully slow if you are
transferring large amounts of data.

In our project we have basically implemented an Excel XLA addin to help make
the communication with .Net "chunky" rather than "chatty" so that the
performance hit is kept to a minimum. There are numerous articles on
designing of "chunky" vs "chatty" interfaces to help with the COM interop
issues on MSDN.

If I had to guess, I would say that a version of office that is pure .Net is
still a good distance away, but I'm really really hoping that Microsoft
releases an interface that does a much more efficient job marshalling the
data.
"Elephant" <el******@microsoft.com> wrote in message
news:TJ********************@casema.nl...
Helllo,

is there a version of Microsoft Office, where you can link .NET Dll's (
assemblies ) with it, instead of COM Dll's? If not, does anybody know when
there will be?

Thank you for any info,

Me.

Jul 21 '05 #2
Bryan wrote:
There is no version of Office at present that exposes a .Net interface to
its object model,


??

What's the score with Office 2003? What is the "official" way to program
it, surely it can't be VBA??

--
Gerry Hickman (London UK)
Jul 21 '05 #3

"Gerry Hickman" <ge********@yahoo.co.uk> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
Bryan wrote:
There is no version of Office at present that exposes a .Net interface to
its object model,
??

What's the score with Office 2003? What is the "official" way to program
it, surely it can't be VBA??


You can code it with VBA, or thru external automation - but all the
interfaces are still COM. The only way to code it thru .Net is to use the
interop.

Bryan

--
Gerry Hickman (London UK)

Jul 21 '05 #4
Bryan wrote:
What's the score with Office 2003? What is the "official" way to program
it, surely it can't be VBA??


You can code it with VBA, or thru external automation - but all the
interfaces are still COM. The only way to code it thru .Net is to use the
interop.


Doesn't exactly inspire confidence if Microsoft's flagship product does
not directly support .NET

Was there not something called VSA that was going to enable office apps
to work direct with .NET?

--
Gerry Hickman (London UK)
Jul 21 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Jason | last post by:
Hi, I have managed to automate the inclusion of the framework and SP into my installs but have hit a brick wall on being able to switch on the Programmabilty support for office applications...
3
by: | last post by:
Hi! How to extand and access the internat Office object structure. Is there any Dev Kit for Microsoft Partners that in not available to "normal" users? Something like NOKIA back entrence!? ...
4
by: J-T | last post by:
I'm trying to read an excell file in my .Net application using Office XP Primary Interop Assemblies (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_oxppias.asp)....
0
by: Howard Kaikow | last post by:
I have a multiboot system. On one of the systems, I have Office 2002, VS .NET Pro 2002 and the Office 2002 PIA with .NET Framework 1.0. On another system, I have Office 2003, VS .NET Pro 2003...
3
by: Jason | last post by:
Hi, I have managed to automate the inclusion of the framework and SP into my installs but have hit a brick wall on being able to switch on the Programmabilty support for office applications...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.