I have looked at all the information that has been posted regarding late
binding and I have also tried some of them however it doesn't seem to work
for me.
I am hoping someone can help me.

Hi Listers,
We have created a heavy excel application with around 500 macros in
it. The application itself is in the different sheets of the workbook.
My queries are:

Hi Experts,
I am trying to create a macro to open various files with a loop and to
share the files with "Keep Change History For" set to 100 days instead
of default 30 days.

I have an Excel 2007 spreadsheet with a column of primary keys that match
data in a FileMaker 9 database that is accessible via ODBC (using the
DataDirect SequeLink 5.5 drivers). What I'd like is to be able to fill the
second column with live data from the FileMaker database.

I need a macro to change the name of a tab to the name of the Excel file.
Here's what I've got (the original name of the tab is "compliled").  It
doesn't work:
Sheets("compiled").Select

In Excel, some cells have been merged (e.g.  cells(B3:E3)), I clicked the
column C and  column C was been selected,and the vba was "
column(C:C).Select".
But when I ran this VBA,column(B,C,D,E)'re all selected.

The dates in a text field are all 6 characters long,e.g., 060107, 1019/07.
060505, etc.  Some dates also appear as 000OCT, 000AUG, 000SEP, etc.
I'm trying use sql code to extract records from a database.  The code is as
follows:

' I'm 'Shell'ing Photoshop Elements, which
' takes awhile to get settled.  Using
' Sendkeys "{END}", True and then
' WaitForInputIdle(..) does the job,

I have a spreadsheet that requires user input
in rows for various criteria and produces a report based on that
information.
The first cell in column D (D8) contains a value that I would like to

I have created a templete with a 2 macros in it. The first is a macro that
will be needed within new book which will be created from the template. The
second is an automatic macro designed to set up the book and (hopefully)
delete itself from the book (the macro can't be deleted ...

Simplified Sample below :
Criteria in A2 thru A4
Columns to be summed B, C, F in Rows 2 to 4. Data Rows 8 to 13
Col A   Col B   Col C    Col F

Recently some users got new PC's with Vista and Excel 2007.  Now this macro
does not build a custom menu when the file is opened?  Can I have my code
detect the version of Excel and then is there a modified version of this
menu-building macro for Excel 2007?

I would like to change the focus from the current worksheet to another when a
value in a specific range is changed.  This is an easy VB statement but I am
going round in circles... Please Help
Thanks

I have a Userform that captures a date in a TextBox. I wish to allow
some user shortcuts whereby the user presses a keyboard character to
modify the date.  For example, "+" increases the date by 1 day and "-"
reduces it by one day.

Is it possible to write into a macro a conditional format?  What I want to
do is if the cell A3 is <A1 or >2 then turn A3 red and bolded.  After that I
want Cell A5 to count the Red Bolded cells.
A1    A2    A3