I have a find that returns the range of a cell where the search-value
is found. does anyone know how i can determine the column where this
cell is located?
Code:

On a form I have a multipage with a number of pages and controls.
I cannot get ActiveControl.Name to return the control with focus as this
only returns "MultiPage1".  MultiPage1.Page1.ActiveControl.Name has no effect.
What should the correct syntax be to address controls on Page1 ...

i need to get the sr no column  to generate auto number.
any code avaialble for that?

Excel people, my heroes...
I have a fantastic purchase order form i've been working on for a week
now, i love it!
It looks just like the old paper version

I am hoping that someone can help me with this problem.
Is there anyway to prevent a user from doing File - Save As? (preferably
using macros)
I am happy for them to make changes to a workbook, but do not want them to

Hi all, seems like a nice place this!
I'm trying to get a macro that does the following:
Searches in a set folder for excel sheets
Lists them in a sheet

I want to set the format of a cell in excel throug vb6.
Already created the excel.application object (xl)m and created workbook.
How would I do it. I would like to set it to text.
Thanks.

I am trying to resize my columns in Excel through VB6.
I have created my excel.appliation object (xl) and created a new workbook.
Now I want to use the code:
xl.Cells(1, 1).Width = 100, but I get: Unable to set the width property of

How can I ensure that the information which I have entered earlier into the
form is saved to make filling out forms faster? For instance, in the "Name
Field", I have earlier keyed in names like "Andrew","Aaron", and the next
time when I want to key in "Andrew", I need not key in ...

Hi everyone,
I need to update every month file references in a master file. The
reference files are updated every month with production data and stored
in a different folder on a P drive. The folders have the same structure

I have a generated filesearch list of files, in a master workbook (FM
Purchase Order.xls).
Is there a macro that i can put in the auto_open bit of the searched
files, to say:

Hope this makes sense.
I have a combobox on a form (say called MyCBX) which when the form is
initialised is populated with a named range (say MyRange) consisting of 2
columns. The relevant properties of the combo box are:

I'm trying to find the range of a cell that contains the string <tea
member name> , output this range and have that content replaced wit
the content of a cell in another workbook.
i have a sub that looks like this:

i need to devlope a format which contains two excel sheets.
one sheet having columns named as sr no., products and the details of
their distributions and reciepts.
second sheet contains the sr no. & products.

Trying to figure out what the best way is to deal with the
problem of installing an .xla add-in when the user has multiple versions of
Excel.
My installation now works with COM automation in an INNO script.