2003/2007
Trying to consistently parse formula strings (Delimiter = any Opr sign) into i.e.
OprSigns = Array("+", "-", "*", "/", "^", ">", "<", "<>", ">=", "<=")
FormulaStr =  "+123456789+'Summary 2-22-2007'!H8+'Summary 3-22-2007 '!H22- _

I have a link from one spreadsheet to another
I have the "Don't display the alert and update links" option chosen yet it
still displays an alert when I open the file.
This is annoying because I am using a VBA program from Access to open many

Hey All,
Long time user, never posted though. Here I have about 15,000 rows of
data, all which have formulas in columns K:V. I select all of the rows
which contain a "9" in column T as the value in the cell and cut and

I have some code in Excel that works fine all the time but suddenly, it won't
work in two workbooks that are generated from the Office Link in Access.  To
make matters worst, it work fine yesterday in the two workbooks.  I have no
idea what is going on.  Can anyone help?  Thanks.

I have a User Defined Function which takes a Range as an argument.
It processes the range as follows
   For RowNumber = 1 To DateRange.Rows.Count
           DateFrom = DateRange.Cells(RowNumber, 1).Value

I am trying to put together a macro to run behind a worksheet that
will preform the following procedures:
IF column B contains "PRO", "NOP" or "VAL" at the end of a text string
(eg. 2007/4/SH4A/90507/PRO) and Column CW =1, then copy the row to the

I would like to save some files in a particular folder, for example
(Ven_Folder) in my computer system; but this folder may be transffered to
another directory time after time. So instead of using the absolute path to
fix the file saving location; I would pretty much wish that ...

Hi, I asked this question last week without any response.  I thought
I'd try again since we're implementing this system in several places
now throughout our operations.  Here goes...
I have a several custom command bars, I want to show each always and

Hi, ALL:
Not sure why my previous post didn't show up. This is a repost.
Basically, if I shade a cell with color green (cell format\pattern), I
want to return a pure number of 1. Otherwise, return a value of 0. How

I have written some code to walk through a spreadsheet, compare 1 cell value
to the following row, if it is the same, then to compare a second cell
value, see if it is included in a teststring, if not to add that value to a
teststring, and then continue looping - testing the ...

I definitely need your help!
Whenever i see a cell color as green (done through cell format
\patterns), I want to return a value 1. Otherwise, return a value of
0. How to achieve this using a IF statement?

I have a macro with the following code that I am trying to run so that it
will select the date before today.  I tried inserting <=today() - 1>  
Unfortunately the macro bombs.
Cells.Select

I have a series of sheets containing product data, each with the same
structure.  In the first sheet (e.g. A_MONTH), I have monthly data.  In the
second sheet (A_YTD), I calculate the year to date figures from the data in
the first sheet using a simple SUM command.

How do I clear all cells from all rows except the first row in Sheet1?

I'm pretty new with macros on Excel. I have a macro that when the user delete
the content of any value between the range of B10:B500 do the following
things.
1.Message box asking if they are sure to delete.