When assigning a macro to a button it by default in 3 files automatically
assigns the file path to the name, for example macro 'fullview' becomes,
'k:\operations\richard\testfile.xls!fullview'. If then you open the file as
readonly none of the marcos work as 'Read Only' is in the ...

I have
F2            G2           H2
     Zip Plus4 ZipPlus4
     84116 3153 =CONCATENATE(F2,"-",G2)

I am trying to get a list of sheetnames or at lesat the first sheet name of
a XSL file.
Thanks in advance for any help,
Jack

How do you go about setting the value of one cell equal to a text
string of the value of one cell, &, and the value of another cell?
Specifically, I'm trying to refer to the date values of my begin and
end dates on my timesheet.

I have a small app that allows me to run SQL queries to grab data through a
DSN (MySQL ODBC Connector 3.51) and dump it into a spreadsheet in Excel.
The app works great in Excel 2003. In Excel 2007, however, using “SHOW
COLUMNS FROM `table_name` “ or “DESCRIBE `table_name`” ...

My application is addin to Excel. I am trying to capture Excel Save and
Cancel buttons on Save As dialog box - so that I can call methods relevant to
my app depending on what user pressed. Is there a way to capture those events?
Thanks in advance!

how can i make a shape unselectionable

Hi all! I need help with programming a macro. Currently, I have a
macro which when I run it, grabs data from certain cells and copies
and pastes it in another worksheet. That is working well, so no
problems there. However, I need to add another element to this macro.

Merjet helped me with a macro to locate some particular data and
delete that row on down, and now I have one final formatting thing I
want to do:
I'd like to place a border around a column from the last row of data

I have a worksheet in which a transaction date is entered into cells
in column A.  I need to validate that date when it is entered to
insure it is no earlier than Today() and no greater than Today()+30.
The worksheet is perpetual so data validation at the cell level won't

I have two documents, once which recaps the other.  On the recap
document, depending on certain critera (in this case a store number
and the week it was visited) I need it to find data for the previous
13 weeks and average that data.

I am trying to find a way to "mask" a date field so the user cannot change
the format of the column, or enter any other format other than as I specify.  
I want the field to appear as _ _ / _ _ _ / _ _ _ _ and if the user does not
enter dd/mmm/yyyy it will either not accept when ...

I need to create a number sequence file for data listed as shown.The groups
would be created from the first 12 digits.  Example:  
       UPI                         SEQUENTIAL NUMBER
8DEB90020849A059         0001

Is there a better way to delete all the data on a worksheet than.
Application.Worksheets("WORKSHEET").Range("A1", "Z55500").Value = ""

is 0 an integer?