I have a VBA routine (XL2003) that scans the harddrive for workbooks with a
certain pattern (first 4 charac ters of name = "CLSd") in the filename.  I
am currently using ExecuteExcel4Macro to read data from each of these
workbooks without having to open each one. I do this for ...

I am using ADO to edit data in a SQL database.
My problem is how to select a record.
Using "Find" on the recordset works, but takes several minutes.
Using "Excecute" on the connection to run a SQL query only takes seconds

I was wondering if it would be possible to hide the normal excel window
while a macro was running. Thanks
- David

Office XP, Win XP
I setup a Restore point.
I installed Acrobat 6.0 Professional.
This caused problems in Excel and Word.

Dear gurus:
Upon compiling the following code I receive the error message:
"Compiler error
Only user-defined types defined in public object modules can be coerced to

How would I hide any rows in my worksheet if there is *not* a bold font in
column E,F, I or J?  The bold font could appear in just one of these
columns, or in multiple.
Thanks in advance!

Im sure someone can help me with this. I have created an input box for
some data pasted in from another program. Some of these lines are
headers and page breaks which I want to remove , I have got an if
statement to flag each line with a Y if it needs deleting and for one

How i can refer a group of controls?
for eg. in mu userform when clicking a button i have to hide a few
labels, textboxes and comboboxes.
instead of saying textbox1 visible =false and combobox1 visible =false

I need to trap a possible running program and stop it, then re-start
it. This is so I can use sendkeys to extract information from a known
reference point. I have studied the newsgroups and established I need
to use API routines to allow activation and subsequent continuation,

I am trying to render all the possible combonations of two sets of alpa
data.
For example
Price

I working with several files, I write macros to open them, but I don't want
the macro to run if the file is already open, what command can I use to check
for this
Working in Excel

When I copy and paste to a workbook the USA TODAY NFL spreads, I lose every
other row such as follows:
    A                    B         C            D
1 BUFFALO              5½  N.Y. Jets   34½

Hi;
I have just completed an UserForm with 45 input fields which get
manipulated, concatenated and optioned down to 25 items of data.  The 25
items will be inserted into 25 different worksheet database columns.  The

I have an excel sheet
how to find out the maximum number of times a particular text has been
appeared continuously in a column ?
say i have column like this

I have these two cboboxes in my app and the 'cascading' works great.
What I need is the coding for ThirdCboBox that would be using both of
the first two cboboxes to limit the choices available to the userin
the third cbobox , but I don't know how to construct the sql statement