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
11
votes
2 answers

User defined type not defined- controlling Word from Excel

I am trying to do some relatively simple copy and pasting from Excel 2007 into Word 2007. I've looked through this site and others, and keep getting hung up on the same thing- the third line n the code below keeps giving me the "User type note…
Tommy Z
  • 649
  • 5
  • 12
  • 18
11
votes
2 answers

Assign event handlers to controls on user form created dynamically in VBA

I have found many resources on the internet that do almost what i want to do, but not quite.I have a named range "daylist". For each day in the dayList, i want to create a button on a user form that will run the macro for that day. I am able to…
BiGXERO
  • 7,104
  • 8
  • 23
  • 25
10
votes
4 answers

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 functions into sheet1 that pull yield curve data. Some additional functions' results are dependent on the first functions finishing…
Diana Tortolini
  • 230
  • 1
  • 3
  • 10
10
votes
4 answers

Adding Apostrophe in every field in particular column for excel

How can you add an apostrophe in every field in an Excel spreadsheet without individually typing it in? I have got like 5k fields
Mr A
  • 6,448
  • 25
  • 83
  • 137
10
votes
3 answers

Reference Excel worksheets dynamically

I have a problem that should be so simple, but I'm not getting my head around it. I do printed pricelists for a store and this year they've split up the part numbers into 5 worksheets instead of one. When a user wants to print out a pricetag, she…
Thinkwell
  • 285
  • 1
  • 5
  • 16
10
votes
4 answers

How to check whether certain sheets exist or not in Excel-VBA?

Does anyone know how to check whether certain sheets exist or not in an Excel document using Excel VBA?
Vivian
  • 1,071
  • 5
  • 16
  • 29
10
votes
3 answers

Excel VBA get range of user selected range by mouse

This is not the usedrange issue. For example in Excel user selects a range (possibly empty) using mouse, let's say B4:C12 And let's say after this without deselecting the range user presses the macro, and macro should tell B4:C12. Can anyone show…
sdfg
  • 393
  • 2
  • 5
  • 9
10
votes
1 answer

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 an Excel workbook. If the target file already exists, then I am prompted with this message: "A file named '...' already exists in this location. Do…
Mike M. Lin
  • 9,992
  • 12
  • 53
  • 62
10
votes
1 answer

Late Binding VBIDE.VBE in excel

Is it possible to late bind the VBIDE.VBE object in Excel? For example: Dim VBAEditor As VBIDE.VBE Instead becomes something similar to this (late-binded): Dim VBAEditor As Object: set VBAEditor = CreateObject ("VBIDE.VBE") My goal is to avoid…
Jake88
  • 955
  • 1
  • 19
  • 39
10
votes
2 answers

convert an Excel 2010 addin to a 2007 addin (both VSTO)

I am currently working on an Excel 2010 add-in which formerly was an Excel 2007 add-in. Somewhere in the process of switching computers, the add-in was converted i think. Some of my customers stated that the add-in wasn't working on Excel 2007…
Bongo
  • 2,933
  • 5
  • 36
  • 67
10
votes
3 answers

Unprotect sheet with password, without exposing password in the macro

I have recently started writing some Macro's in Excel. I have a protected worksheet, and a few buttons that allow the user to add/remove columns/rows at a certain point in the spreadsheet. I currently unprotect the worksheet, perform the functions…
Lock
  • 5,422
  • 14
  • 66
  • 113
9
votes
3 answers

how to disable compatibility check in excel while automating through c#

I am using Excel 2007 interop assembly to automate Excel through c#. Interop version is 12.0. When I try to save a file, it can be saved only in 2003 format, but thats fine with me, yet I am getting a popup saying compatibility issue. How can I…
j4m4l
  • 328
  • 2
  • 10
  • 22
9
votes
4 answers

Excel macro to fix overlapping data labels in line chart

I am searching/trying to make a macro to fix the position of data labels in a line chart with one or multiple series collections so that they will not overlap each other. I was thinking of some ways for my macro but when I try to make it I…
Ron
  • 3,975
  • 17
  • 80
  • 130
9
votes
2 answers

Comparing two columns in Excel with exclusion

I want to compare values in two columns in Excel as depicted in the image below :- Using the formula, I want to put the values in the "Values of A which don't exist in B" and "Values of B which don't exist in A". Any help is appreciated. I have…
Ashish Gupta
  • 14,869
  • 20
  • 75
  • 134
9
votes
3 answers

When called from an Excel VBA UDF, Range.Precedents returns the range and not its precedents. Is there a workaround?

I have this VBA function: Public Function testPrec(target As Range) As String testPrec = target.Precedents.Address(External:=False) End Function In cell C11, I have this formula: =C6+C8 If I call testPrec from the immediate window, it works…
jtolle
  • 7,023
  • 2
  • 28
  • 50
1 2 3
…
99 100