Top "Excel-2007" questions

The Excel-2007 tag is used for referencing the Excel Version 2007 spreadsheet application from Microsoft.

Copy data from closed workbook based on variable user defined path

I have exhausted my search capabilities looking for a solution to this. Here is an outline of what I would …

vba excel excel-2007 xlm
Excel 2007 conditional formatting - how to get cell color?

Let's assume i have the following range from (a1:c3) A B C 1 -1 1 1 2 -1 0 0 3 0 0 1 Now i have selected the …

excel excel-2007 vba
Using VBA to change Picture

I am trying to use VBA to automate the Change Picture function when you right click a Shape in Excel/…

image vba ms-office excel-2007
C# - How do I iterate all the rows in Excel._Worksheet?

I am looking to programmatically pull data from an Excel worksheet and insert it into a database table. How do …

c# excel excel-2007 excel-interop
writing to excel in java

Can someone point me in the right direction for writing to an excel file in java?? I am not understanding …

java excel excel-2007
Excel VBA Userform - Execute Sub when something changes

I have a userform containing lots of text boxes. When ever the values of these text boxes changes, I need …

vba excel excel-2007 userform
function which takes address() and gives value

I want to make a cell equal to the cell above it. When I write =address(row()-1;column()) It …

excel excel-2007
Excel formula to auto-increment after X amount of rows

I imported a few thousand rows of data into Excel and whereas one item represented one row, I've had to …

excel excel-2007 excel-formula
How can I count data by group in excel

I have data of program usage in excel file, the data has date and time. I want to summarize this …

excel excel-2007 excel-formula
Bloomberg data doesn't populate until Excel VBA macro finishes

I'm running a macro in a blank Excel 2007 workbook on a PC with a Bloomberg license. The macro inserts Bloomberg …

excel excel-2007 bloomberg vba