Has anyone got a routine that will save the selected text as csv with
a string delimiter.
I know how to do it without a string delimiter but is there a way with
a string delimiter?

I want to search multiple files for the same cell, and have the information
in that cell (i.e. c2) transferred to a new worksheet.

I have a series of 5 charts in Excel that each track 5 data points as lines.  
The graphs represent a rolling 30 day look at these 25 data points.  Each
day, as I add yesterday's data to the graph, I have to edit the source data
to change the range to be the last 30 days.  

Hi Excel Experts
Is there any way to programmatically set the UsedRange or some other way to
reset the last used row and cell to the real edges of the document so the
horiz and vert sliders work correctly?

I am looking for a formula that will count the number of Sundays within a
date range. Example: I want to enter a start date in one cell, and today's
date in another,and need a formula that will count the number of Sundays
between the two.A1 3/01/2008

I am trying to link a checkbox to a cell on a different sheet than the
checkbox is in. This is the code I am using:
chk.LinkedCell = Sheets("Estimates
DB").Range("estdbcboxlnkcell").Offset(estnum, 0).Address

I'm creating an order form and want to place buttons next to products that,
when clicked, take the user to a web page describing the product.  I've found
a button icon on the "Forms" toolbar, but I'm not adept at VB programming and
I can't figure out how to attach or associate a ...

I have a spreadsheet that tracks time for all employees across all projects.
And I will start a sheet to track employees that are over or under the
alotted monthly time.
So I need to have the Over/Under sheet open the Time workbook, search the

I am having a problem using the paste method regarding pasting a link.
Any help would be greatly appreciated.
Here is a sample of my code:
' DURATION COLUMN

I'm trying to modify the code in a macro to let me select a range of cells
relative to an active cell.  I know how to select a SINGLE cell relative to
an active cell using OFFSET.  For example, selecting a cell two columns to
the right and on the same row as an active cell is ...

Hi everyone.  I have a summary block on the top of a worksheet.  Below
that is data, which is VBA populated and therefore every time the code
is run the amount of rows of data changes.  How can I have a cell in
my Summary section do a direct cell reference on the last row?  For

i got the following code to save a copy of the workbook. I tried to add a
"create shortcut" but it makes the shortcut for the activeworkbook and not
the copy of the workbook...
########################***###########################

I am a rookie in Excel macros. I am just taking over an application that was
developed in Excel 4.0 macro ages ago and the company does not have the time
or resources to re-code the whole thing in VBA. But they want the same Excel
4.0 macro application to run in Office 2007.

Hello all,
Everytime I run a macro it opens my PERSONAL.xls sheet.  I would like to
write code at the end of each macro which closes Personal.xls.  What would
the code look like to do that?  Thanks

Hi everyone.  I have a large data sheet, with the first 6 columns of
data I need.  Column 1 of the data sheet is an invoice number.  I then
have a calculation sheet.  In cell A2 of the calculation sheet is an
invoice number.  Can I have vba scan column A of the data sheet for