Click here to Skip to main content
15,889,992 members
Home / Discussions / C#
   

C#

 
QuestionHow to write a JAVA program to mesure ping delay..? Pin
sacr835-Feb-08 22:25
sacr835-Feb-08 22:25 
AnswerRe: How to write a JAVA program to mesure ping delay..? Pin
Malcolm Smart5-Feb-08 23:27
Malcolm Smart5-Feb-08 23:27 
GeneralAuto maximize state of MDI children Pin
Dewald5-Feb-08 22:09
Dewald5-Feb-08 22:09 
GeneralRe: Auto maximize state of MDI children Pin
DaveyM696-Feb-08 1:03
professionalDaveyM696-Feb-08 1:03 
GeneralWriting custom rules for fxcop 1.35 Pin
Praveen_S5-Feb-08 21:48
Praveen_S5-Feb-08 21:48 
GeneralRe: Writing custom rules for fxcop 1.35 Pin
John_Adams5-Feb-08 22:34
John_Adams5-Feb-08 22:34 
GeneralRemovePreviousVersions doesn’t work in VS 2008 Pin
anderslundsgard5-Feb-08 21:43
anderslundsgard5-Feb-08 21:43 
Generalexcel addins Pin
arkiboys5-Feb-08 21:30
arkiboys5-Feb-08 21:30 
Hi,
I am trying to open an existing excel spreadsheet which has an Addins.
When I open it using .net code, it opens the file but the addins does not appear in the file.

So, after doing some search, I found there is a VBA code which does what I want but unfortunately I do not know how to add this VBA code to my .net code.
I am using c# but you can let me know the code in vb.net if you prefer.

Thanks

Here is the VBA which is supposed to have the Addins in the excel file:

Dim oAddin As AddIn
Dim oTempBk As Workbook

Set oTempBk = Workbooks.Add

Set oAddin = oXL.AddIns.Add("C:\blp\blp.xla", True)
oAddin.Installed = True

oTempBk.Close


In case you are interested, I am using c# to open my current excel file:

Microsoft.Office.Interop.Excel.Application EApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Worksheet WS = ((Microsoft.Office.Interop.Excel.Worksheet)(EApp.Workbooks.Open(@"C:\MarketAnalytics\YieldsSpreads\YieldsSpreads.xls",
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing).ActiveSheet));

EApp.Visible = true;
Questionhow can i open outlook and send mail usin c# code ? Pin
E_Gold5-Feb-08 21:21
E_Gold5-Feb-08 21:21 
AnswerRe: how can i open outlook and send mail usin c# code ? Pin
Vikram A Punathambekar5-Feb-08 21:26
Vikram A Punathambekar5-Feb-08 21:26 
AnswerRe: how can i open outlook and send mail usin c# code ? Pin
Justin Perez6-Feb-08 3:02
Justin Perez6-Feb-08 3:02 
Generaldisabling particular text in textbox control Pin
DKalepu5-Feb-08 21:07
DKalepu5-Feb-08 21:07 
GeneralRe: disabling particular text in textbox control Pin
Vikram A Punathambekar5-Feb-08 21:24
Vikram A Punathambekar5-Feb-08 21:24 
GeneralRe: disabling particular text in textbox control [modified] Pin
DaveyM696-Feb-08 0:33
professionalDaveyM696-Feb-08 0:33 
GeneralProject: Some random questions Pin
kingletas5-Feb-08 20:43
kingletas5-Feb-08 20:43 
GeneralWindows Authentication Help Needed Pin
Brendan Vogt5-Feb-08 20:43
Brendan Vogt5-Feb-08 20:43 
QuestionDeclaring and Passing value to public variable Pin
klaydze5-Feb-08 19:26
klaydze5-Feb-08 19:26 
GeneralRe: Declaring and Passing value to public variable Pin
Vikram A Punathambekar5-Feb-08 19:37
Vikram A Punathambekar5-Feb-08 19:37 
GeneralRe: Declaring and Passing value to public variable Pin
klaydze7-Feb-08 14:16
klaydze7-Feb-08 14:16 
GeneralRe: Declaring and Passing value to public variable Pin
Vikram A Punathambekar8-Feb-08 1:53
Vikram A Punathambekar8-Feb-08 1:53 
Generalopen Microsoft Access from c# Pin
tonato8485-Feb-08 17:41
tonato8485-Feb-08 17:41 
GeneralRe: open Microsoft Access from c# Pin
Adeel Chaudhry5-Feb-08 18:37
Adeel Chaudhry5-Feb-08 18:37 
Generalbinding the data to the grid Pin
chithra.r5-Feb-08 17:12
chithra.r5-Feb-08 17:12 
GeneralRe: binding the data to the grid Pin
That's Aragon5-Feb-08 17:59
That's Aragon5-Feb-08 17:59 
GeneralRe: binding the data to the grid Pin
chithra.r5-Feb-08 18:10
chithra.r5-Feb-08 18:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.