software

Once I saved an Excel file to .csv file, how can I protect .csv file with a
password?

I know this process can be done in VBA. I have done it. But using vba also
requires that I have a mechanism to run the code. This would either be a

I am writing a formula to calculate the last and next month end e.g. if I
enter 28-02-06, the expected result will be liked 31-01-06 and 31-03-06.

Is there a way in Excel to use the Min function to determine the minimum
value in a column, and copy that entire row to a new area of the

I'd like to count the number of cells in a range whose value is between two
preset numbers. I would imagine that it would be something like

I actually have two questions,
I have a spreadsheet with rolling data- everytime I insert a new line the

I have a problem in that I currently run a macro that opens all the workbooks
in a particular folder, and merges the data onto one new worksheet, which

I have imported a query into excel and I'm having a problem sorting the data.
The data consists of part #, description, technician #, usage qty, and usage

I have been trying to get a formula to work for the following:

My worksheet is a usable form with cells that are selected by changing thier
color. If the cell is a certain color, the reader of the form knows which