Stack Overflow
Stack Overflow

Questions tagged [excel-2003]

The Excel-2003 tag is used for referencing the Excel Version 2003 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 excel-formula or worksheet-function.

Excel 2003 is the 11th version of Microsoft's commercial spreadsheet program, and the last to feature the original toolbar interface.

Very few changes were made from Excel 2002 to 2003 (see below for link). Built-in XML support and List features were added.

This tag is used for questions specific to the 2003 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 2003 should be tagged .

Links:

679 questions
132
votes
4 answers

Loop through each row of a range in Excel

This is one of those things that I'm sure there's a built-in function for (and I may well have been told it in the past), but I'm scratching my head to remember it. How do I loop through each row of a multi-column range using Excel VBA? All the…
Margaret
  • 5,749
  • 20
  • 56
  • 72
74
votes
5 answers

How do I auto size columns through the Excel interop objects?

Below is the code I'm using to load the data into an Excel worksheet, but I'm look to auto size the column after the data is loaded. Does anyone know the best way to auto size the columns? using Microsoft.Office.Interop; public class…
Nick O
  • 3,716
  • 6
  • 38
  • 50
66
votes
34 answers

Excel: the Incredible Shrinking and Expanding Controls

Occasionally, I'll happen across a spreadsheet which suffers from magic buttons or listboxes which get bigger or smaller over time. Nothing in the code is instructing this. Has anybody else experienced this joy?
Nick
  • 3,573
  • 12
  • 38
  • 43
62
votes
3 answers

Excel add one hour

I have in cel A1 with the following contents: 7:30:43 which is a time. But now i want to use a formula to add one hour. What is the best way or how can i do this?
sanders
  • 10,794
  • 27
  • 85
  • 127
51
votes
3 answers

Get User Selected Range

How can I get a range of cells selected via user mouse input for further processing using VBA?
Talguy
  • 1,045
  • 2
  • 18
  • 27
51
votes
2 answers

PHPExcel how to set cell value dynamically

How to set cell/column value dynamically using PHPExcel library? I am fetching result set from MySQL database and I want to write data in excel format using PHPExcel library. Looking at example $objPHPExcel->getActiveSheet()->setCellValue('A1',…
Asif
  • 833
  • 2
  • 14
  • 23
39
votes
6 answers

POI setting Cell Background to a Custom Color

I want to set custom color to a cell's background. I use HSSFWorkbook (can't use anything else). HSSFPalette palette = aWorkBook.getCustomPalette(); Color col = new Color(backgroundColor); HSSFColor myColor =…
kenny
  • 2,000
  • 6
  • 28
  • 38
28
votes
6 answers

How to show current user name in a cell?

In most of the online resource I can find usually show me how to retrieve this information in VBA. Is there any direct way to get this information in a cell? For example as simple as =ENVIRON('User') (which did not work)
Anthony Kong
  • 37,791
  • 46
  • 172
  • 304
21
votes
2 answers

Language independent way to get "My Documents" folder in VBA Excel 2003

I need a Language independent way to get "My Documents" folder in VBA Excel 2003. What I have: Public Function MyDocsPath() As String MyDocsPath = Environ$("USERPROFILE") & "\My Documents\" End Function Because the program will be used in at…
Diego Castro
  • 3,458
  • 4
  • 35
  • 42
21
votes
5 answers

VBA hash string

How do I get a short hash of a long string using Excel VBA? What's given Input string is not longer than 80 characters Valid input characters are: [0..9] [A_Z] . _ / Valid output characters are [0..9] [A_Z] [a_z] (lower and upper case can be…
nixda
  • 2,654
  • 12
  • 49
  • 82
19
votes
2 answers

How can I return a dictionary from a function?

This is not working for me, and it is unclear why. Sub mySub() dim myDict as Dictionary myDict=new Dictionary myDict=myFunc() End Sub Function myFunc() dim myDict2 set myDict2 = new…
jason m
  • 6,519
  • 20
  • 69
  • 122
18
votes
3 answers

Excel search for cell references in formulas

I inherited a big model and have been trying to reverse engineer some of the formulas. There are a lot of fields. I am not sure if everyone of them is necessary. Is it possible to search an Excel document (with 5 worksheets) to find if say, AZ12 is…
CFNinja
  • 3,571
  • 4
  • 38
  • 59
17
votes
14 answers

Too Many Different Cell Formats

I have a massive file with 10 sheets recreated from scratch, 12 sheets updated, 5 sheets loaded with raw data, and 7 sheets that are used by the macros for the report. I have recently added a new sheet and am running into the Excel "Too many…
Craig
  • 538
  • 2
  • 5
  • 13
15
votes
6 answers

Conditional Formatting (IF not empty)

How do I conditionally format a cell so if not blank it is grey? I tried to do 'not equal', but it didn't work. I am using Windows Office 2003 with Windows XP at work. I don't see the same feature as below: What I have tried so far: Edit:…
George
  • 4,514
  • 17
  • 54
  • 81
13
votes
4 answers

Pulling Column Names into Excel from SQL query

I'm using Excel to pull data from an SQL db. I used the code from another SO question and it works fine. Now I want to pull in the column names from a table in addition to the actual table. I figured out that I could get the names using the For Each…
firedrawndagger
  • 3,573
  • 10
  • 34
  • 51
1
2 3
…
45 46