I need your help!!!
I'm using MS Office Pro 2007 and in a VBA procedure I use a
Application.WorksheetFunction.VLookup.... that doesn't work - Just returns
error no 400. Am I missing any library?

Private Sub CommandButton1_Click()
Dim Wbmain As Workbook
Workbooks.Open ("C:\Source.xls")
Workbooks("Source.xls").Activate

I use Excel as my data source, and do mail merge using MSWord. I currently
have a master sheet which of course holds all the information. I have other
sheets which hold filtered data. Two Questions.
Is there a way using MSWord to select the filtered data from the main sheet

alot of time i use this SUMPRODUCT formula without any problem, but this
time i don't know somehow this error is coming out, even i checked formula
100 times but just don't know why #value! error is coming out, so plz someone
can help me.

Is it possible to write a script that pulls data from a website into
an Excel document?
We want to pull in data about the number of times a video has been
viewed on Youtube directly into Excel.

I would like a macro to create a chart with twin columns but different axes.
I have recorded a macro using "Line - Column on 2 Axes" which is the closest
towhat Iwant but when I run it, the code fails. (Excel 2003)
Here is the code with a comment at the point where it falls over:

I have a worksheet with a number of toggle buttons on it, which is menu for
opening other workbooks.  When the user double clicks a toggle button it
opens a workbook.
However, the idea is that if the user wants to open more than one workbook,

I use the ActiveWorkbook.Names.Add to memorize the variable value (not
visible to the user) in the excel active workbook
Ex. ActiveWorkbook.Names.Add "Name", VarName, False
but with the Excel 2000 and logon to the pc with a low level user, this

I have workwbook in which I have inserted a number of small images.
Now, the size of the files (Obviously) has increased manyfolds when
all the pictures are inserted.
Is there, a way with which I can find out which picture is causing how

I create a OrgChart via VBA in Excel (more exactly, I run a VBA sub in Excel,
which starts up Word, creates the chart there, then copies it to Excel, because
in Excel you can't put text in the chart's shapes). The problem is, that the
layout looks seriously broken. Shapes are ...

I am facing some problem in regards to formula.
I have two sheets
1. Schedule
2. Input

I'm doing an amortization.  
I have everything working except I want to do a 'payoff' cell....
The payoff will be the sum of payments plus the principal balance.
How can I have this cell update and change as new payments are made?

I have a user form where cell A1 is a input field for "WeekNo., No of days,
or Date. The date is selected by use of the build in calandar.
The range A2-A12 are referenced to A1+1, A1+2 etc.
This works fine, as long the Date is not used, because the Calendar will

I have written a VBA code to create a graph, since my row count is >32000
rows, I created a second series collection for rows 32000 to 64000.  I have
formated the seriescollection so it looks like 1 series. When I try to remove
the legend entry using

Is it possible to remove or inhibit a Forms Close button (Top RH 'X')
Thanks - Kirk