I am not a programmer so I need some help.  I have a comma separated
file that I would like to automatically convert into an XLS file using
a VBA routine.
Text file format has

The formulas have already been entered, and they are different in eac
cell.  Is there a  macro that can activate a range of cells when
highlight all of them? If I do that now, it copies one formula to th
rest of the cells. Please let me know if there is any way to do this?

How can I write a VBA macro which:
--will locate a specific value (a word) in column A of a
multi column worksheet; then
--select that cell's entire row, and all rows above (or

I compile a lot of tables for chess tournaments and am wondering if anyone
can help with the following -
The tables are updated after each result is received, the tables are then
posted to the web.  At present the table rows are left 'as is' with the 1st

I am using a form to enter values into cells in a column. The number o
cells varies each time the template is used.
I need to select the range of cells, calculate the total and read tha
total into another cell.

I have a macro which refresh a web query in sheet Quotes,
and copy/paste these values in Data.  how would you
suggest a better way to have macro paste values in the
last non-blank cell?  I am using a row named DayColumn

Help!
I have programed a couple of vba functions using the fso
on a stand-alone machine successfully. Migrating to a
network based PC causes the following error

In the WorkbookBeforeClose() sub, I perform "required"
fields data check.  After performing the test and prompt
user with a message indicating which which fields are
missing data if there are data missing.  

I have written a function that searches for the lowest value in on
workbook... but this workbook is opened together with other workbook
for analysis.
Part of my function is as follows:

Is there a way to automatically change cell colors based on cell
values? For instances, if I am keeping track of running averages in
one row, can I have it set up to automatically make the cells that
exceed a critical value always be red?

Gentlemen:
I am finding that a number of my clients to whom I distribute
an Excel/VBA software program named TAPS-XL are encountering
difficulty in getting it to load and/or run. To help matters, I have

I am looking for a statement that will allow me to switch
between open workbooks using a string variable with a
temp name.  What I am trying to use, but can not get to
work is;

Why does this code result in a False result?
Public Sub TimeTest()
   Dim dte As Date
   Dim lng As Long

how can I set the path to be the same as the current
workbook path?
Thanks

I have a couple of formulas that I would like to replace with a sub.  This is beyond my capabilities however.  Any suggestions are appreciated.  The formulas follow
=IF(ISBLANK(B22),"",IF(ISBLANK(B23),"",IF((B22-B23=0),"Met",IF((B22-B23<0),"Over","Under")))
=IF(ISBLANK(B22),"" ...