Hi everyone, We have an application that is built with Excel as the front end using the Office object model. We were using a C++ shim to load it as a COM add in for Excel 2003, but I've updated it to use the latest VSTO for Excel 2007. I've also been using VS 2010 for the latest version. The problem is that everything works great on m...
I have not got much experience in Excel.Any help appreciated. I have 10-11 csv files , that can be opened in excel. I have duplicate records in all the files.I need to count the unique records in all the files that matches column3(for e.g). cheers ...
Below is the xml content generated by TFPT for the WIQL issued. When I try to import this XML into Excel 2007 XML source pane shows only "Id", "RefName" and "Value" as fields to be mapped. Whereas I would like to display System.Id, System.State, Microsoft.VSTS.Common.ResolvedDate, Microsoft.VSTS.Common.StateChangeDate as column heading...
I have an application where I have used a Webbrowser component in a wrapper to open an Excel worksheet. Now, when I press the exit key of the form containing the Webbrowser component, I would like it to find that particular Excel instance (leaving others) and kill it. How can I do that? ...
Is this something I need to write or something already exists. Google is pulling up a bunch of junk. ...
I have a master sheet that has rows of house address data, one column of which is a "State" column. I have 50 other sheets in the same document, corresponding to each of the 50 USA states. What I want to happen: When I enter an address in the master sheet, and enter a state (say "CA" or "California"), I want it to automatically populate ...
I have two excel files which has similar formatting and the data map each other from cell b15:h31. Row 15 is heading and so is the column B. I want to read file1 cell by cell and add that cell's content to the corresponding cell in File 2 i.e C16 in file 1 gets added to C16 in file 2, C17 in file 1 to C17 in file 2 and so on. The output ...
I have an excel file that has conditional formating set up to put a check or an x in a cell. How can I create an if statement that will detect which is in there without using the original conditioning formulas? ...
So, I need to find an Excel 2003 substitute for =SUMIFS, which is only 2007+ (apparently). The formula is used to generate this summary data table, from a list of revenue, where each revenue line has the field type (static, email or outreach) and the field fund (ABC, QRS and XYZ). type fund total count average static ABC $1...
Lets say I have an Excel file named "DataSheet.xls" open. How can I kill that Excel file using c#? ...
how do you compare two excel sheet and determine which column is missing? (would like to compare a list of countries from sheet A with sheet B, then mark which country is missing) Note: they are in random order. ...
I am having difficulty opening a EXCEL 2007 in Delphi 7 It works for Office 2003 and below but the wonderful people at microsoft have sent an update or something and the delphi app fell over just earlier this month. oE := GetActiveOleObject('Excel.Application'); oE.Workbooks.Open(Filename:=sFilename, UpdateLinks:=false, ReadOnly:=tr...
Hi I have created a xlt excel template which works fine in Excel 2007 under compatibility mode and shows no errors on compatibility check. The template runs a number of Macros which creates pivot tables and charts. When a colleague tries to run the same xlt on excel 2003 they get a Runtime error 428 (Object does not support this prope...
Is it possible in Excel 2007 to customise the floating format bar that is shown when you right-click on a cell? To avoid confusion, I don't mean the "Cell" commandbar menu, but the second floating toolbar with formatting buttons. e.g. is it possible to add a Styles dropdown, or have any other text alignment option than centre? Thanks i...
I would like to create a excel Add in which creates some additional toolbars and Menu buttons. But I want this addin to load only when a specific workbook is opened. I dont want to load the Addin if anyother workbook is open. I would like to know what are the possible ways to solve this problem and what is the best approach to implement...
Hi A little help needed, I have a Macro automatically creating pivot tables and charts, this is all working fine but I am getting (blank) in my pivot table becuase my range is all the way to 65536. How do I automatically get the lastrow / column in my source data so I dont get any blanks. The data is changing constantly so this needs to...
I have the following macro which needs to loop though an Excel-2007 table. The table has several columns and I am currently finding the correct column position using the Index property columns. Using the index is the only way I could find to correctly index into the fName object. The better option I am hoping for is to access specific c...
I have a program that displays numbers in a System.Windows.Forms.DataGridView. I'm formatting those numbers according to the user's regional settings, which causes problems when I try to copy and paste said numbers into Excel. For example, 123 456 789,00 is the proper localized format in Finnish, but Excel interprets this as a string, no...
Hi there, I have this: ActiveCell.Formula = "=COUNTIFS(G$4:G$" & (i - 1) & _ ", Sheets(ActiveSheet.Name).Cells(3, 25).Value ,F$4:F$" & (i - 1) & _ ",J4)" I want to use this: Sheets(ActiveSheet.Name).Cells(3, 25) so that I can make in loop to scan through column. as this reference cell must b...
I am making a spreadsheet that offers a column for user input. Each worksheet changes based on the month the user has given. If Target.Value = "January" Then ActiveSheet.Range("K7:K44").Value = ActiveSheet.Range("BA7:BA44").Value ElseIf Target.Value = "February" Then ActiveSheet.Range("K7:K44").Value = ActiveSheer.Range("BB7:BB4...