I am using VB to call a particular SUB of different files.
I have the following code working fine.  I need help to modify the 4th
line to make it dynamic.
'***********************************

I am pulling data from an LDAP server and run into this error when the
following code:
    RecordValue = oObj.Get(Feild(LoopCounter))
tries to pull data for a data field that is blank.  I'm just reading data

I got the following code
Sub message()
Dim Response As Integer
Dim destWB1 As Workbook

I have just discovered that a Macro I worked on a couple of weeks back has
some sort of bug in it, and now I need your help to find it!
DESCRIPTION
The macro is designed to compare data between a number of worksheets within

Hi, Please see the Excel file by clicking on or by typing in internet
address bar the link below.  I need a Macro or Formula to calculate
specific balance. Every thing been explained on the Excel sheet.
Please if anybody can help

I recorded a basic macro and want to add a WHERE statement in the body and
need some help.  I recorded
Range("B2").Select
   ActiveCell.FormulaR1C1 = "1"

I'm using EXCEL office 2003.  I'm trying to average from several cells (which
have linked information from other pages), some of the cells have 0 in them.  
I've looked up all the ways to have 0 not be included, and it works on all
the averages except when I'm bringing information ...

I have two problems with the same code - I am finding that when i run the
macro, it copies the specified cells into the report sheet but it doesnt copy
from the 1st cell/row under the column header row.. (for examples, intead of
copying from C2 it copies from C3 onwards.. but ...

I have written some VBA code to retrieve information using the Essbase
add-in.  I am able to manage the Excel errors and warnings so that the
code can continue without intervention from the user, but I am not
able to do the same with the Essbase errors & warnings.

if it possible to write a program that will return the Row/ column
number of the cells contain certain value?

I require assistance with showing a value within the active cell.
It is intended for a internal company survey, where ratings are given
against adjacent questions.
For example, there are 5 questions, 5 possible ratings.

Is it possible to paste a template onto a user form?

I would like to delete the row if a column "status" changes to "closed.
this is what I got, but of course it is not working can you help?
Dim cnclrge As Range
'    If ActiveCell.Offset(0, 17) = "Closed" Then

ENV: Excel 2003 running on XP
PROBLEM DETAILS:
I have a call as:
=VLOOKUP($A4, '[NEW FNO EOD Data.xls]03-Dec'!$B$2:'[NEW FNO EOD

I am familiar with using the record macro function in excel, but I
would like to have excel prompt me as to what file I would like to
select to run a different macro (a macro that strips data and makes
graphs).  Ideally, I would like excel to prompt me to select a folder