When I passed a date value from Recordset to Excel cell
cell , when the date is 1899/1/1
The VBA complains " Applicaiton Object defined error".
             The code is as follows

I need to run a macro based on whether cell P7 in a worksheet contains
value 1, 2 or 3.
If cell contains value 1, would automatically run Macro1, if 2 would
run Macro2, and if 3 then run Macro3.

I have 3 variables: a 'real' rate named Rreal in cell D4, a
'nominal' rate named Rnominal in cell D7, and an inflation rate
named Inflation in cell J7.
The relationship between these variables should be as follows:

I need code to go to the first cell of the given row I am in, without knowing
how many columns over I am when I run the macro.  In other words, a user is
going to be told to place their cursor on a line, and then run a macro.  The
macro will rely on getting to the beginning of ...

how do I call a procedure from within another procedure?
Let's say the procedure I need to call is TestProc.

I have a textbox on a userform which in the properties has seleted WordWrap
as True however when you run the userform and a user keycs into the box the
text doesn't wrap.
Any idea's as to how to get the word to wrap and go to the next line so the

    I am a beginner for Visual C++ and want to ask how can I get the value
of text box in Excel thru Automation. Could anyone help me please?
Thanks
hoyauwong

I've got a .net windows service that generate rather large excel files with
mounds of data. Lately the code has begyn to generate -2147417851 (80010105)
"The server threw an exception" exceptions for no apparent reasons.
The exception occurs when I set a range's value to a two ...

Dim oCell As Excel.Range
Dim oSheet As Excel.Worksheet
Set oSheet = ActiveSheet
With Worksheets("MySheet")

I have one that's way out of my league:
I would like to first make a user form that activates when shortcut (ctrl+x)
is used on a cell.  This would then allow the user to fill in the data for
name, CC#, Exp date, the date the data was entered, phone #, TOA (time and

How do I design a macro to find the last record in a report and delete each
row after.  Keeping in mind that the cell reference can change to where the
last record is found??? Help please!!!

I've been fiddling with VBA again, and seem to have come unstuck.
I work at a cabinetmakers, and I'm writing a macro to export a list of
parts to a program that talks to our saw. The program uses a CSV file
to read in all the sizes, descriptions etc etc.

I need to be able to supply a product code on one worksheet, then go to
another sheet to do a lookup which will tell me how many cells to the right
of the looked up value to select and bring back to the cell below the code in
the first worksheet. Basically, based on a product ...

i have a list of data and i will like to create graphs for a particular
person when needed.here is the format of my raw data.
Dept    Country    Name      Jan     Feb   Mar
1         sg           john         50     25     55

I've got a function that identifies certain ranges that have formulas
in them and them fills them down to a certain level.  Right now, I'm
getting really poor performance since I'm doing something like this:
    For each rng in rngList