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
1
vote
1 answer

How to fill cells from sheet A with values from sheet B when ID matches (in Excel)?

Consider the following 2 sheets. Sheet AAA has a list of companies with an emptry column ROA. Sheet BBB has a ROA value for some of these companies. Sheet AAA A B 1 ID ROA 2 1 3 2 4 3 5 4 Sheet BBB A B 1 ID ROA 2 1 …
Pr0no
  • 3,910
  • 21
  • 74
  • 121
1
vote
0 answers

embed config file in excel xlsm

I was wondering if anyone has embedded a small config (csv essentially) file inside an xlsm and read from/written to it to save settings. Currently I use an external config file and Windows ini API function to access the info. I've been looking on…
user2348411
  • 11
  • 1
1
vote
1 answer

How to keep variable amount of numbers after decimals

I am using Excel 2007. I have multiple data sets with random number of characters in each row. For example: A1 1.60 A2 0.008 A3 0.900 A4 1.0 A5 0.56 A6 1.703 I need to make it into a different order on a different page such as A1…
user2347410
  • 11
  • 3
1
vote
1 answer

how to pass the active cell value to the URL in vba excel code

This is my code Private Sub Send_Click() Dim cell As Range, Rng As Range Dim strURL As String Set Rng = Selection For Each cell In Rng strURL = "http://xxxxxxxx.com/excelAPI.php?customer_id=1&mobilenumber=" _ & cell.Value &…
arok
  • 107
  • 2
  • 5
  • 13
1
vote
1 answer

runtime error: automation error while trying to connect to oracle database via Excel macro

I am a beginner to excel 2007. I am trying to make a connection to the oracle database 10G and extract data from it. I am getting "Runtime error :'-2147467259(80004005)': Automation error unspecified error" . This code is working for my…
Amritha Hariharan
  • 11
  • 4
1
vote
3 answers

Copy paste line items in Sheet B to filtered rows in Sheet A in Excel?

I have Sheet A with 500 line items. Suppose I have applied filter to show line items "2","44","68" and so on From Another Sheet i want to select some rows and paste them in these filtered rows.If I paste,they get copied on line items 2,3,4,5, and so…
Rahul Shah
  • 1,387
  • 4
  • 22
  • 41
1
vote
1 answer

How to manipulate smart art using vba in excel 2007?

I am trying to create smartart org charts using excel 2007 vba. I tried to first record the macro to see what objects are involved but with no luck. Nothing was recorded. There are some examples online of smart art and vba in excel 2010 but nothing…
Mr1159pm
  • 774
  • 1
  • 10
  • 21
1
vote
1 answer

how to consider 2 row as column names for importing excels to sql server using SSIS

I am importing Excel data to DB using SSIS package. The problem is i want to consider second Row i.e A2:Z2 as column name. I don't want to take A1:Z1 into consideration. How can i achieve it. My researched Link 1 Link 2
Prahalad Gaggar
  • 11,389
  • 16
  • 53
  • 71
1
vote
1 answer

EXCEL - Error while opening excel workbook

I have Office 2007. Each time I launch Excel, or open an existing file, it tries to access some old file and I get the following error pop up: 'E:\xyz.txt' could not be found. Check the spelling of the file name, and verify that the file location…
sunil
  • 23
  • 4
1
vote
1 answer

How to rename range using VBA in excel 2007

I've 8+ yes professional programming experience in PHP and Java but none in VBA. Learning it right now. I'm trying to make a Home budget sheet (Just for VBA learning purpose). For that, I'd done following * In new excel (2007) file, rename sheet 1…
Kapil Sharma
  • 10,135
  • 8
  • 37
  • 66
1
vote
1 answer

comparing and summing unequal number of rows in excel

How do I find the sum of Column Values for all values in Items . I used sumproduct but it has N/A error and couldn't find right solution with sumifs. =SUMPRODUCT(--(A2:A5=Sheet6!A2:A7),Sheet6!B2:B7) .Also in sumproduct I am unable to use range…
kinkajou
  • 3,664
  • 25
  • 75
  • 128
1
vote
1 answer

Excel Counting error

I am trying to sum the lead count data having the condition that it should be >0 and the gender should be MALE. I don't want to use countifs because it is not supported by excelcius. I have tried the following formula: =IF('Universe…
Oracle rookie
  • 95
  • 1
  • 2
  • 10
1
vote
1 answer

TF249051: No URL can be found that corresponds to the following server name

So am trying to open work items in Excel on my machine (TFS 2010 and Excel 2007) and I received original error from Excel TF80070: Team Foundation encountered an error while performing the operation. I found instructions on how to turn on…
Mike Cheel
  • 12,626
  • 10
  • 72
  • 101
1
vote
1 answer

Allocating Supply to Match Demand in Excel

This is a bit of a logic puzzle that I've been working on and I'm curious to see what kind of solutions the SO community comes up with. I have 24 randomly generated demand values, one for each hour of the day. I have a staff of 15, who each must…
user2263792
  • 11
  • 1
1
vote
1 answer

excel vba followhyperlink method when no workbook is open

I created a custom UI in excel 2007 as a part of xlam add-in. The custom tab includes a button that opens a website when clicked. I used ThisWorkbook.followHyperlink "address" The add-in is password protected which causes excel to crash whenever i…
Mr1159pm
  • 774
  • 1
  • 10
  • 21
1 2 3
…
99
100