Solved

Office Interop Files

Posted on 2006-11-10
10
324 Views
Last Modified: 2010-04-23
Hi,

When I set reference to Excel and compile my app, I get few Interop files as:
Interop.Microsoft.Office.Core.dll
Interop.VBIDE.dll
Interop.Excel.dll

The server machine has ms-offce. Should I still distribute the files? The client machines are thin clients as they using Citrix Metaframes with Terminal Services.

Regards,
MI
0
Comment
Question by:vj_mi
10 Comments
 
LVL 10

Expert Comment

by:Kinger247
ID: 17913181
yes you should !
0
 
LVL 8

Expert Comment

by:razo
ID: 17913186
no need to distirbute just make sure the users have office installed with .net programability for each of the office application u r going to use
0
 
LVL 10

Expert Comment

by:Kinger247
ID: 17913187
Look at them as a kind of interface between your app the the excel files themselves.
0
 
LVL 10

Expert Comment

by:Kinger247
ID: 17913190
razo I've never got anything to work without these files ..???
0
 
LVL 8

Expert Comment

by:razo
ID: 17913216
well first u should make sure that u reference these files thru the GAC and as i said the office should be installed with .net programmability support
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:vj_mi
ID: 17913239
razo .... What do you mean by  .net programability support?
I added ref to these files from Add References and used tab page COM to set the reference. Also we must note that the client machines are thin clients with nothing installed on it other than the OS and SQL client. My application and all other softwares are installed on the server.

Regards,
MI
0
 
LVL 10

Expert Comment

by:Kinger247
ID: 17913260
Didn't know there was a '.net programmability support' option in office setup.
I presume this then creates the interop files for you.

So the test would be to try and run the app, if it doesn't work load the interop files form your project/bin.
But the answer is still 'yes', still distribute the files unless you know the files where not installed with office on setup.
0
 
LVL 10

Expert Comment

by:Kinger247
ID: 17913264
sorry :

But the answer is still 'yes', still distribute the files unless you know the files 'where' installed with office on setup.
As a rule you should anyway.
0
 
LVL 8

Expert Comment

by:razo
ID: 17913271
when u install office (if it not fully installed) u can tick .netprogrammability supprt....it is something that comes with office CD
0
 
LVL 18

Accepted Solution

by:
DarrenD earned 500 total points
ID: 17914651
Hi,

FYI...

You should not use the Interop files that are created using .NET Visual Studio at design time.

http://support.microsoft.com/kb/328912

You should be using the Primary Interop Assemblies (PIA's)

Darren.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now