Can I still use Microsoft.Office.Interop assemblies with office 2013? -


i had import older project (in .net 2) visual studio 2013, makes use of microsoft primary interop assemblies.

visual studio said need add references project. went , did reading , apparently microsoft has released pia office 2010? (i have office 2013)

now know is.

  1. can work office 2013 , backward compatible?
  2. and if route go future? going compatible? because see need .net 2 (at latest) , windows 8 comes 4.5 , not 3 (by default) , new computers going have office 2012 or 2013.

pias historical artifact, required old .net versions (before v4). have been thoroughly , elegantly replaced "embed interop types" feature, known "no pia" feature. supported since visual studio 2010, you'll find in properties window when select reference assembly. defaults true. video covers underlying technology available here.

which reason microsoft doesn't publish pias office 2013, expect embed interop types instead.

the feature desirable, avoids customer having install pias on machine , include them installer. solving issue when neither takes care of it, entirely common mishap. in addition, pias office large, great advantage of embedding interop types assembly contain types use. many megabytes reduced few kilobytes.

the workflow little different. instead of adding reference microsoft.office.interop assemblies available in add reference dialog, .net framework tab, use com tab. , pick, say, "microsoft excel 15.0 object library" generate interop types program uses excel. if load old project used pias remove reference assemblies , add them com tab.

do note feature lost, intentionally targeting old version of office don't have installed on dev machine more difficult. if that's requirement still need pias version, force embed interop types true in properties window. doing questionable, microsoft has hard time keeping new office versions compatible old versions. they've kept 15 years has been running out of steam. worst-case scenario targeting newer version have installed on machine, that's liable make program crash very hard diagnose exceptions accessviolationexception.

do note have make small modifications code allow work. synthetic "xxxxclass" classes not embedded, "xxxx" interfaces. remove word "class" new statement.


Comments

Post a Comment

Popular posts from this blog

c# - Validate object ID from GET to POST -

i have method allows user access comment have made on site. have post method lets them update comment. my normal solution send entire comment model through, let them update it, update on database when post back. involve sending commentid through in hiddenfor , can manipulated. how can verify commentid sent in get method same i'm getting in post , not able alter comment wish? how can verify commentid sent in method same i'm getting in post? basically have validate following things in post - user logged-in user. authenticated users post comments. commentid in post , should valid commentid , should present in database. userid associated logged-in user should same userid associated comment . comment should contain userid column, can check @ time of update. to make sure update happens comment has been sent in get - hold commentid in session , in post action compare commentid value in session .
Read more

node.js - Custom Model Validator SailsJS -

when using custom model validator checks record within model. return within spread doesn't seem end control flow. //post.js model /** * custom validator **/ types: { isuservalid: function(user_id) { var promise = require('bluebird'); promise.all([ user.findone({id: user_id}) ]) .spread(function(user) { console.log(user); if (user === null || user === undefined) { console.log('failed'); return false; }else{ console.log('passed'); return true; } }); } }, my response standard validation failed response. { "error": "e_validation", "status": 400, "summary": "1 attribute invalid", "model": "post", "invalidattributes": { "owner": [ { "rule": "isuservalid", ...
Read more

php - Find a regex to take part of Email -

i have following emails need extract part from: bestellnummer xxx: 1 von xxx, 1er pack ------------- anfang der nachricht ------------- foo bar baz foo bar baz // <<<<< need text here ------------- ende der nachricht ------------- ------------- anfang der nachricht ------------- foo bar baz foo bar baz ------------- ende der nachricht ------------- there 0 unlimited occurences of ------------- anfang der nachricht ------------- ------------- ende der nachricht ------------- and i'm able extract first part regex: $re = "/------------- .*? -------------.?(.*?).?------------- .*? -------------/s"; but, i'm quite new on learning regex, i'm pretty sure there must better regex extract part (foo bar baz foo bar baz) of text between ------------- anfang der nachricht ------------- ------------- ende der nachricht ------------- as can in different languages, i'm using .? to match between hyphens. i...
Read more