Stack Overflow
Stack Overflow

Questions tagged [excel-2002]

The Excel-2002 tag is used for referencing the Excel Version 2002 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.

is used for referencing the Excel Version 2002 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.

18 questions
3
votes
1 answer

How to find the cell next to active cell in excel

I want to create a log file in excel. I have created a macro that will insert in-time into active cell on ButtonInTime click. Similarly out time in the active cell on ButtonOutTime click... Now i want to insert todays date on ButtonInTime click in…
Anoop Pete
  • 492
  • 2
  • 4
  • 17
2
votes
1 answer

What is the significance of the question mark in Excel?

If I type in this formula: =vlookup(A1,LetterTable,2,False) With A1 set to "?" (without the quotes), and LetterTable contains this: a a b b c c ... ... - - + + ? ? ! ! It always gives me "a" (no quotes). Why is this? Also, if I…
Arlen Beiler
  • 15,336
  • 34
  • 92
  • 135
2
votes
1 answer

What method can I use to call a web service from VBA?

What is the easiest way to call a web service from Excel (I am using version 2002)? Please, no third party tools or libraries. This has to be easy with some VBA that I can paste there, use it, and ever touch.
AlanR
  • 1,162
  • 4
  • 14
  • 26
1
vote
2 answers

Making Excel 2002 use .NET v2.0.50727 runtime

Good morning, I have a .Net 2.0 runtime DLL that I am trying to load from Excel (it's correct regasm'd). I've verified with the Fusion Log Viewer that it is trying to load with the 1.1 runtime instead o 2.0, which explains why it's failing. One…
AlanR
  • 1,162
  • 4
  • 14
  • 26
1
vote
0 answers

Is there a way for me to find out the date when a specific cell was last modified in an Excel spreadsheet?

As the title states, I have a spreadsheet with a column full of float values (groceries payments I've made over time) and I would like to see when I entered the value into each cell. Is this possible or am I out of luck? The version I am running…
Steve Ahlswede
  • 547
  • 1
  • 4
  • 14
1
vote
2 answers

Deleting duplicate text in a cell in excel

I was wondering how to remove duplicate names/text's in a cell. For example Jean Donea Jean Doneasee R.L. Foye R.L. Foyesee J.E. Zimmer J.E. Zimmersee R.P. Reed R.P. Reedsee D.E. Munson D.E. Munsonsee While googling, I stumbled upon a…
Varsha G
  • 25
  • 6
1
vote
2 answers

Using functions like formulas in Excel

I am trying to use a formula to get a letter of the alphabet. Formula: =Keytable(RANDOM,ROW()) Function: Function KeyTable(seed As Long, position As Long) As String Dim i As Long Stop Dim calpha(1 To 26) As String Dim alpha(1 To 26)…
Arlen Beiler
  • 15,336
  • 34
  • 92
  • 135
1
vote
1 answer

Getting wrong date Format while using apache poi DataFormatter on cell

I have used Apache poi DataFormatter class for getting the date same as given in excel sheet. But in the below case, it is failing. For example, if I give the date as 19/9/2017, it is getting as 19/9/17. I have used below code to get the date value…
chitra
  • 5
  • 1
  • 2
1
vote
2 answers

VBA Excel 2007 macro dies in Excel 2002

I have just tried to send a workbook to a friend that has a chart with a drop-down box on it. In excel 2007 I have used: If Chart2.Shapes(2).ControlFormat.ListCount = "16" Then To check the size of the list so that it doesnt get entered in again…
AkkA
  • 131
  • 4
1
vote
1 answer

Is it possible to track the sequence of event handlers as they fire?

Using Excel 2002 and have a VBA "app" that has some UserForms. The main UserForm contains a number of textboxes that fire various Enter/Exit events. I am now running into a issue where one of the textbox exit events fires 2x in a row (I know because…
John M
  • 14,338
  • 29
  • 91
  • 143
0
votes
1 answer

Is it possible to use ado.net in Excel 2002

I have some stability issue with using ADO and latest sybase driver in Excel 2002. I just want to find out if there is any alternative. So is it possible at all to use ADO.net in Excel 2002? Is there any good resources out there?
Anthony Kong
  • 37,791
  • 46
  • 172
  • 304
0
votes
2 answers

Question mark in spreadsheet causes problems in Excel VBA

When I compare the value of a cell that contains ? to a variable, it always returns true. Is there any way I can prevent this? Here is my current code: 'Option Explicit Dim hws As Worksheet Set hws = ActiveSheet Dim rng As Range, rng2 As Range Dim…
Arlen Beiler
  • 15,336
  • 34
  • 92
  • 135
0
votes
1 answer

Excel 2002 Add-In not loading when the application opens

Good afternoon, I created an Excel .xla addin for Excel 2002. This weird behavior I am seeing from it happens only on my machine, but not on my coworkers. I would like to understand why. The add-in has a UDF function that gets called from many,…
AlanR
  • 1,162
  • 4
  • 14
  • 26
0
votes
1 answer

Is it possible to return a list of all ranges from all worksheets in an Excel 2002 workbook?

I want to extract "special" data from an Excel 2002 (client requirement, cannot change) workbook and worksheets contained therein. I have classified ranges in this "special" data category. I would like to acquire a list of all ranges in, ideally,…
a developer
  • 423
  • 1
  • 5
  • 12
0
votes
1 answer

macro over protected and shared worksheet excel

I have a shared and protected worsheet in excel 2012. (protected but without password) I wrote this macro: Private Sub CommandButton1_Click() ActiveSheet.Unprotect Range("B4:K38").Select Selection.Sort Key1:=Range("D4"),…
Pramine
  • 31
  • 7
1
2