Hi Hub,Tom,Ron,
If you found the solution to search for *.zip in Excel 2003 over WinXP
Pro, please instruct me to take the steps to overcome the same
situation.

Hi Friends,
    I am making a C# application that will create reports in Excel
from a database. My report involves creating many worksheets. Is there
any limitation for maximum worksheets in a workbook. As per Microsoft

I have a subroutine that is called from an Auto_Open subroutine that is shown
below.  I have narrowed it down to this code as being the reason for excel
crashing on startup.  Excel recoginizes that my Addin is the reason for the
problem and askes if I want to disable it.  When ...

Apologies, but new to using INPUT and FileSystemObject
when i reference a MSword (.doc) file and/or some text (.txt) files using
INPUT or File System Object, it opens the whole contents as one string ie no
line feeds to seperate each row. how can i loop through each row ?

Does anyone know of any code examples of Excel extracting Headers and
Body text from MS Word which can be used and manipulated by excel?
So say if I had header 1,2,3,4 in the MS Word document, and I want to
have the header and body text from header 2 & 4 say to be concatenated

In searching  through the posts in this group for a solution to my problem,
I discovered the forms toolbar and I suspect that part of my solution may
involve that. Can anyone point me to a resource to find more about it.
The real question:

We have a few XLL functions that take (very) large ranges as inputs -
often many thousands of cells. When the sheet is first calculated, many
(if not most) of those cells return as uncalculated when we coerce them
to a value.

I'm stucked; what am I doing wrong?
problem, get rid of the hyperlink formula and have the name in A show,
  'and the link to open when activate1
Arne

i want to create dynamic validation list in excel. The logic shd be like
this.
i m fetching data from SAP on the click of execute button in sheet2.
at this point of time i want to create dynamic validation list in sheet2 in

I'm a biginner to study VBA in excel, anybody can explain for me som
command line following:
Do While (tb.Cells(i, 1) < x) And (i < tb.Rows.Count)
I don't understand *tb.Cells(i, 1)* và *tb.Rows.Count *?. Thanks s

I am trying to save as an excel workbook with macros but when the user
will open it after the save as i dont want the macros to work.
I have a form that kicks in in the Workbook_Open event, i dont want
this event to occur after the save as.

Would anyone please help me write a VBA progam to do the following:
  A cell (e.g. Cell(A1)) contains a string; alphet, 12.3, 23.4, 56.7
  Break the string and put each of them in separate cells (e.g.
alphbet in Cell(B2), 12.3 in Cell(C2),

I have two questions that I'm sure you can help me with
QUESTION 1.
I'm trying to select the whole range below E9 that contains data using the
following code:

I have a program that modify the windows language inside Excel.
Call ExecCmd("rundll32.exe shell32.dll,Control_RunDLL intl.cpl" + ",,5")
When I execute this command, the language inside the control panel is
changed but the number displayed in Excel still show the old language. If I ...

Hi, I have an array 'Static runner()' which I redim when code calls
for it. 'redim runner(1 to 1, 1 to idex)'. Idex is a counter. The
arrays perfect, does everthing I want it to, but I cant seem to figure
out this. (Im sure Ive asked before but cant find the reply). If my