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

VBA How to copy the content of a cell without .Select

I am writing a method that can take the Target and paste the cell exactly to another cell. The cell is a shipping label with some fancy formatting. Is there a way I can do it? Originally I have this: Worksheets("Label").Range("A1").Value =…
George
  • 4,514
  • 17
  • 54
  • 81
12
votes
7 answers

Make conditional formatting static

Is there any way to convert conditional formatting to static formatting in Excel? I'm trying to export a range of a Excel Sheet to a new Workbook, with identical appearance but no formulas, links, etc. The problem here is that I have conditional…
Martin
  • 1,622
  • 4
  • 16
  • 27
12
votes
2 answers

Getting error Procedure too large in VBA Macros (Excel)

I am getting Procedure too Large Error in a VBA macro. I am using MS-Excel 2003.
Code Hungry
  • 3,930
  • 22
  • 67
  • 95
12
votes
4 answers

Microsoft Excel Macro to run Java program

I have learnt to read and write an Excel file using a Java program with the help of Jxl and POI API. Is it possible to run a Java program with the help of macros?
Nimit_ZZ
  • 495
  • 4
  • 10
  • 21
10
votes
3 answers

Embed EXE file in the Excel file

I use: retVal = Shell("program.EXE " & filename, vbNormalFocus) To execute a program need for my excel spreadsheet. Is it possible to embed the EXE file in the excel file itself? And how would I execute it then? Ideias: 1 - Some kind of a bin2str…
user590715
10
votes
2 answers

How to limit cell value in Excel to options from another sheet?

In Excel (2003), I want to limit the selection of values in a cell to allowable values from another spreadsheet. For example, in the sheet "Currencies" I have EUR,1.1 GBP,1.0 USD,1.5 (That's two columns, three rows) In my main sheet I'd like to have…
Randy Orrison
  • 1,259
  • 2
  • 15
  • 14
10
votes
9 answers

Handle Error 9 when there is an Empty Array

I am writing a script that will loop through an Excel spreadsheet and find if there are duplicates of selected cells. If there are duplicates then the function will return an array of which rows are duplicates and create a comment to tell me the…
Talguy
  • 1,045
  • 2
  • 18
  • 27
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
9
votes
3 answers

Excel: Check Sheet Dependencies within a Workbook?

I'm in the process of refactoring a huge workbook woth a lot of legacy parts, redundant computations, cross-dependencies etc. Basically, I'm trying to remove unneeded sheets and implement some proper information flow within the workbook. Is there a…
Martin
  • 1,622
  • 4
  • 16
  • 27
9
votes
3 answers

ROW() function behaves differently inside SUM() and SUMPRODUCT()

Problem definition: Enter any number in cell A1. Now try the following formulae anywhere on first row. =SUM(INDIRECT("A"&ROW())) and =SUMPRODUCT(INDIRECT("A"&ROW())) The first formula evaluates, the second one gives a #VALUE error. This is caused…
playercharlie
  • 629
  • 1
  • 6
  • 17
8
votes
1 answer

Change Excel "External Data" Connection String

We currently use pivot tables in Excel 2003 to do our reporting. These pivot tables use the inbuilt "Import External Data" Excel functionality to feed the reports from SQL (SQL server 2008 to be precise). The reports currently point at our UK…
Doctor Jones
  • 21,196
  • 13
  • 77
  • 99
8
votes
10 answers

Excel Workbook Open Event macro doesn't always run

I've got a Workbook_Open event macro (and it's in ThisWorkbook) that doesn't always run. If Excel is closed and I double-click the .xls file from Windows Explorer, it does run. If I launch Excel from Start/Programs (with no .xls file) and then open…
ScottSM
  • 81
  • 1
  • 1
  • 2
8
votes
4 answers

Get dropdown value in VBA and get the name of the dropdown...nowhere to be found?

I created a dropdown by dragging the combo box onto my sheet from the UserForm toolbar. I assigned some values to it from some cells in the book. Now I want some VBA code to access the selected dropdown item's value in the form of a string. My…
EKet
  • 7,272
  • 15
  • 52
  • 72
8
votes
3 answers

Can I Get the Source Range Of Excel Clipboard Data?

If the Clipboard contains an Excel Worksheet Range, you can access that Range's Data with the DataObject Object Can you also find the actual Source Range (ie Worksheet, Row & Column) of that Data? Alternatively, can you find the Last Copied Range,…
mikebinz
  • 370
  • 1
  • 4
  • 17
7
votes
2 answers

Excel 2003 VBA - kernel32 functions - and other libs

I've been programming in VBA for Excel 2003 for some years now, and only recently I've been introduced to: Declare Sub AAAA Lib "kernel32" Alias "AAAA" by an answer here on Stack Overflow. What I've been unable to find is (no googlefu could help…
user590715
1
2
3
…
45 46