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

Delete Entire Rows Based on Cell Values

I want in Excel (2003) to take an imported data dump and format it into a report. Most of what I have done has involved recording a macro and then customizing the code where needed. I have a spot that requires pure code. I have a SORTED column (D)…
user3613124
  • 55
  • 1
  • 1
  • 4
5
votes
2 answers

How to use an specific version of Excel in a C# program

For many reasons, I have installed on my laptop MSExcel 2003 and MSExcel 2007. I need both versions to develop specific projects for each version (Document level projects and Application level projects). Now I need to do a WinForm project that…
Oriol Terradas
  • 1,788
  • 2
  • 19
  • 30
5
votes
1 answer

Keyboard Shortcuts in Excel Menu CommandBar

The code below adds a menu item Custom1 right before New.... How can I get the keyboard shortcut assigned to CodeCustom1 (via Application.OnKey) to appear nicely right-aligned with Ctrl+N? Sub menuItem_Create() With CommandBars("Worksheet menu…
u17
  • 2,776
  • 4
  • 31
  • 43
5
votes
1 answer

Converting a cell's formula to text using excel vba

I am writing a macro in Excel2003 to find all cells with formulas in a workbook and outputting their address and formula in a couple of columns on a different sheet. I know I can show the formula for an individual cell using Public Function…
yu_ominae
  • 2,975
  • 6
  • 39
  • 76
5
votes
1 answer

Dumping variant array to range - VBA excel error 1004

I'm using vba for Excel in order to save data into an array by: Dim allPosts As Variant allPosts = Range("A2:J5000") after that I'm changing data in the allPosts array, and then I want to paste it back by: Range("A2:J5000").Value = allPosts I'm…
Presen
  • 1,809
  • 4
  • 31
  • 46
5
votes
1 answer

Save excel 2003 file

I am doing a simple c# application which is to edit the existing excel 2003 template(xlt) and save to a new *.xls file. It is like: Microsoft.Office.Interop.Excel._Application app = new…
TakinosaJi
  • 400
  • 5
  • 13
5
votes
3 answers

Excel VBA macro: Locating first empty cell in a column and automatically filling it

I have two columns, Column (A) and Column (B) in a spreadsheet. Column (A) contains names extracted from a query (ex. Brian, Bob, Bill, etc...) and column (B) contains one of three statuses (Assigned, In Progress, or Pending). However, this query…
user1663562
  • 53
  • 1
  • 1
  • 4
5
votes
1 answer

Incorrect value when counting cells in different versions of Excel

I have seen some SO users run into an issue when trying to use some variation of Cells.Count; the VBA code throws an overflow error in some cases. For reference, see comments on this answer: I think this will work, but I get an "overflow" error…
Gaffi
  • 4,307
  • 8
  • 43
  • 73
5
votes
3 answers

Adjusting worksheet zoom level based on screen resolution

I have an Excel 2003 macro to adjust my screen zoom based on the screen resolution. Sub Macro1() Dim maxWidth As Long, myWidth As Long Dim myZoom As Single maxWidth = Application.UsableWidth * 0.96 'I use r because upto r i have macro…
logan
  • 7,946
  • 36
  • 114
  • 185
5
votes
2 answers

Import data to Excel 2003 with a login page

I am building a project and I understand that Excel 2003 supports the import of data from external webpages via "Data -> Import External Data -> New Web Query". This can be done via the few steps listed here:…
Melvin
  • 105
  • 1
  • 2
  • 8
5
votes
1 answer

VBA - UDF handles Arrays differently

This code is a small subset of what I am working on. I have narrowed the problem down to the following piece. I have this UDF SampleFunction, to which I need to pass an Array, {3;4} as the sole argument. Function SampleFunction(InputVar As Variant)…
playercharlie
  • 629
  • 1
  • 6
  • 17
4
votes
7 answers

Need a better optimized code?

Need a much Optimized code.Well I Got a Project and I have Succefully made it work with the vba (Mostly helped by the stackoverflow programmers Thanks for that) But Today I got a Feedback. Its deleting 2 more unique entries in the record But I dont…
niko
  • 9,285
  • 27
  • 84
  • 131
4
votes
2 answers

How do I insert the formula into the cell when the formula keeps changing with an increase in row?

I have entered these formula in the second row of the Pth column: =(COUNTIF(A$1:A1,A2)=0)+(COUNTIF(B$1:B1,B2)=0)+(COUNTIF(F$1:F1,F2)=0) When I drag it to the third row of the Pth column, it gets like this: …
niko
  • 9,285
  • 27
  • 84
  • 131
4
votes
5 answers

Count number of worksheets in Excel File

How to count number of worksheets in a Microsoft Excel file using Java SE?
Shumon Saha
  • 1,415
  • 6
  • 16
  • 33
4
votes
3 answers

Can a macro in one workbook make changes to another workbook?

I defined a macro in one worksheet(internal.xls) as Public Sub sheet2test() Workbooks.Open Filename:="external.xls" Windows("external.xls").Activate Sheets("Sheet3").Activate Range("A5").Value = 5 End Sub Running this code, opens…
Ali
  • 4,311
  • 11
  • 44
  • 49
1 2 3
…
45 46