I have a sheet where there are 8 cells with a hyperlink to the same worksheet. There is a
worksheet activate procedure in that second worksheet. What I would like to do is to vary
that procedure with whatever hyperlink was selected in Sheet 1 for example. Is there a way
to ...

Hello group,
I am using the Application.filesearch and the following code
If .execute(SortBy:=msoSortByFileName, _
   SortOrder:=msoSortOrderAscending) > 0 Then

For some reason the "Advisor" sections run fine.  As soon as the ws name
changes to 'Annuity' I get a 'Method row of Object '_Global failed.  wsOld
and wbkOld are set.  Debug gives me the correct names.  Is there something
about global variables I've missed?

Hello.  I'm using Excel 2003 and setting up several buttons.  Rather then a
picture, the users would prefer text on the button face.  Here is a sample of
setting the properties but I am not sure of how text is entered for the
.FaceID.  If anyone knows, please let me know.

I'm attempt to have users write on an Excel User form and when they hit a
submit button, it needs to write to another Excel file on a share drive. Is
this feasible? Im not sure if I even know where to begin on this one.

i have this array formula that i can't quite finish. maybe it can't be done with
a formula. i already have code that gives me the correct result., just wondering
if this formula may work. maybe sumproduct would work.
=(SUM((1-TRANSPOSE(H2:H4))*G22:I22)+SUM(G22:I22))/TRANSPOSE($M$2 ...

I have a parent folder called MySite.  There are child folders within
it.  I want to search through VBA the parent folder and all subfolders
for any .htm file.  Then each .htm file is searched for any reference
of an 'href' tag.  For some reason I can only get it to pull the one

Example:
1     2     3     4     5     6     7     8     9     10
3     5     6     7     8     2     1     4     9      0
I want to take low five numbers and average them.

Excel 2003 allows you to view a list of nine of your most recently opened
files.  Is there a VBA procedure available that would provide a list of even
more files?  For example, could the code code return a list of 50 most recent
files?

i have a situation where i need to setup a formula so that when it
checks for a specific data like a number between 1 and 228 a one
specific number will be outputted on a diffrent page on the same
file.

I would like an alert to pop up if someone tries to run a macro while the
workbook is in shared rather than exclusive mode. How would I do this?
Many thanks
Louise

Greeting,
I have a list of integer value, and am wondering how to get the average of
the list but discarding the min and max from the list.For example:
list:

I would like ask if there's a way to copy a worksheet from a workbook A into
workbook B, without actually opening workbook A?
Thanks,
Ben

I have a strange problem which occurs every now and then.
I have created e.g. Form1 which has a ListBox1. Then I fill in the list with
years:
For X=2004 To 2010

After my macro runs (and does a "file save as" automatically) I want a popup
message box to display with an OK or Continue button, and a simple message
stating that the file was saved or the process is complete.    If you have
code that can verify that the file was saved that ...