473,406 Members | 2,549 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

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 = ConfigurationSettings.AppSettings()

I've tried using filenames other than app.config (i.e. MyComponent.config,
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 5299
Try excel.exe.config 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**********************************@microsof t.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 = ConfigurationSettings.AppSettings()

I've tried using filenames other than app.config (i.e. MyComponent.config,
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
by: Nick Carter | last post by:
The following C# lines of code work fine with Excel 2000:- ExcelApplication excelApplication = new Excel.Application(); ExcelWorkbook excelWorkbook =...
5
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
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
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...
0
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...
2
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...
0
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:...
2
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...
1
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...
0
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...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
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...
0
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...
0
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,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

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.