TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
shanda
NA
2
0
Excel Automation question
Sep 30 2004 2:44 PM
I am trying to start Excel through code. My objective is to start excel and load a Addin called TM1. If i go in through explorer and click on this Addin(.xla) it connects to a datawarehouse and adds a menu item in excel called Tm1. Well here is the code that I am using to accomplish the above tasks: try { //create a new excel app. _newApp = new Excel.Application(); _newApp.Visible = true; _newApp.AddIns.Add("C:\\Applix\\Integra\\bin\\tm1p.xla","C:\\Applix\\Integra\\bin\\tm1.xla"); _userBook = (Excel._Workbook)_newApp.Workbooks.Add("C:\\Inetpub\\wwwroot\\ExcelAddinExample\\ExcelTemplates\\01_fsTemplate_orig.xls"); _tm1Book = _newApp.Workbooks.Open("C:\\Applix\\Integra\\bin\\tm1.xla",0,false,5,"","",true, Excel.XlPlatform.xlWindows,"\t",false,false,0,false,null,null); //try to call the copnnect routine; _newApp.Run("N_Connect","toad","bisu","GBA03",null,null,null,null,null,null ,null,null,null,null,null,null,null,null,null,null,null,null, null,null,null,null,null,null,null,null,null); } Well my code is failing at the Addins.Add() line. What am i doing wrong. The error message i get is {"Add method of AddIns class failed" } and unfortualty the stack trace is not very descriptive either. But here it is: " at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)\r\n at Excel.AddIns.Add(String Filename, Object CopyFile)\r\n at ExcelModel.ExcelHandler.CreateExcel() in c:\\sameer work area\\excelmodel\\excelhandler.cs:line 32" I copied this directly from the debugger. What am i doing wrong. Sameer
Reply
Answers (
0
)
Date Formatting
How to enumerate all existing values of an enum type