This is a weird problem I'm seeing in Excel Say I have a named range MY_RANGE which points to cell $A$1 (or A1) If I then enter =MY_RANGE into cell A2 all looks good If I then try to edit cell A2 I see =$A$1 rather than =MY_RANGE If I enter =MY_RANGE on a seperate sheet in the same workbook everything works as expected. I'm guessi...
I have data of program usage in excel file, the data has date and time. I want to summarize this information that in each day each hour, how many user use this application. How to do that using excel formular? sample data: Jun 01, 09:03AM Jun 01, 10:00AM Jun 01, 10:50AM Jun 01, 11:00AM Jun 01, 11:26AM Jun 02, 01:00PM Jun 02, 03:00PM Ju...
hi, i am using vsto, to work with excel-2007... let's consider i have a matrix as follows A B C 1 10 11 12 2 10 12 11 3 11 10 12 i will always read some random matrix filled with random numbers... ex above, and the other condition is that they will also be colored randomly according to the same numbers...
I've created a program that creates and populates a custom document property in an Excel 2007 workbook file. However I haven't been able to show the value of this property in a worksheet cell. In Word 2007 you can just select "Insert -> Quick Parts -> Field..." and use the DocProperty field to show the value of the custom field in a docu...
1) hi i just wanted to know why excel-2007 record macro does not write anything for example when i do the following: i insert a rectangle on the sheet and change its backcolor... (on the other hand, if i do the same thing in excel-2003 i get some code) 2) also is it possible to using vb to ask excel to put the rectangle on specified p...
I know Microsoft removed draggable points in 2007, but I need to get that function back. So far, I've got the MouseDown and MouseUp events trapped, but I'm having trouble figuring out how to scale the cursor's movement (which is measured in pixels) to a change of the selected point (arbitrary scale) Using VBA, how can I find the heig...
hi is it possible to write something like zoom-in and zoom-out button... for example i will have a userform on which i will have two buttons one for each zoom in and out... whenever the user clicks on one of the buttons plus user clicks the cells (or selects the range) that cell or range will be increased or decreased using the ActiveWi...
An Excel spreadsheet needs programmatic access to its Project structure. However, this access is disabled by default. It can be enabled programmatically, by writing to the registry with this snippet: Set wsh = CreateObject("WScript.Shell") 'key to modify' str1 = "HKEY_LOCAL_MACHINE\Software\Microsoft\Office\" & Application.Version & "...
hi, i have a bitmap generated from c# code (not a file!) which i want to insert on an excel worksheet... plz can you show me how is it possible ...
hi can you help me to find the problem at this line of my code where i try to add canvas to excel sheet from c# Line 1 Excel.Worksheet ws = (Excel.Worksheet) Globals.ThisAddIn.GetActiveWorksheet(); Line 2 ws.Shapes.AddCanvas(100,100,100,100); at line 2 it gives me exception... am i doing smth wrong? thanks a lot...
hi i am adding chart to excel from c# as follows Excel.Worksheet ws = (Excel.Worksheet) Globals.ThisAddIn.GetActiveWorksheet(); Excel.Shape chart = (Excel.Shape) ws.Shapes.AddChart(Type.Missing,100,100,100,100); is it possible now to add let's say Rectangle on the chart above for example like chart.Add(msoR...
hi i have inserted image on an excel worksheet... how is it possible to refer to this image from c#, thanks a lot! ...
I have several books I want to finish reading by a certain date. I'd like to track my progress completing these books, so I decided to try making a simple burn down chart. The chart should be able to tell me at a glance whether I'm on track to completing my books by the target date. I decided to try using Excel 2007 to create a graph ...
hi i have a c# program which creates a ribbon on excel-2007, on that ribbon i have two buttons one for zoom in and other for zoom out. my question is how is it possible so that when i press one of the above buttons and then select the cell or range on a sheet that cell or range will be zoomed in or out? my problem is i do not know how ...
hi is it possible to do this kind of things in excel-2007 vb... for example user selects cell or range.... let's say cell G13, now this cell will be displayed on the upper-left corner of the sheet (i.e. where usually A1 resides by default) in the case of range selection the upper-left corner of the range will be displayed in upper-left ...
hi, is it possible from c# to add some groups, buttons,... to excel-2007's print preview ribbon... why? i wanted to put some images on that ribbon so that user by selecting the image will be able to put it on a sheet (where ever on that sheet by dragging it) and print it with that sheet... many thanks! ...
hi, how is it possible to (from c#) insert image on a sheet being displayed by print preview dialog? thanks a lot! assuming that i have my own button on a print preview ribbon which will insert the image. this is actually continuation of my question http://stackoverflow.com/questions/1160905/c-excel-2007-print-preview-ribbon link text ...
I've got a VBA macro in an Excel 2003 spreadsheet and I'd like to 'install' it on a machine running Excel. I created a 'Trusted Location' on the local machine, and I know how to copy the module to the existing workbook and assign a key combination to invoke it, but I don't know how to make the macro appear automatically when someone s...
I am having problems with external references not working when the source is closed. I am using a vlookup to pull data from the source file, and when the source is open the references work. I have tried including the location along with the file name in the formula but it still is not working. Please help :) ...
Hi i have the following code... where i generate my own image and paste in to excel worksheet, please can you tell me why its background color is always BLUE? is it possible somehow to change that for example to make it transparent or white? (i tried flag.MakeTransparent(); but it also does not work) Bitmap flag = new Bitmap(200,...