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...
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?
I think you must create a new Guid using Guid.NewGuid() and put that Guid in your excel sheet and xml. Then if you open it, just open the excel sheet, get the guid from that sheet, and find the same guid in xml.
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.
I would assume that the c# DLL can get access to the user.applicationdata folder so you should be able to store the number in there. Add enough 0 so you can not reasonably run out. Not sure an xl add in has that access though.
Never underestimate the power of human stupidity
im currently working on a C# project which needs to program out a font dialog box.
i have searched the net but mostly of them are those kind which have to click on a button before the font dialog box pops out.But i want the font dialog box to be on my form.When i debug, i see the font dialog box and i can display my selected font on a sample box there.
Hope that someone can understand and help me.
Thanks in advance.
i have created the form design and i have already got the fonts from the system.
The problem is that i dun noe how to combine the different values of font,style,script and size together and get them displayed on the sample display.
I have just tried out the method that you suggested. But there's an error in the program.
I think I know what goes wrong and I am now figuring out the way to correct it. Thank for your suggestion. I will try to understand it and get back to you again if I still got problems.