Hello, I'm just wondering if someone could explain why they would make calls
to Windows API? What this actually means, and what extra functionality this
gives VBA? I've seen a few good examples which include things from win32 api,
but I'm a little lost.

I have a macro that process a existing excel file but now I need it to
process many files in a specific folder.  I have open and closed files and
read and written data in C but I need to help getting started on this.  Could
some one give me some starting code or point me in a ...

I wonder is there is some way to collect programatically the different
statistics associated with the regression module of the toolpack, so
that I can display them on a userform
Is it possible?

I do need some help . . . please.  Hope someone can help.
'HERE IS WHAT I NEED AS PART OF MY MACRO . . . . . . . I HAVE AN OPEN
WORKBOOK.
               'The name of the active workbook is   PacificWindsRentRoll.

I have a quick question on how to add a AND statement within an OR.  Like
the below:
if(OR(x=1, y=2, b=3,( j=5 AND t=9 AND p=4))

I have a "model" workbook that I use to create a new workbook for each member
in an organization.  The Model workbook has one macro that is used to
validate the input data that the members will compile.  However, the macro
points to the original macro using a "D:\...." reference ...

Hi,
Hoping someone can help. I am trying to create a button that does the
following
1. Unprotects my excel sheet

How do I capture a Run-time error '1004': Copy Method of Worksheet Class
failed or the like so I retain control of the code?

I have created a Macro that processes an excel file.  Now, I need to be able
to use the same macro to process 9 to 60 files and create a report that is
written to one excel file.
I am thinking that the files to be processed would be in a separate directory.

I have a combo box on a form.  Sometimes when the form is called the combo
box is blank.  I have a button 'OK' that gets the value from the combo box.  
I that value is blank my code for the 'OK' button doesn't work.  There are no
blank cell in the row source for the combo box.  ...

hi,
i have the following:
Dim NewGraphSource As String
Dim testRange As Range

Is there a way to show a "count down" like  1 of 100, 2 of 100, 3 of 100 etc.
in excel while excel is running a macro?
I am working in a folder with 100 files, everytime a file is opened by the
macro can a counter be shown what file it is one, IE 1 of 100 etc.

The following works for me:
Sub SaveAuto()
Dim fname
Dim fpath

I am using John Walkenbach function to extract the Nth element from a string:
this is working fine in most cases bit not when one of my Separator is
char(10) ---> the end of a line, any idea?
Many thanks,

I have a spreadsheet that, among other columns, has an inventory item column
and a quantity column.
The inventory item column has several records with item A, item B, item C,
etc.  The number of items column has several records also with 8 for A in one