DotNetNewsgroup.com  
web access to complete list of Microsoft.NET newsgroups
   home   |   control panel login   |   archive  |  
 
  carried group
academic
adonet
aspnet
aspnet.announcements
aspnet.buildingcontrols
aspnet.caching
aspnet.datagridcontrol
aspnet.mobile
aspnet.security
aspnet.webcontrols
aspnet.webservices
assignment_manager
datatools
dotnet.distributed_apps
dotnet.general
dotnet.myservices
dotnet.nternationalization
dotnet.scripting
dotnet.security
dotnet.vjsharp
dotnet.vsa
dotnet.xml
dotnetfaqs
framework
framework.clr
framework.compactframework
framework.component_services
framework.controls
framework.databinding
framework.drawing
framework.enhancements
framework.interop
framework.odbcnet
framework.performance
framework.remoting
framework.sdk
framework.setup
framework.webservices
framework.windowsforms
framework.wmi
frwk.windowsforms.designtime
lang.csharp
lang.jscript
lang.vb
lang.vb.controls
lang.vb.data
lang.vb.upgrade
lang.vc
lang.vc.libraries
  
 
start date: Wed, 1 Aug 2007 06:42:03 -0700,    posted on: microsoft.public.dotnet.framework.interop        back       

Thread Index
  1    cendter


Interaction Excel / Excel Add-in Problem   
Hi there,

I am fairly new to all of this and have a big problem that I hope someone 
more skilled than I can help me with (in particular help me understand:)

I would like to write an add-in (not sure whether it has to be
automation or COM?) that opens a separate window  (as defined by the
C# add - in) in Excel once the user executes a macro. The window
should have a button that when clicked displays the contents of the
selected cells (i.e. I need to give the user the ability to read in
data easily so the add-in can process it). Again, the new window should be 
defined by the c# add-in, not a VBA form. I found this article and tried to 
follow it:

http://www.dotnet247.com/247reference/msgs/40/203206.aspx

.... but unfortunately ran into trouble. In particular, I have lot's of 
issues with 
references not being found in
the example given above, even after adding the XP PIA's as project
references and providing the 'using Microsoft.Office.Interop.Excel'
directives.

Can someone help me and shed some light and maybe send me a brief example? 
I'm using
the Visual Studio Express edition for now so the more extensive your
explanation the better as I suspect it doesn't do everything VSTO
does.

Many thanks!
Date:Wed, 1 Aug 2007 06:42:03 -0700   Author:  

Google
 
Web dotnetnewsgroup.com


COPYRIGHT ?2005, EUROFRONT WORLDWIDE LTD., ALL RIGHT RESERVE  |   Contact us