Example files are available to registered members only... Register and login !

Author Topic: Microsoft.Office.Interop.Excel libraries  (Read 1179 times)

Offline GhosttalkerST

  • Newbie
  • *
  • Posts: 5
  • Karma: +0/-0
  • SfE user
Microsoft.Office.Interop.Excel libraries
« on: October 20, 2014, 10:31:10 AM »
Hi,


I have to use the Office Interop library to open Excel but the add-in does not work with this. Is there any chance to get the add-in working with [/size]Microsoft.Office.Interop.Excel libraries? I think it is described here: http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.addin(v=office.15).aspx?cs-save-lang=1&cs-lang=vb#code-snippet-1
I strongly need it and I want to pay for the amount of work.

Kind Regards.
Stephan
 
« Last Edit: October 20, 2014, 12:32:56 PM by GhosttalkerST »

Offline Fabrice

  • Moderator
  • Administrator
  • Sr. Member
  • *****
  • Posts: 135
  • Karma: +18/-0
  • Creator of Sparklines for Excel
    • Sparklines for Excel
Re: Microsoft.Office.Interop.Excel libraries
« Reply #1 on: October 20, 2014, 06:30:41 PM »
Why would you need Microsoft.Office.Interop.Excel ?
I understand this reference is required for .Net or C# projects, but SfE is VBA.
This file should be present on your PC if Excel has been installed.
« Last Edit: October 20, 2014, 06:56:45 PM by Fabrice »
Fabrice Rimlinger - Creator of Sparklines for Excel
MacBook Pro Retina
Office 2011 for Mac
Virtual machine : Windows 7 - Office 2013 x32

Offline GhosttalkerST

  • Newbie
  • *
  • Posts: 5
  • Karma: +0/-0
  • SfE user
Re: Microsoft.Office.Interop.Excel libraries
« Reply #2 on: October 20, 2014, 07:44:36 PM »
Hi,


I am using a special report-software. My guess is that the Office Interop library that the report-software uses to Open Excel has some how suspended the add-in.
[/size]Is there anything that can be done to have it work when it is called from Microsoft.Office.Interop.Excel libraries?

[/size]Kind Regards
[/size]Stephan
 

Offline Fabrice

  • Moderator
  • Administrator
  • Sr. Member
  • *****
  • Posts: 135
  • Karma: +18/-0
  • Creator of Sparklines for Excel
    • Sparklines for Excel
Re: Microsoft.Office.Interop.Excel libraries
« Reply #3 on: October 23, 2014, 10:24:36 AM »
Hi Stephan,

As a first analysis, I would say that SfE should be listed as an authorized add-in inside your reporting tool.

In any case, you could use the template file (attached) that contains SfE macros and is therefore not depending on the Interop Libray and is easy to distibute as users do not have to install SfE.

Rgds

Fabrice Rimlinger - Creator of Sparklines for Excel
MacBook Pro Retina
Office 2011 for Mac
Virtual machine : Windows 7 - Office 2013 x32

Offline GhosttalkerST

  • Newbie
  • *
  • Posts: 5
  • Karma: +0/-0
  • SfE user
Re: Microsoft.Office.Interop.Excel libraries
« Reply #4 on: November 13, 2014, 12:37:42 PM »
Great Fabrice - I will test it. Thank you very much.