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
18
votes
12 answers

Reset Excel to default borders

Ok, so you know what a spreadsheet looks like when you open a new on in Excel; the borders are a light blue. These are only on the screen though, if you print the sheet it will not have borders. Say you've applied some various formatting to the…
Ryan
  • 229
  • 1
  • 2
  • 7
18
votes
8 answers

Checking if an Excel Workbook is open

Is there a way to see if an Excel Workbook, say DataSheet.xls, is open (in use) or not? I would like to close that Workbook if it is opened.
Rabin
  • 1,563
  • 4
  • 20
  • 44
18
votes
3 answers

Apache POI - How to protect sheet with options?

I'm using the Apache POI to generate an Excel File (2007). What I want is to protect the sheet, but with some options enabled. By options I mean the check box list when you try to protect the sheet in the Excel application (under the label "Allow…
John Bautista
  • 1,480
  • 3
  • 29
  • 60
18
votes
6 answers

Merging cells in Excel by rows and columns together using PHPExcel

I need to merge cells in Excel (xlsx) by rows and again by columns using PHPExcel. I tried the following. $sheet->mergeCells("G".($row_count+1).":G".($row_count+4)); $sheet->mergeCells("H".($row_count+1).":H".($row_count+4)); …
Tiny
  • 27,221
  • 105
  • 339
  • 599
18
votes
7 answers

"Excel found unreadable content" warning when opening Excel files made with PHPExcel

I'm trying to download Excel files (xlsx) using PHPExcel as follows. require_once("../../phpExcel/Classes/PHPExcel.php"); require_once("../../phpExcel/Classes/PHPExcel/IOFactory.php"); $objPHPExcel = new…
Tiny
  • 27,221
  • 105
  • 339
  • 599
18
votes
11 answers

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/Word/Powerpoint. However, I am not able to find any reference, can you assist?
PlayKid
  • 871
  • 2
  • 10
  • 21
17
votes
6 answers

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 (simplified): string connString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel…
naspinski
  • 34,020
  • 36
  • 111
  • 167
17
votes
2 answers

Always show two decimal points in excel cells using Apache poi

For example, XSSFCellStyle style=(XSSFCellStyle)…
Tiny
  • 27,221
  • 105
  • 339
  • 599
17
votes
8 answers

How to do a "Save As" in vba code, saving my current Excel workbook with datestamp?

I have an Excel Workbook that on form button click I want to save a copy of the workbook with the filename being the current date. I keep trying the the following ActiveWorkbook.SaveAs ("\\filePath\FormFlow To MSExcel\" & Left(Now(), 10)) but am…
Analytic Lunatic
  • 3,853
  • 22
  • 78
  • 120
17
votes
6 answers

Why am I getting Error 2042 in VBA Match?

I have Column A: +--+--------+ | | A | +--+--------+ | 1|123456 | |--+--------+ | 2|Order_No| |--+--------+ | 3| 7 | +--+--------+ Now if I enter: =Match(7,A1:A5,0) into a cell on the sheet I get 3 As a result. (This is desired) But…
user2140261
  • 7,855
  • 7
  • 32
  • 45
17
votes
2 answers

PivotTable to show values, not sum of values

I'm wanting to display a pivot table and for it to show me the actual values, one on each row, rather than a sum of the values. E.g. Name Jan Feb Mar Apr Bob 12 10 4 3 5 James 2 6 8 1 …
franglais
  • 928
  • 2
  • 15
  • 39
17
votes
4 answers

Excel (2007) VBA - .Formula with quotes in it

I tried putting the following code into a program yesterday. VBA called an error. I assume it is because of the double quotes inside the formula. I googled and all results I found just gave the basic of putting formulas in, but none explained how…
GeoffDS
  • 1,221
  • 5
  • 19
  • 31
16
votes
3 answers

How to use VBA to make a cell in Excel 2007 transparent

I currently have: Range("Z1").Interior.Color = RGB(255, 255, 255) But this wipes out the borders of the cells. Instead I'd just like to set the transparency of the cells in range to 1.0. The docs seem to suggest it doesn't exist (?). Thanks!
AJP
  • 26,547
  • 23
  • 88
  • 127
16
votes
2 answers

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 scoped to a workbook or a specific sheet. As a test, I have created a new Excel document and added in 6 named ranges. Here is how they are layed…
Hari Seldon
  • 1,060
  • 2
  • 13
  • 27
16
votes
4 answers

How to get list of all files with ESY extension in a directory?

In VBA, how do I get a list of all the files with a specific extension in a specific directory? i am unable to do Application.FileSearch, because i am using excel 2007
Alex Gordon
  • 57,446
  • 287
  • 670
  • 1,062
1 2 3
…
99 100