Am I missing an Add-in? I can't believe I wasted my money buying this version
of MS Office, when I can't even use it to complete the assignments when XML
isn't available..
Any clues?

I am trying to do the following with 4 if statements to reflect the status of individual orders:
Column H = Quantity Start (manually entered)
Column P = Quantity Filled (manually entered)
Column S = Quantity Remaining (formula driven ie. Column H - P)

I was wondering if anyone can help me out with this.
I have an in-cell dropdown list that I set up via Data/Validation menu.
All values in the list are uppercase.  For example, "VISA, MASTER,
DISCOVER".  So, user can either choose from the list or manually type

Is there an easy way to clear all textboxes on a form ?

I have a workbook in which I need to delete all sheets except one
called "SummaryReport".  I have tried using the following code
For z = 1 To xlBook.Worksheets.Count
       If xlBook.Worksheets(z).Name <> "SummaryReport" Then

After protecting my sheet with a password, I found that the sort function
will be not available to users without the password. Realized Autofilter can
be enabled using codes. What about "sort" function? Thanks.

I am trying to figure out how to load my entire used area of an excel
sheet into a multi dimensional array.  I cannot seem to find anything
close to doing this.  Does anyone know how to do this?
Thanks a lot,

I've password protected a workbook. It locks down the worksheets to limit
users access. I found, though, that users are easily able to get into the VB
code by either using the Tools drop down or the Alt+F11 keys.
Is there any way to secure the VB code?

What is the Default file format to save an Excel file?  I am using Office
2000.  Thanks.

I am using the Microsoft XML v6.0 library to retrieve a web page from the
Internet, as follows:
 Dim oHttp As Object
 Set oHttp = CreateObject("MSXML2.XMLHTTP")

A friend of mine has a couple of thousand emails in a folder and he's
wondering if it is possible to be able to autoextract an email address
that's within each of the emails and deliver them in an excel sheet.
That's way above my level to suss out.

How can I copy Cells A1, C1, E1 to word as a table wit only one column?
i find it easy to copy as three column but in word there is no option
to Transpose while pasting.
any help?

A co-worker is having a problem with arrow keys and cell movement. When she
hits an arrow key to move the active cell, rather than moving a single cell
it moves a page. Is this an excel option, a keyboard setting?

I know this may seem weird, but I'm trying to write some code that will send
an email from excel 97 with a specified subject, but all i get is
?subject=...  added to the TO field of the email.  Is there any way around
this or is it just excel 97.    The current method works for ...

Hi
I need to export a chart in png format.
Any sugestion?
Thanks