I have added Calender Control 10.0 as an add-in.  I want to allow the user to
use a calender to select a date for input via Inputbox.  Once the date is
selected and entered, a macro is going to use the date.
I have no clue how to activate/use the calender control. How is this

This is a relatively new problem (last couple of days).  I've had no new
software or patches installed, but whenever I double click on an Excel file
to open it, Excel will open, but the workbook that I double-clicked fails to
open.

What's the difference between an index and percentage growth/decline?
Example: Last year's volume was 158 vs 2006's volume of 97. If I
divide 158 / 97 I get 162.9. Isn't that the same as 62.9%? Why would I
use one over the other and if I decide I don't want it to read 162.9,

The column headings in an Excel spreadsheet switched from letters (A,B,C,
etc.) to numbers (1,2,3, etc.)  This happened in only one of my spreadsheets.
Why did this happen, and how can I change the columns back to letters?

I have two spreadsheets that contain names, addresses, telephone numbers,
etc. of prospects.  Both sheets have about 4000+- contacts.  I want to
compare the two and accomplish a couple things but i'll just start with the
first and go from there:

I have a workbook with numerous worksheets in it.  Each work sheet has
information down colum A.  In the first Worksheet i want it to gather all the
information in colum A of each persons Sheet.  For example.  In the main
worksheet it will say Employee1!$A$1 in Row 2 Column B.  ...

Just wondering if there's a function or way to use Excel to provide another
example, or the actual pattern of numbers if you input some that you know.
Eg, 125873 , 264729
Code would be1st digit times 3 = last digit

How can I automate collecting information from 30+ workbooks that all have
the same format (i.e. Cell B25 in all workbooks has the same type of
information) and generating a report or another spreadsheet from the
collected information.  

I inserted in a NEW workbook a Chip's Macro presented below;
Then I also saved the file;
Closed & reopened the same;
But upon Alt+F8 the macro name is not found to be listed in the Alt+F8

I'm a quite amatuer in Excel so I need a help in the following:
I developed a spreadsheet with several worksheets named each by months of
year. Each monthly sheet contains datas in same structures - they are daily
production figures, losses etc.

I have acquired a large spreadsheet with a column of cells each of whose
contents are like [1.234 6.712  5.436]
Numbers like these, contained in square brackets, are from another
application. How do I extract each number and place them in cells in

Excel 2003 SP3
WinXP Pro SP2
Header in Row 1
Data starts in Row 2

I downloaded the test-drive version of Excell 2007. Since the expiration has
expired, all my Excell files are saved as 2007 as read-only.  Does anyone
know how I can convert those files back to 2003?  I read a posting that said
save them as a 2003 file.  How do I do that?  I ...

I have a table with agents in column A, with various rates for various
services in Columns B-F.
I want to look up agent X and service Y and have the cell return the
correct rate.

I need to find out how to change the gridline style in Excel.  The system I
am on has black dotted gridlines (like the dotted style borders) and I would
like to change them to the solid, light grey gridlines.  I am in Excel 2003.