Stack Overflow
Stack Overflow

Questions tagged [excel-2000]

Excel 2000 is one of the releases of Microsoft's Excel. It introduced a minor upgrade to the notepad. The Office Assistant was also made less intrusive.

23 questions
8
votes
3 answers

Forcing Garbage Collection

Is there a way to force garbage collection in VBA/Excel 2000? This question refers to the Macro language in Excel. Not using VB .NET to manipulate Excel. So GC.collect() won't work
Zen
  • 1,928
  • 3
  • 12
  • 17
6
votes
8 answers

Opening semicolon delimited CSV file

How does one open a semicolon delimited CSV file with VBA in Excel 2000? Sample data An ID;TEST20090222 A Name;Firstname Surname A…
Lernkurve
  • 20,203
  • 28
  • 86
  • 118
4
votes
4 answers

Errors Raised within Class Debug As If Raised at Property Call

I am (unfortunately) developing an application in Excel 2000 VBA. I believe I have discovered that any error raised within a Custom Class property, function, or sub debugs as if the error were raised at the point in the VBA code where the property…
Carl G
  • 17,394
  • 14
  • 91
  • 115
3
votes
1 answer

ActiveDocument.SaveAs2 not working in Excel 2000 but fine in 2010 and 2016

I have used a modified version of code supplied by Jtchase08 in another thread and it works fine in Excel 2010 and 2016 when I change the object library to the relevant Microsoft word version, however in an attempt to make the same thing work in…
Parky
  • 35
  • 1
  • 6
1
vote
1 answer

Returning data from across multiple worksheets in Excel

How do you create formulas that will return the totals, averages, counts, min, max, etc from different worksheets? The columns (that exist) are consistent in their header information, but may or may not be different from one sheet to the next,…
user3752758
  • 35
  • 6
1
vote
2 answers

Average function

I have a huge set of data which gets updated every month. I would like to check if the new data differs from previous months in %. It look like this: month name data jan 551 2 jan 552 20 dec 553 12 jan 553 13 dec …
Anders
  • 31
  • 1
  • 2
1
vote
1 answer

Is it possible to add reference to a version of Excel if it's not currently installed?

Using Visual Basic 2008 Express Edition 2 PCs are involved: PC1 has VBEE and Excel 2007 installed PC2 (target machine) does not have VBEE installed, and has Excel 2000 What I am trying to accomplish is to build an app on PC1 to use on PC2. Of…
MSD
  • 48
  • 5
1
vote
1 answer

run time error 438 at ListObjects.Add method only on older version of Excel

It has been around 2 weeks since I started working on excel vba. I have a sub which converts a range of data into a table: Sub RangeToTable(fileName, sheetname, rng, tblNm) With Sheets(sheetname) .ListObjects.Add(xlSrcRange, .Range(rng),…
user5916275
  • 11
  • 1
1
vote
1 answer

Changing pivot chart unit

I've got a pivot chart which spans several years on the X axis, with data for each day. The problem is that there's a label on the X axis for each day, so they are too cluttered to be readable. I'd like to show just the months as labels instead of…
l0b0
  • 55,365
  • 30
  • 138
  • 223
1
vote
1 answer

Set line weight for all series in pivot chart

I've tried looking around all the chart options, but I can't seem to find a way to set the line width of the chart series once and for all. Of course, I could run a macro every time the series selection in the pivot chart is changed, but I'm hoping…
l0b0
  • 55,365
  • 30
  • 138
  • 223
0
votes
3 answers

Excel 2003 protected worksheet, not allowing Excel 2000 users to use autofilter

I have created a spreadsheet for work and am trying to protect the sheet so that nobody except myself can edit the document. I have set it up so that I can edit the full range of the document. In the protection setting I have ticked the box that…
Stefan
  • 327
  • 1
  • 5
  • 18
0
votes
1 answer

Is there a function for showing current date and time?

I have Microsoft Excel 2000 on my pc. I want to show the current date and time in a cell. I looked in Help and found the NOW() function. It does display the current date, but as for the current time, it doesn't show AM or PM, it shows: 4/19/2011…
katura
  • 2,177
  • 14
  • 39
  • 48
0
votes
1 answer

Change the column value data type (dates)

I have an Excel 2000 file with around 25 columns. In column18 the column name is "MONTH" and its data type is Date Time. The value is displayed as (1/5/2009) in format(dd/mm/yyyy). I need to change its data type to string and display the data in…
happysmile
  • 7,537
  • 36
  • 105
  • 181
0
votes
0 answers

Workbook.SaveAs method for excel 2000

I have an application created on c# that opens a workbook then populate it with data then it will be saveas with a new file name. The problem is my application crashes when the PC is using excel 2000 and it works just fine for higher version of…
John Pasao
  • 1
  • 2
0
votes
1 answer

How to Change an Excel WorkSheet TabColor in Delphi 6 with using Excel2000.pas?

I have an application that creates an ExcelWorkbook. In workbook have some sheets and i want to change color of the tab color for each sheets. Example Code Below: ExcelApplication.WorkBooks[1].WorkSheets[1].Name :=…
Can Emre Unal
  • 49
  • 6
1
2