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
16
votes
3 answers

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 can think of that might be relevant: IDetailSheet is a class declared in the VBA project with several methods, and which throws an error in its…
Pieter Geerkens
  • 11,775
  • 2
  • 32
  • 52
15
votes
1 answer

How to programmatically code an 'undo' function in Excel-Vba?

Is there anyway to code an undo function onto a CommandButton similar to the Excel's very own undo function? Or a function which is capable of calling Ctrl-Z shortcut key.
Vivian
  • 1,071
  • 5
  • 16
  • 29
15
votes
2 answers

Use openpyxl to edit a Excel2007 file (.xlsx) without changing its own styles?

I have a .xlsx file to edit, I found openpyxl could manipulate Excel 2007 files. I only want to change the value in some cells and leave other settings unchanged. But after I went through the Documentation, I cannot find the examples to edit a…
Xiao
  • 12,235
  • 2
  • 29
  • 36
15
votes
3 answers

How do I add a custom XML to an open Excel 2007 workbook using C#?

I'm trying to add a custom XML to an open Excel 2007 workbook using C#. I'm using Microsoft.Office.Interop.Excel as an interface. I've discovered there's a CustomXMLPart class but I can't figure out how to use it. Initially I expected the code to be…
TheMathemagician
  • 968
  • 9
  • 21
15
votes
3 answers

How to focus or select a cell in Excel

How to focus a cell in Excel VSTO using C# or to select first cell using C# in VSTO?
venkat
  • 5,648
  • 16
  • 58
  • 83
15
votes
3 answers

Not a valid Office Add In

I developed a new Office 2007 addin using VS 2008 and VSTO. after this I go to Office->Excel Options->AddIns->COM AddIns and GO... If I select the .dll which I ve created I get the error '' is not a valid Office Add In. If I run it using the…
Sachin
  • 239
  • 2
  • 3
  • 6
15
votes
4 answers

Writing a string to a cell in excel

I am trying to write a value to the "A1" cell, but am getting the following error: Application-defined or object-defined error '1004' I have tried many solutions on the net, but none are working. I am using excel 2007 and the file extensiton is…
knightrider
  • 2,063
  • 1
  • 16
  • 29
14
votes
1 answer

Exit / disable edit mode after double click handled event

I'd like to display a dialog after a user clicks a cell in an Excel sheet. Something like this: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) MsgBox "a cell was clicked!", vbOKOnly, "a click" End Sub It works…
wilu
  • 549
  • 1
  • 12
  • 26
14
votes
2 answers

Excel VBA: function to turn activecell to bold

I have the following function inside my module. Function Colorize(myValue) ActiveCell.Select Selection.Font.Bold = True Colorize = myValue End Function The cell that will use this function should be turning bold - however, I get no…
Shyam
  • 2,357
  • 8
  • 32
  • 44
14
votes
8 answers

Python: Writing to Excel 2007+ files (.xlsx files)

Is there a Python module that writes Excel 2007+ files? I'm interested in writing a file longer than 65535 lines and only Excel 2007+ supports it.
Jonathan Livni
  • 101,334
  • 104
  • 266
  • 359
14
votes
2 answers

Which One is Best OLEDB Or Excel Object Or Database

I need to work with Excel 2007 File for reading the data. for that which one is the best way to do that: Using OLEDB Provider Excel Interop Object Dump the Excel data to Database and Using Procedure kindly guide me to choose.
guna Samba
  • 474
  • 1
  • 7
  • 17
14
votes
1 answer

Have to save twice for CSV file

After I edit the existed CSV file, click save will prompt a message dialog "some feature in your workbook might be lost if you save it as CSV (Comma delimited)". Then I click "Save". After that when I click "Close" to close the CSV, prompt message…
Howard Hee
  • 909
  • 1
  • 13
  • 29
13
votes
7 answers

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 following range, and formatted it using Conditional Formatting (using default red yellow green color scale).... now range colors became …
sss
13
votes
1 answer

Proper SpreadsheetML file extension

I want to create a a SpreadsheetML file on local drive which can be opened in MS Excel or Open Office by clicking on file in Windows Explorer. I tried all filename extensions registered to Microsoft Excel i could find so far. Some of them (.xls for…
Vasily Redkin
  • 584
  • 1
  • 3
  • 17
13
votes
3 answers

How do I create URLs in Excel based on data in another cell?

Consider the following Excel sheet: A B C 1 ASX:ANZ ANZ:ASX http://www.site.com/page?id=ANZ:ASX 2 DOW:1234 1234:DOW http://www.site.com/page?id=1234:DOW 3 NASDAQ:EXP EXP:NASDAQ …
Pr0no
  • 3,910
  • 21
  • 74
  • 121
1 2 3
…
99 100