Top "Excel-2007" questions

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

Parsing an Excel file in C#, the cells seem to get cut off at 255 characters... how do I stop that?

I am parsing through an uploaded excel files (xlsx) in asp.net with c#. I am using the following code (…

c# linq excel excel-2007 xlsx
Creating a "color scale" using vba (avoiding conditional formatting)

I'm looking for a way to apply a color scale to a set of cells via VBA code but not …

vba excel excel-2007 excel-2013
Excel UDF not appearing in drop down menu

I wrote a User Defined Fucntion in Excel. It works great with no issues. I even wrote a description for …

excel excel-2007 excel-udf vba
How do I count not equal to wildcard characters in Excel?

Using COUNTIF(range,"<>") can I count non-empty cells and with COUNTIF(range,"~?") or COUNTIF(range,"~*") can I calculate …

excel excel-2007 worksheet-function countif
Missing Microsoft Excel as option in SQL Server data import tool

I'm running SQL Server 2012 on a 64bit Windows Server 2012 R2. I don't have MS Office installed. I now notice that …

sql-server-2012 64-bit excel-2007 import-from-excel windows-server-2012-r2
Programmatically determine if a named range is scoped to a workbook

I am attempting what I thought would be a fairly simple vba statement to test whether a named range is …

vba excel-2007
excell 2007 macro validate data entered into cell and show msgbox if incorrect

Please can someone help with the following code. it gives me an error at the following line: Set range = "C5:…

excel if-statement excel-2007 msgbox vba
Why would VBA TypeOf operator fail

I have been fighting with an Excel 2007 problem for several days now. Below is a listing of all facts I …

vba excel excel-2007
Excel - Recursive VLookup

I recently came to know about Ctrl+Shift+Enter array formulas of Excel and currently still learning them. Coming to …

excel excel-2007 worksheet-function vlookup
Python and Excel: Overwriting an existing file always prompts, despite XlSaveConflictResolution value

I'm using the Excel.Application COM object from a Python program to open a CSV file and save it as …

python excel com activex excel-2007