I have some users who are totally enamored with the new XL 2007 ribbon
interface (doesn't matter why ... they just do) and they now want my Excel
based application to use a ribbon even when running under XL 2003.
So I'm thinking of picking up a 3rd party ribbon control (say from

Using VB, I'm trying to test if the activeworkbook is shared.
Something like this, but it doesn't work.
If ActiveWorkbook.ExclusiveAccess = False
So how would I write this code?

Is it possible to drag from a TreeView to an excel worksheet where the
TreeView was spawned from a click event on a command bar button ? The command
bar is created by a VSTO app-level add-in. We are using C#.
More specifically, the nodes in the TreeView represent Reports that ...

I have the following:
Column A         B         C
123456781      name1    473
123456782      name2    471

How do I make a list box in a form that to the left of the list item there is
a check box or so that I can select multiple items in the list box?
Thanks

XL2003 on XP
   Selection.EntireRow.AutoFit
When I use this with most rows, it does what I expect.  However, if the row
has merged cells with wrap text on and an entry long enough to cause it to

I need to generate a random uniqe alfanumeric number for approx. 1000 lines.
I expect it to be on 4 or 6 digits. Do anyone know how to do that?

I am importing several text files into a workbook. Each file name becomes the
name of its worksheet. There is one file name, however, that is too long for
the worksheet and its sheet name reverts to the default Sheet4 (or whatever
number sheet it happens to be at). The number of ...

Hello,
I am new in Office programming, and I wonder how to select in the best way
the groups of "used" empty cells from the first column A.
  A B C

How do I assign different macros to up & down spinner buttons?
I want to imporve on the standard up/down by integers the standard
control offers by writing some code myself, but I can only assign a
macro to the whole control (Up & Down)

I am cvurrently running Excel 2007.
1.  Could somebody please tell me how to create a push button within a
worksheet.
2.  a macro that I can amend which when the buttonj is pressed will clear

Hi,  I have the following code in to run a query from a button and this works
great - except for the fact that instead of replacing existing data it places
the new data beside it - moving along the columns each time.
Please can someone help point out where I have gone wrong.

I have a simple table with three columns
1. Title
2. Value
3. Color

How do I check to find out if Tempdata.xls is open and if it is close it?

I have 2 col , each having certain unique values. I need to re arrange both
the col randomly.
e.g., 1 st col contains unique names and 2nd col contains certain ID's (
numeric/text). I need to assign these ID's randomly to each names.