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

Excel: Break on Error doesn't work in user-defined function

It seems that when VBA code is called from a cell formula (ie. a "User Defined Function" or UDF), the usual VBA Break On Error doesn't work. The only place I can find this behavior documented is a couple of lines in an article called "Developing…
Hugh Allen
  • 6,509
  • 1
  • 34
  • 44
7
votes
2 answers

Macro that runs a Macro that opens files and save them as value - Runtime Error 1004

I keep getting this 1004 runtime error. I have slimmed my programing down some so it’s not so Programception. I think it may have to do with using Excel 2010 to save .xls files. Not sure. When Auto_Root.xls opens it runs Sub auto_open() which…
Michael Downey
  • 687
  • 3
  • 13
  • 42
7
votes
5 answers

Excel Add-in doesn't get the hint

I have an excel add-in that keeps coming back when I start excel, even though I've removed it from the last open instance of excel (yes I checked the processes in task manager). The critter even shows up when I start excel in safe mode. Anybody…
Nick
  • 3,573
  • 12
  • 38
  • 43
7
votes
4 answers

VBA have a sub run another sub

how to run a sub stored in another worksheet's module? worksheet1 sub endDay() 'something here end sub worksheet2 sub reCalc() 'something here end sub I want recalc to be able to run on its own but I want to be able to press the button…
Stephan Daudt
  • 119
  • 3
  • 4
  • 11
7
votes
1 answer

How to check timestamp of a text file using VBA

I'm trying to write a code in Excel 2003 VBA (Windows XP) to find out if outside TXT file has different timestamp, so I can 'import' it if it changed. Is there any function in VBA that can save me?
MrB
  • 155
  • 2
  • 2
  • 6
6
votes
1 answer

Excel 2003 - How to build my own XLA?

How can you make the .xla file if you want to create your own xla? I have the code, classes, shapes, etc....what is the process to making an xla file to point to? I know that I have to put it in my program files folder, and then go through the steps…
Justin
  • 4,461
  • 22
  • 87
  • 152
6
votes
5 answers

Bugs in Excel's ActiveX combo boxes?

I have noticed that I get all sorts of annoying errors when: I have ActiveX comboboxes on a worksheet (not an excel form) The comboboxes have event code linked to them (eg, onchange events) I use their listfillrange or linkedcell properties…
Kimball Robinson
  • 3,287
  • 9
  • 47
  • 59
6
votes
2 answers

Why use Range.Formula in VBA for Excel 2003 instead of Range.Value?

I was wondering why in VBA code for Excel 2003 do we even need to use Range.Formula to write a formula to a cell instead of just using Range.Cell? They both write Strings to the cell that become forumlas, and the formula works (from what I've…
Mr_Moneybags
  • 3,927
  • 3
  • 19
  • 15
5
votes
4 answers

How to write to a "Google Spreadsheet" from Excel 2003 VBA

I Have an Excel 2003 file with a line similar to this: I need to click "the button" and it adds that line as the last one on a Google Spreadsheet Similar to: Is it possible? Should I use the command-line Google tools? Is there a better way? Easier…
Diego Castro
  • 3,458
  • 4
  • 35
  • 42
5
votes
1 answer

Workbooks.OpenText doesn't take 'fieldinfo' parameter

The following code demonstrates the problem which is stated in questions title. Copy & paste it in a new Microsoft Excel 2003 workbook. Sub mytest() mypath = Application.GetSaveAsFilename() Workbooks.OpenText Filename:=mypath,…
nixda
  • 2,654
  • 12
  • 49
  • 82
5
votes
3 answers

How do I get the cell value from a formula in Excel using VBA?

I have a formula in a range of cells in a worksheet which evaluate to numerical values. How do I get the numerical values in VBA from a range passed into a function? Let's say the first 10 rows of column A in a worksheet contain rand() and I am…
Simon
  • 78,655
  • 25
  • 88
  • 118
5
votes
10 answers

How to delete contents of an Excel sheet in Java?

How to delete contents of an Excel sheet in an Excel workbook, using Java SE and Apache POI?
Shumon Saha
  • 1,415
  • 6
  • 16
  • 33
5
votes
3 answers

using a sheet in an excel user defined function

The VBA I'm trying to write is fairly simple but Ive never written VBA and coming from the visual studio & C# world, this truly is hell!! So I'll really be grateful for any help/pointers/hints here So I have two important sheets. The Range sheet…
gideon
  • 19,329
  • 11
  • 72
  • 113
5
votes
6 answers

Excel: VLOOKUP that returns true or false?

In Excel we have the VLOOKUP function that looks for a value in a column in a table and then returns a value from a given column in that table if it finds something. If it doesn't, it produces an error. Is there a function that just returns true or…
Svish
  • 152,914
  • 173
  • 462
  • 620
5
votes
4 answers

What is the maximum number of controls that a VBA form can hold?

I'm currently building an Excel 2003 app that requires a horribly complex form and am worried about limitations on the number of controls. It currently has 154 controls (counted using Me.Controls.Count - this should be accurate, right?) but is…
Lunatik
  • 3,838
  • 6
  • 37
  • 52
1 2
3
…
45 46