excel

feeding data labels into excel with VBA

i have a scatter plot graph i would like each dot to have a label. how do i feed in labels through VBA for each dot? ...

Copy and paste cells if Duplicate columns , Excel Macro slightly different question

Hi I have another macro I wanted to create which is very similar to the one that has been given here. This time I don't want to specify a exact word because I won't know what word they will give, instead I would just like it to de dupe and copy whatever it finds in that column to the one respondent. How would I edit this? Thanks Serial,...

Merge and Left Justify a Range of Rows in Excel

I have a macro to select a range of cells on the same row and then merge & left justify that selection. I would like to enhance it to allow me to select a range or block of rows and perform the same action on each row in the range. Does anyone have some sample code to do something like that? Thanks! Craig ...

DSUM: How to define the criteria range using braces?

I think that it's easier to explain my problem with an example: Based on the spreadsheet above, the formula =DSUM(A4:D8,B4,A1:A2) works, returning 20. Why =DSUM(A4:D8,B4,{"OrderID";">10567"}) does not work? (It returns #VALUE!) ...

Apache POI HSSF/XSSF - Evaluating Formulas That Don't Live In Cells

With a known formula extracted from a spreadsheet, is it possible to apply/evaluate the formula without having it reside in an actual cell? I suppose one can create / locate a blank cell on the sheet (anyone have any ideas how this might be done efficiently?) and evaluate the formula this way, but is there a better way? ...

get xml from excel, create dataset from xml and import into tables.

I need to create an dataset from excel. Currently I am doing it by following way :- Go through each worksheet in workbook, get each cells value..and create datatable for each worksheet..and create a dataset for given workbook. But we change the extension of an excel file to .xml(a.xls -> a.xml)..and create dataset out of this xml (this...

i want to merge cells with vba

hello im new to this and i want to ask one question if anyone can help. im working with excel 2003 and what i want is that i have one column which at cell A1 i have name and in cell A2 i have surname, in cell A3 i have name and in cell A4 i have surname and so on. what i want to do is to merge cell A1 with A2 and then A3 with A4 and so ...

How to run over cells on Excel in C#?

How i can run over cells in Excel (not .csv) and read the cell values? I need to run all the cells. Thanks in advance. ...

what is MDO with VBA?

i do lots of vba with excel. what is mdo? if i want to do vba with mdo what does that mean? ...

another excel offset question

what will this do:?? =SUM(OFFSET(E6,0,0,$C$1,1)) here's the syntax of offset: OFFSET(reference,rows,cols,height,width) how can you put a height as being $C$1 ? what does this do? ...

excel funny table syntax

what does this do? =TABLE(,B5) there is a table on the chart where every cell has a different value but in the formula it has that syntax above. every cell in the table has =TABLE(,B5) in it. ...

Macro not in the list after loading the add-in.

I have a created a macro show() and saved it as display.xla and open a new workbook and added the display add-in. But when i went to Tools->Macro->Macro.. its not the list, But if i type display.xla!show and click run im able to execute it. Is there anyway to display the macros stored in the Add-in.? Apart from having it in personal.xls...

Rename Worksheet Event in Excel

What is the best way to get some VBA code to run when a excel sheet is renamed? ...

ExcelPackage and 98 thousand rows

I want to write an excel file (2007) with the codeplex excelpackage but it is taking a lot of time to write the excel file. I didn't find any method that it could accept a datasource. the piece of my code: var newFile = new FileInfo(GlobalVariables.Compare2007Path); using (var excelpackage = new ExcelPackage(newFile)) { var myWorkb...

Calling Excel/DLL/XLL functions from C#

Hello, I have a particular function in an Excel addin(xll). The addin is proprietary and we do not have access to the source code. However we need to call some functions contained within the addin and we would like to call it from a C# program. Currently, I was thinking of writing a C++ interface calling the Excel function with xlopers,...

to open an excel file, what is the difference between these 2 assemblies

when adding a reference I see: .net tab microsoft.office.tools.excel is that the one I need to read a excel file? other posts seem to be using a COM assembly with 'interop' in it? ...

Problems reading in an Excel file in C#

I'm reading an Excel file with OLDB Connection using this code var connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", fileName); var fileName = string.Format("{0}\\s23.xls", Directory.GetCurrentDirectory()); var adapter = new OleDbDataAdapter("SE...

excel programming

I am new to Excel programming. What are the differences among UDF, Macro, Add-in, Automation Add-in, XLL, VSTO which one I should use and under some circumstances? Thanks! ...

Excel 2007 Combo Box - Developer Ribbon vs. VBA Module

Could someone please explain to me the difference between the combo box that's available via the Developer Ribbon in Excel 2007 vs. the Combo Box control that's in the VBA editor? I cannot get this simple line of code to work using the Developer combo box: MsgBox Combo1.Value I've tied it to the change event and it seems to be syntact...

how to check Excel Workbook or sheet is password protected or not?

using vsto, C# fx 3.5, how to check Excel Workbook or sheet is password protected or not? ...