hello! guys... isn't there anybody to discuss the problem and come up with atleast ideas to approach the solution?! regards.

hey all, I created a shared addin project in visual studio 2005, an addin to excel that creates a button on the excel standard bar and assigns some event to it. Also, my addin acts an Automation addin. Now when I built the 'Setup project' of my addin, I got a setup file which I installed on a test machine. On this test machine, to my surprise, the addin's automation part is not working but the COM part is working fine i.e., the button is coming up on the standard bar. The reason I found out for this is, the Programmable key word is not being added to the HKCR\CLSID\GUID\ of my addin in the test machine. How to resolve this problem!? I want excel to recognise the UDFs i defined in my addin so that it also acts as an automation addin. Regards.

hey, the entries are made perfectly fine.. my project is an excel addin(thus, entries are made in hklm\software\microsoft\office\excel\addins\) not a visual studio addin. Basically, my Connect.cs also defines some UDFs and also adds a command bar to the excel. The commandbar is being displayed properly in the test machine but the automation part i.e., the UDFs are not being recognized. What could be the reason for the automation part of my addin not to work when the com part is working fine?! Regards

hi all, am developing a shared addin(to excel) using visual studio in c#.net, an addin. However, my addin acts like an automation addin too and the udfs i defined in MyAddin.Connect.cs are working fine in my m/c.But, the problem is, when I installed my project by running the MyAddinSetup.exe in another machine, though all the registry entries(HKCR, HKLM) are being made, the addin is not listed in the 'Tools-->Addins-->Automation'list! and am not able to use my udfs defined in MyAddin.Connect.cs. Kindly help me in this regard. I should be able to use my udfs in the test machine. Is there a problem with the installation or am I missing any registry entries?! Regards.

hey Graus, good to see you replying. Well, at last i figured out and it has made the registry entries in 'hkey classes root' on the test machine.. but apparently am very surprised with the fact that, though I am not able to see MySample.Connect in 'Excel--Tools--Addins', my addin is working to some extent. Actually my addin is supposed to generate a button in excel, on the addin-created CommandBar(which i call MyCommandBar). The button is showing up and all the forms resulting its click are showing up. however, the UDFs i defined in 'MySample.Connect.cs' are not being recognised!!! Why is this happening?! How am I able to see the button when there is no entry of 'MySample.Connect' in the 'Excel--Tools--Addins' list!!?? I need my UDFs to be working. Regards.

hi all, I am developing an excel automation addin in c# .net. I have its setup and msi too. Now, when i tried installing it on a test machine, the installation is all fine and i can also see the registry entry(of MyProject.Connect with LoadBehavior 3) being made in the hkey local machine. But, no registry entry is made in the hkey classes root!!! I am not able to find my GuidAttribute(EA0AA093-EB23-4BD5-B499-4A2D327FC4D9) in the 'hkey classes root\clsid'!!! What could be the reason for this?! Kindly help me in this regard. Any suggestions and ideas are very much thankful. Regards.

hey Eddy, thanks for replying. I've been scratching my head since... Basically, I want to create an xml for every excel sheet the user saves and when he reopens the excel sheet, I am supposed to open the corresponding xml. Thus, I used the WorkbookBeforeClose http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook_events(VS.80).aspx[^]event and my whole aim is achieved if *the user is saving the sheet first and then closing ms excel* However, the problem is, when he is trying to save the sheet by: Press the Close(X) button and when the pop up which says "Do you want to save changes to filename.xls? 'Yes' 'No' 'Cancel'" shoots up and IF he is choosing 'Yes' here, am not able to achieve the same. The reason being, the WorkbookBeforeClose event is invoked as soon as he presses the Close(X) button on the top right corner of ms excel. I want to somehow be able to know whether the user has chosen 'Yes' or 'No' from the pop-up. Can I?! If yes, kindly tell me how?! Regards.

Can we catch(or overload the event handler) the (Yes, No, Cancel) button click events of Microsoft Excel when the user clicks the Close(X) button on the top right corner of the ms excel workbook? Am basically building an excel automation add-in to ms excel using c#.

Is there a way I can know whether my Instance(excel) is saved or not?! So that I can use in the OnDisconnection() part of the code?!

erm.. will have to work on it..

well, he might not save certain instances at all... nd i feel it's weird to ask something like.. would you like to save this? If yes, enter the name, because it's quite variable, if in the last moment he decides to save... hence i need something like... MyApplication.guid() or something.. I've tried using Hinstance..Index.. blah blah.. but no help.

but hey, i should be able to save the sheet and re open and re use the sheet and its corresponding xml right... this guid.newguid() would give every time a new globally unique identifier. This way, how can I fetch the guid of my currently opened sheet(which was saved earlier) so that I'll open the correct xml?

hey friends, am developing an automation addin to excel using c#, upon building and running my project, an excel instance opens up. Now, i have somethings relevant to this excel to save to an xml. Thus, I need a seperate xml to every seperate instance of excel. For later uses I should be able to save my excel sheet and upon opening this saved sheet, I should be able to read from the corresponding xml file too! I am generating the xml file in my code itself. Thus, I need a unique name/id to name these "excel---xml" pairs and thus be able to read from the corresponding xml whenever i open any saved sheet. more or less like.. i need... book1.xls----book1.xml & book2.xls----book2.xml & so on... regards.

VSTO visual studio tools for office... Or, build a c# project( a shared add-in or visual studio add-in and get the interaction between c# and excel)

how to get the control of the shape residing in the active cell of my sheet? I mean to say, is there a way i can say: Excel.Shape sh = MyApplication.ActiveCell.get_Shape(); or something like that so that I get the shape's control and further I can use it. Regards

oh, no one responded yet, anywayz, i got it myself... here's what i've done: string []s = selectedRange.Split(new char[]{':'}); Range res = ((Worksheet)MyApplication.ActiveSheet).get_Range(s[0], s[1]); Regards.

I could to convert a range object to a string, this way: string selectedRange = resRange.get_Address(false, false, XlReferenceStyle.xlA1, false, false); Now, how can I get back the range object from the string('selecteedRange' whose value is say "D10:E20")??? thanks.

this means, i should go with an overloaded function, that's it?!

dude! Default parameter specifiers are not permitted in C#!!! http://blogs.msdn.com/csharpfaq/archive/2004/03/07/85556.aspx[^]

basically, i can achieve it by having an overloaded funciton, but, it is just a small issue that i do not want to have another overload of the function. I am having a funciton with 2 parameters and now i want to introduce a 3rd optional parameter. I just want to know whether the caller of the function passed the 3rd argument or not?