I need to know the way of generating a text file from data availbabe in an
Excel spreadsheet either using a Macro or a Script!
Asume if I have some data in few cells such as C5, C6 and C7
then if I have a simple formula like Sum in another cell like C8 to get the

I have a list of customer names and addresses that are grouped by Sales Rep
code.  I need a way to split this list out into invidual worbooks to
distribute to the appropriate rep, then reconsolidate the changes back in to
one master again. After struggling all day, I've concluded ...

I have a string of numbers, but they've been entered as:
357,041
332,224
341,038

i have the following text:
AAA_llac_MAR_99_eg
i am trying to write a formula to extract the text between the second
and third occurance of '_" (the delimiter). Basically i want to

My company is installing Office 2007 incrementally.  I'm posting to
see if there are any compatibility issues with VBA projects developed
in earlier versions.  Or any other "good to knows" about 2007 VBA that
may be helpful.

I have a userform that contains over 24 data elements (textboxes &
comboboxes) used to accept data and place in a spreadsheet.  I want to use
the same userform to pull the data, that was originally entered, back into
the userform when a user clicks the commandbutton to EDIT data.

I have the following code that should delete any row that doesn't have the
value of Defective in my range but it is deleting everything.  Please help.
lastrow = Cells(Rows.Count, "A").End(xlUp).Row
   For Each c In ActiveSheet.Range("C2:C" & lastrow)

By vba, how can I
a) insert a bold black border along the top edge of every fifth row down to
about row 1000 ( and along the row to K)?
b) make every fifth cell in column K a dropdown list using data validation?

I have a db query that take a long time to run.  I was wondering if I
could have a progress bar updating while the query is running.
Essentially I would estimate how long the query would take and set a
loop to take approximately the same time.

in my workbook
on sheet 1, i have this infor
column A                column   B
mike                          20

this is a 2 part because i dont think the first part is possible
1) i'd like to have a function that has no arguments but references
the cell that the formula for the function is being input into and
just takes the value of the first non empty cell to the left (i dont

Is the only way to open another workbook programatically from the workbook
that is currently open to use the Workbooks.Open filename:= command to supply
the path and the workbook name?  Is there any way you can open another
workbook that resides in the same directory without ...

I need retriveve data from MS Access database which is password protected.
I tried to build connection string with password but none of them works.
any one knows  the format to pass password to pasword protected database?
Your help is great appreciated,

I have a macro i need to run that fills in the date and time. For example I
have data in column A and i need to put the date and time in column B
everywhere there is data in column A. Date and time format needs to be
1/17/2008 6:30:00 PM.

I am sure I am doing something wrong as my code works on other forms
Private Sub ComboReasonforcall_Change()
ComboReasonforcall.AddItem "SELECT"
ComboReasonforcall.AddItem "General Query"