I'm very new at VBA and am trying to figure out how to create a macro
that takes the data entered in Column A and then generates directories
using the data in each cell in Column A.
Example

I have a report that I download from a DB and it has a range in column A that
is the date and time(1/16/2008  1:36:08 PM).  I need a macro that will strip
this down to just the date so I can complete so formulas like Days360 between
another date. Can you help?

I've read all the post and blogs on csv files dropping leading zero's
and still haven't found a solution. I have Excel 2002 and when I save
file as .csv it drops the leading zero. I've tried formatting cells as
text before saving as csv, importing data with cells set as text,

Hi to all.
I need some help with exporting excel data to text file, I have data in
cells throughout the worksheet, what I need is a macro to export the data in
all cells to a text file on the desktop, but these need to be a maximum of 12

I get a save prompt many times when I close a workbook with a lot of
vba code even though I just saved the workbook.  Anyone know why this
could be happening?

New user needs some help, please.
I have a workbook with 197 sheets. All the 197 sheets have the same
format (2 columns and 121 rows). I would like to copy data from each
sheet to a summary sheet ("Sheet1") to make a long list.

I am having trouble with this piece of code. I can't seem to make these two
variable work together. If I remove the "And Like "*me*" portion of the If
statement then the code will change the color correctly in the merged cells
but I can't seem to get the 'And' piece to work. Can ...

I have a macro running with sheets that have panes frooze, lets say row one
is frooze.  At the end of the macro the activities of the macro are such that
the first visible row after one is say row six (2-5 have gotten rolled up
behind frozen row one)  How do I say at the end of ...

Hi to all.
I need some help with exporting excel data to text file, I have data in
cells, I have a code for only returning max of 12 characters, this is fine
and working, but the cells that have below 12 characters I need these cells

I have a Maco to paste a persons name in a new row on a master sheet from a
start sheet.
The persons name is now in A1 on master sheet. next time the name will be in
A2 and so on.

Excel XP & Win XP
I have headers in row 2.
I have data in row 3 only, therefore, RngToCopy is B3.  This is correct.
I invoke an Auto-Filter on the data and, as a result, there are NO visible

Dear Experts,
I have an existing pivot table named PivotTable2 in sheet "summary" and its
source in another sheet "Data" in same workbook. "Data" always changes, The
row and columne number in "Data" are two calculated results stored in

I have a macro where i want to save a file but there is an existing file with
that name already. how can i keep the dialog box from popping up and asking
if i want to save it. i have tried the following code but it doesnt work.
Thanks.

I have input the following code and it works to an extent, when it runs
the macro to export the data to text file, the text is all joined and not in
columns, is there anywhere I need to put in so if there is only 5 characters
it will pad the text out to 12 and therefore keep the ...

At the beginning of each month, I need to copy/paste value over a number of
formulas so the results become fixed.  I know how to automate the process
using the recorder, but want it to do it automtically when the 1st of the
month comes.  I'm sure I can do that by making reference ...