Stack Overflow
Stack Overflow

Questions tagged [excel-2007]

The Excel-2007 tag is used for referencing the Excel Version 2007 spreadsheet application from Microsoft. The version independent Tag is "excel". If your question is about VBA then also tag it VBA. If it is about an Excel formula or worksheet function, then tag it worksheet-function.

Excel 2007 is the 12th version of Microsoft's commercial spreadsheet program. It is the first version of Excel to incorporate a new user interface (UI), which is now standard across most/all Office suite programs.

This tag is used for questions specific to the 2007 version of the program. However, it is usually used in tandem with other tags, to let SO users know what your question is about. If your question is about VBA then also tag it . If it is about an Excel formula, tag it or . Questions about addins for Excel 2007 should be tagged .

Links:

3668 questions
40
votes
9 answers

VBA equivalent to Excel's mod function

Is there a vba equivalent to excel's mod function?
Arlen Beiler
  • 15,336
  • 34
  • 92
  • 135
40
votes
5 answers

How to add parameters to an external data query in Excel which can't be displayed graphically?

I often use MS Excel's Get External Data to create simple reports - running queries against databases and displaying nicely in Excel. Excel's great features like filtering and pivot tables and familiar interface for users make it quite good for…
Rory
  • 40,559
  • 52
  • 175
  • 261
37
votes
7 answers

Delete entire row if cell contains the string X

I am trying to come up with a way to delete all rows (and shift cells up, if possible) where the website column cell contains the word none. The table contains 5000+ records and this would save me a great amount of time. I appreciate any…
AnchovyLegend
  • 12,139
  • 38
  • 147
  • 231
35
votes
6 answers

How do I make a burn down chart in Excel?

I have several books I want to finish reading by a certain date. I'd like to track my progress completing these books, so I decided to try making a simple burn down chart. The chart should be able to tell me at a glance whether I'm on track to…
Mag Roader
  • 6,850
  • 8
  • 32
  • 27
32
votes
9 answers

Extract the last substring from a cell

I have names in a column. I need to split just the last names from that column into another column. The last name is delimited by a space from the right side. The contents in cell A2 = Alistair Stevens and I entered the formula in cell B2 (I need…
Shyam Natraj Kanagasabapathy
  • 1,833
  • 4
  • 19
  • 25
30
votes
2 answers

How can I assign a color to a font in EPPlus?

I can set the background color of a cell or range of cells like so: rowRngprogramParamsRange.Style.Fill.PatternType = ExcelFillStyle.Solid; rowRngprogramParamsRange.Style.Fill.BackgroundColor.SetColor(Color.DarkRed); I have not been able to set the…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
30
votes
4 answers

Unprotect VBProject from VB code

How can i unprotect my VB project from a vb macro ? i have found this code: Sub UnprotectVBProject(ByRef WB As Workbook, ByVal Password As String) Dim VBProj As Object Set VBProj = WB.VBProject Application.ScreenUpdating = False 'Ne…
khaled Rihane
  • 607
  • 2
  • 7
  • 19
26
votes
3 answers

VBA: Conditional - Is Nothing

There is an If condition in a VBA application as seen below: If Not My_Object Is Nothing Then My_Object.Compute When the code is run in debug mode, I found that the If condition returns a true even when My_Object has "No Variables". Could somebody…
StarDotStar
  • 2,865
  • 3
  • 20
  • 15
26
votes
3 answers

Compare data of two Excel Columns A & B, and show data of Column A that do not exist in B

I have an Excel file that has columns A and B, both have data that may or may not exist in other column, I'm only interested in the data of column A that do not exist in B. These Columns have same Header names. What formula can I use to show which…
Tim
  • 582
  • 2
  • 6
  • 12
26
votes
10 answers

Delete all data rows from an Excel table (apart from the first)

Just recently I've been trying to delete all data rows in a table, apart from the first (which needs to just be cleared) Some of the tables being actioned could already have no rows, so I was running it to problems as using .DataBodyRange.Rows.Count…
David Gard
  • 11,225
  • 36
  • 115
  • 227
25
votes
5 answers

Excel 2007 automation on top of a Windows Server 2008 x64

I’m well aware of the Microsoft support base article stating that it’s not supported to automate office products UI less. It seems that Windows Server 2008 x64 and Excel 2007 enforce the given statement. I’m running the following code in a NT…
Chris Richner
  • 2,863
  • 2
  • 26
  • 38
24
votes
2 answers

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 I determine the number of columns and rows in a worksheet or otherwise iterate the rows? I have Excel._Worksheet worksheet =…
P.Brian.Mackey
  • 43,228
  • 68
  • 238
  • 348
24
votes
3 answers

How to get combobox not to accept user input in Excel-Vba?

Does anyone know what the properties are in the combobox that I can manipulate in order not to allow the user to key/type in any data?
Vivian
  • 1,071
  • 5
  • 16
  • 29
24
votes
3 answers

How to split spreadsheet into multiple spreadsheets with set number of rows?

I have an Excel (2007) spreadsheet with 433 rows (plus the header row at the top). I need to split this up into 43 individual spreadsheet files with 10 rows each and one with the remaining 3 rows. It would be preferable to have the header row at the…
hockey2112
  • 496
  • 1
  • 4
  • 19
24
votes
7 answers

Excel 2007: How to display mm:ss format not as a DateTime (e.g. 73:07)?

I need to create and Excel table that computes daily training times. each row has the following fields: Date, Distance, Time and Minutes/Km. My main problem is that I want to display the Time in format of mm:ss. For example: 24 min and 3 sec should…
Meron
  • 453
  • 2
  • 6
  • 15
1
2
3
…
99 100