I'm using Excel 2007, and a really nice and smart person in this newsgroups
area taught me just now how to create pivot tables.
But, I don't see of a way in the pivot table how to do top 10 analysis.  
When I right click on the criteria, there is no top 10 list selection.

I need to use a macro to pull values from cells in a closed workbook and i
can't seem to get it right. I basically have a variable for the directory
path and another for the file name. How do I go about getting a value from a
cell in that workbook and putting it into a ...

Thanks to some generous help from users of this site, I, with no Visual Basic
knowledge, am using some VB code that requires the user to type his/her name
into a given cell before the file can be saved, since the name must appear on
the printed version. The user-name field is ...

I am not a professional programmer, just someone who needs to use Excel VBA
to solve problems from time to time. Sometimes I wish I had a bit more basic
programming knowledge, e.g. basic sorting algorithms, recursions. Can
someone recommend some good books for me to read (or ...

Is there a way to limit a user to a specific # of Rows & Columns upon opening
the workbook/worksheet?  
Linda

We are using excel for a duel purpose.
For the calculations.  And also for a pseudo user interface.
Is there any way to have float over bubbles.  When you hover over a cell?
Or can you get float over bubbles when you select a cell?

I am trying to change a background color of a cell.
I would like to do it with out "selecting" the cell.
When I run record a macro I get the following:
   objRange.Font.in

I'm troubleshooting a problem with Microsoft Excel VBA. The error is:
Compile Error can't find project or library.
It occurs in the VBA method CommandButton_ok_Click.
They are using version 2002 of Excel. This same error does not happen with

How do I get the workbook I've created to print in sequence as the tabs
appear at the bottom of the screen?  I believe I may have reordered the
tabs/worksheets early on, and now they print out of sequence (i.e. page 5,
then 6, then 4, then 1, then 2, then 3).

I have a number of workbooks in a folder (number varies) which I have to
open and add the values of the same range ("F15:M34") in each workbook into
a summary workbook.
The code below works, but to me appears long winded, is there an easier more

Would anyone know a better way to remove the first line of a huge txt
file?
I am using a FileSystemObject/TextStream, doing a first readline, and
then looping:

Hello all i have a question i need to compair only the first 5 or 6 numbers
in Collumn A and Collumn B and put a the result in c I have it to right now
where it will compair the whole list is there a way to get it to do only the
first 5 0r 6 numbers my macro that i have for ...

is there a way to open, by Excel vba code, another Excel file and naviagate
in the sheets and cells ?
From which other 'language' can i navigate in the cells of a Excel file ?
Thanks

I have a spreadsheet (exported from MS Access) which contains the following
info in each column;
Column A: Client Name
Column B: Client Code

Can anybody help me with a simple Macro to sort the sheet according to 3rd
column and the number of rows is not known. Please explain about the
important part of Macro too.
Thanks