473,554 Members | 3,119 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Can we use app.config with an Excel add-in component?

QT
I have built a .NET add-in component for Excel. I have coded everything
according to the example at:
http://support.microsoft.com/default...b;en-us;313405

I don't get any errors, but no values get returned when I invoke:
sAttr = ConfigurationSe ttings.AppSetti ngs()

I've tried using filenames other than app.config (i.e. MyComponent.con fig,
MyComponent.app .config) but nothing has worked. Is it even possible to use a
config file like this with a component such as mine? If so, any ideas as to
what I'm missing?

--
Thanks!
QT
Nov 21 '05 #1
1 5314
Try excel.exe.confi g and put it in the same directory as excel.exe.

Jens.
--
Jens Thiel * http://ManagedXLL.net/ * +49 (228) 5400124
Replace MSDN with my first name when replying to my email address!
"QT" <QT@discussions .microsoft.com> wrote in message
news:8D******** *************** ***********@mic rosoft.com...
I have built a .NET add-in component for Excel. I have coded everything
according to the example at:
http://support.microsoft.com/default...b;en-us;313405

I don't get any errors, but no values get returned when I invoke:
sAttr = ConfigurationSe ttings.AppSetti ngs()

I've tried using filenames other than app.config (i.e. MyComponent.con fig,
MyComponent.app .config) but nothing has worked. Is it even possible to use a config file like this with a component such as mine? If so, any ideas as to what I'm missing?

--
Thanks!
QT

Nov 21 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1792
by: Nick Carter | last post by:
The following C# lines of code work fine with Excel 2000:- ExcelApplication excelApplication = new Excel.Application(); ExcelWorkbook excelWorkbook = excelApplication.Workbooks.Add(System.Reflection.Missing.Value); The second line fails when it is rebuilt with the Excel 97 type library and run on Excel 97. The error is an...
5
1799
by: Daniel | last post by:
Hi, is the a way to prevent aspnet process to restart after web.config is modified? like, waiting for all sessions to close, or not restart at all ? Thank you, Daniel
5
7333
by: touf | last post by:
Hi, I've an error when I declare Dim oBook As Excel.Workbooks What imports, and reference do I need to use Excel.Workbooks class? Thanks
1
2162
by: Steven | last post by:
Hello, I use the following code to make an Excel-file, which works fine with Excel 2003 (and the MS Excel 11.0 object library): Dim Excel As New Excel.Application Dim oBook As Excel.Workbook Dim WSheet As New Excel.Worksheet WSheet = Excel.Workbooks.Add.Worksheets.Add
0
1355
by: hazz | last post by:
I want to load Service.exe.config into a DataGrid, change the timer interval value from 10000 to 555555, then update the original exe.config. The code below shows the code at step 1 and 2 before creating ServiceNew.exe.config below. The initial line, '<?xml version="1.0" encoding="utf-8" ?' is missing and the nodes are not hiearchical with...
2
6641
by: Ian | last post by:
Hi, I am trying to use machine.config to store database settings for a connection wrapper class I am using as part of the data layer of an n-tier system. Have added the following section to my machine.config file <appSettings> <add key ="iSpexDatabaseType" value ="SQL"/>
0
2101
by: strider | last post by:
I have struggled with this problem and the solution is that you have to declare a variable for each and every object or collection within the Excel application that you want to use: For example: Dim oExcel As Excel.Application = New Excel.Application Dim lWorkBooks As Excel.Workbooks = oExcel.Workbooks Dim lWorkBook As Excel.Workbook =...
2
6513
by: james | last post by:
Hi all, I am trying to convert some old VB6 code to .NET. Take this first section (there is more, but hey-ho...) Dim XLApp As Object Dim XLSheet Dim XLBook Dim HeaderItem As String Dim ColCount As Integer ColCount = 1 Set XLApp = CreateObject("EXCEL.Application")
1
6670
by: DennisBetten | last post by:
First of all, I need to give some credit to Mahesh Chand for providing me with an excellent basis to export data to excel. What does this code do: As the title says, this code is capable of extracting all tables and it's data from any given database! I was searching the net for a program like this, but I didn't come accross any (free)...
0
1054
by: darrel | last post by:
I'm trying to set up a web.config file (2.0) so that all 404 errors are redirected to another page. What happens instead of the redirect, however, is that the browser tries loading the actual web.config xml file. This a) is wrong and b) seems like a huge security issue that IIS is actually serving the XML file. Any ideas what I'm doing...
0
7589
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7516
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
1
7551
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7881
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6131
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5147
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3550
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3539
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
831
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.