Choosing Parameter In Excel
I have a datasource that poplulates my sheet from sql server. There is a parameter to refresh the data. Can I have the choices come from a drop down menu on another sheet? ...
excel-2007
can a conditional format insert a comment if there is a duplicate cell in a column?
can a conditional format insert a comment if there is a duplicate cell in a column? If any cell in column "A" is a duplucate, then I want the cell highlighted to color blue and the comment to say "duplicate part_ID". please advise and provide me with complete code for me to copy and paste and instructions. thank you very much, Nath...
excel vba get range of user selected range by mouse
Hi All, this is not the usedrange issue. For example in excel user selects a range (possibly empty) using mouse, let's say B4:C12. And let's say after this without deselecting the range user presses the macro, and macro should tell B4:C12. Can anyone show example? Thanks a lot in advance! the macro should be smth along the lines of the ...
ActiveX controls move when pushing XML data into Excel Table
I am pushing XML data into an Excel Table via C#, but when I do this, my ActiveX checkboxes lower on the page do not adjust their position. The spreadsheet rows move down, but the checkboxes do not. Also, at times it seems like even though the cells on the spreadsheet shift down, the row heights do not, messing up the formatting. I t...
ShellEx: Starting Excel minimized or hidden
Using the following code I can run Excel from within C#: System.Diagnostics.Process p = new System.Diagnostics.Process(); p.StartInfo.FileName = "cmd.exe"; p.Start(); Can I make Excel start hidden or minimized using any command line parameters? (Edit: Tried p.StartInfo.WindowStyle and it had no effect.) I need to start Excel without...
Problems with Microsoft Excel COM Automation
So I wrote a method in my company's product a year and a half ago that makes use of Excel 2007's COM automation to export data, only now I'm finding that it's no longer working on machines in the office. I tested the functionality of the method on my own machine and got the same result. Digging deeper, I found that when I get as far as...
Prevent Excel from quitting
Update: I still don't have a viable solution to this question, new proposals are welcome! I'm missing an Excel.Application.Quit or an Excel.Application.BeforeQuit event. Does anybody know a workaround to mimic these events? Given an Excel.Application object (COM Interop in C#), how can I: Preferrably prevent Excel from quitting? If t...
Conditional Self-Referencing Formula (only execute if cell value == "")
Hello, here is my problem with the execution of an excel formula. These are the requirements: I have several lines in an excel sheet. At the end of each line there is a field called "Month". If someone enters new values in this line, the current month should be inserted. If the values get modified, the month must not be changed. T...
Add-in makes Excel crash when starting minimized
I start Excel from within my C# WinForms application using Process.Start(...) (this has a reason). I want to start it in background, without distracting the user, so I try to start it minimized or hidden. In both cases, I experience a very weird behavior: After some seconds, Excel restores the window (even makes it visible if it's hidde...
How I read databindings for an Excel ListObject
I have a VS 2010 Excel 2007 Workbook application. I have a ListObject that is bound to an object data source via a binding source. I want to be able to determine what property of my object any given ListColumn obect in my ListObject's ListColumns collection is bound to. In the example below I use the column name to find the column that i...
Excel calculation problems
I have Excel .xlsx document in which I need to import some values to cells with defined names. Few of those cells are formated as currency and values that I'm importing in those cells are of decimal type which I import in this manner: cell.CellValue = new CellValue(value.ToString().Replace(",", ".")); In the same spreadsheet there are...
How to use a reference for GetPivotData's Data_Field argument?
I'm trying to use GetPivotData to query "Foo Bar" values from a pivot table. Just by typing = in a cell and clicking on the pivot table does most of the legwork, as Excel writes most of the formula. For example I get: =GETPIVOTDATA("Foo Bar", 'Pivot Table'!D1, "Day", DAY(2010,10,10)) → 42 I need to have the first and last argume...
Get number of pages for printing from Excel Interopb
How can I programatically retrieve the number of pages a workbook or worksheet will print to from the Excel 2007 Interop (Microsoft.Office.Interop.Excel)? ...
Trying to calculate tasks in Excel
Hello, I was going to ask my question over at that "Experts" place, but they wanted me to pay $12.95! Fo that price I could pay some college wiz kid to do this for me, and have it done quicker! Ok, this should be an easy one, but for some reason my brain is freezing up when I try to do it. I have a spreadsheet with three sheets in it....
Manually created Excel files (in BIFF8) cannot be opened in Office 2007/2010 on Windows 7
We have a program that manually creates Excel files in BIFF8 format. This is a server program that runs on UNIX as well, so it doesn't use any COM library, but writes the file binary data itself. It is used to work very well, but the files it generates can no longer be opened in Excel 2007 or 2010 when running in Windows 7 - Excel say...
Excel chart dynamic range-selection
I have a client that has a simple yet complicated request for an excel sheet setup, and I can't for the world thing of where to start. I'm drawing a blank. We have a data range. Example: Quarter Data 2010Q1 1 2010Q2 3 2010Q3 4 2010Q4 1 I have a chart built on top of that. Change data, chart changes, protec...
In Visual Basic for Excel 2007, how do I select rows that contain a certain pattern?
I want to write a program in Visual Basic where I look at Column L of a worksheet and search for cells in Column L that contain "123." I then want to select the rows that contain "123" in Column L, copy them, and paste them into a new worksheet. How would I do this? I created a macro, but I'm not sure how to change it so that I can find ...
Excel 2007 Ribbon Will Not Re-Validate Unless Excel Window Has Focus
I am experiencing a strange problem. I have a custom Ribbon in Excel 2007 (built using RibbonX). Certain tabs in the ribbon are dynamically hidden and dropdowns are dynamically populated. This means that when the use takes certain actions the ribbon must be invalidated so it can be re-drawn. This works 100% of the time when the user has...
VSTO 4.0 Excel 2007 Add-in causing Memory leaks on Windows 7
Hi, We have a VSTO 4.0 Add-in for Excel 2007 that seems to have issues with Memory leaks, but only certain documents and only on Windows 7. The behavior is similar to the LCID proxy issue that was supposedly remedied in VSTO 4. The memory spikes at about 1.2 to 1.5 GB then throws an OutOfMemory Exception. This only seems to happen wh...
Excel-2007 - IF Cell A1 = Yes then Fill Red Color in B1
Hi I have a worksheet in Excel-2007 with Column 1 and Column 2 If the Cell 1 under column 1 is having a value of Yes in it then I want the Cell 1 in Column 2 to be filled in red color (irrespective of the content in Cell 1 in column 2) Please give your inputs.. Thanks, Pindu ...