Using Office 2003 and Windows XP;
I need to call a program from a currently active XL file to another XL file;
I know you can a syntax like:
Application.Run "'FullFileName'!MacroName"

How do I calculate the z factor automatically by using Hall-Yarborogh equation without changing (Y) every time to reach F=0 ?
if any body know .please answer me.
Thank you very much
khalid

I want to show a list of available font names, have the user select a name
from the list, and put the name of the selected font into a cell.  I do not
want font size, color, etc. shown, just the names of the fonts.  It would be
ideal to show the font selection box from the format ...

I get a subscript out of range on the line with the asterisks in the page
setup sub.  It runs through the getsubtotal and issubtotal functions  several
times before it gets this runtime error.  Is it because Excel is overloaded?  
It runs through the functions to see if it is a ...

I'd like to make a macro that changes all tabs to red when the file is Saved
As somethings else.  Once they are "reset" in a save as mode, they are free
to be changed manually, I just would like to have a script that defaults a
new file to red tabs.

I know you can nudge shapes X pixels or what have you, but is there a
way to set the image to a home position... IE position it in the top
left corner so I can know how far to move it OR position the image
relative to other images already in place?

I have a worksheet in which a user will select a defined range somewhere in
column A, in which I want to put the following relative formula, (assuming
that the user is starting in cell A12):
=INDEX(Chart!$A:$A,MATCH($C12,Chart!$C:$C,0))

this is my line
ActiveChart.SetSourceData Source:=Sheets("Sheet9").Range("A5")
and i keep getting an error becuase, Sheets9 will stay like that, but every
time i run my macro, the sheet number where this is saved will be increasing

I posted this in July under "Calculating Vacation" without a resonse. I
thought I had it working, but was tripped up when we went live. Any
assistance would be greatly appreciated.
I'm trying to calculate vacation accrual with the following specs:

Hello Excel group.
Is there a way (better or easier that the "filter, advanced, unique")
to filter out records with duplicate data.
For example - i have imported a text file into excel (i would prefer a

I am creating an Excel 2002 sheet programmatically using VB.Net.  It all
works fine.  But now I'd like to add a photograph to each row.  I've done
searches but all the hits I get must be for VBA rather than VB.Net.  In any
event the hits have not helped.  I'm aware of

I am working on having macro in Excel 2003 run a macro in a MS Access
database.  The macro in access runs make-table queries from linked SQL
tables.  All is fine except I keep getting the following message when the
access macro is running:  "Microsoft Office Excel is waiting for ...

could someone give me a hand with this piece of code which I can't get to
work for me:
indPlan = Sheets("pivot").Range("L46").Value
     Select Case indPlan

I'm trying to set the contents of cell A6 in the "General Documentation"
worksheet of the active workbook to a variable. First I test for the General
Documentation worksheet, and that part of my code works. Here's the next part:
Dim CellDesc As String

I have an array of sheets, and which ever ones are visible I would like
it to be deleted, if not do nothing..
So for eg if Master_D and Master are visible then delete them (curretnly
VB is getting stuck cause its trying to delete Master, and it isnt