I have a worksheet with Customized BeforeSave and BeforeClose events.
The Customized BeforeSave event allows me to let the user save the workbook
and then output one of the sheets in xml format to a file with the same name
as the workbook but with a .xml extension.

Is there any way to access a local workstation's TEMP directory? Maybe it
needs a Windows API, but I don't know how to do it. Thanks for your
assistance.
Frederick Chow

hello,
-New to the forum; hope you guys may have some advice.
I have a weekly generated invoice, which needs data calculated an
adjusted.  While the layout will be the same each week, the length wil

can someone show me how I can enter a string into a text box, then browse to
an excel file and search through it to see if that exists in the file
thanks

Hi I am learning to use macro's and am having trouble determining the formula
to put in a macro. ( I only have two variables and I know that conditional
formatting can do this but I am trying to learn what to do.)  My variables
are that the cell would contain either more than 4 ...

I have tried this for days, and can't seem to get it to work.
How do I compare values that are in a user form with cell values on a
spreadsheet and if the same, stop the macro, and then msgbox to user "blah
blah".

I've got a thesis riding on this, so any help would be _REALLY
appreciated! :)
I've got some experimental data in an Excel file with two columns: On
with words and one with numbers.

hello to all
I have a code line...
ActiveCell.Formula = "=COUNT(P5:P15)"
But the rowOffset won't always be 10.   I've defined a rowOffset, called

whats is the END IF statement to stop a loop at an empty cell
THnaks
Darren

I have a moving list which is the source of validation. I estimated that I
would be using 120 items which are not yet all known. When a new item is
entered, I need to re-sort the list alphabetically so that the names that
will appear on the drop down box of the validation would ...

I have two tables, which is to generate a form.
- The first table has 8 different cost centers.
- The second table have a list of task numbers, and the linked cos
centres.

How can I create a comment like box (like cell comment) on a user form.  If a
user enters an area, this box shows up - no header, etc.
Is this possible??
Thx,

I need to learn about vba IF Statements so here is an eample of what I do and
amy I ask the best way to do it in excel
I have in column B different metrics, I need to read what they are and place
a result in another column say C. I do this many times so if I could see how

how do I insert rows into a sorted range, when the sort changes from one row
to the next
Thanks
Darren

I have tried to add the below VBA-code from
http://www.ozgrid.com/VBA/autofilter-criteria.htm in a new module, but
it continues to return #NAME? when I try to use the function:
Function AutoFilter_Criteria(Header As Range) As String