I need to code in Excel the keystrokes to do a File, SendTo, MailRecipient
and not as an attachment; I want to worksheet to be pasted into the message,
the first choice on the SendTo line.
Thanks!

When I add a workbook I get only 1 sheet, not sure why it's not 3, but
nonetheless there's the 1.  I use the Item( 1 ) method to get the pointer of
the worksheet.  I store it for future use.  If I add a worksheet, I store the
pointer as well.  All is fine.  Item, Index, Name both ...

I have this within my code:
       Set oWB = Workbooks.Open(Cells(i, "B"), ReadOnly = True, UpdateLinks
= False)
It works fine when I have something like Y:\workbook.xls, but I'm not sure

I have an external C.xls (in XLSTART folder) with a macro to run.
When I open FileA.xls, I want to be able to copy all worksheets from
FileA.xls to FileB.xls with the macro in FileC.xls.
Any pointers?

I have about 50 read only workbooks and I want to find the row number where
the following condition matches:
Value in column A = "VAL A"
Value in column B = "VAL B"

Using a dual processor machine running windows 2000 using excel 2000, I run a
vba script that takes a while to complete.  The task was taking exceptionally
long to complete, so I looked at the task manager to see how much CPU power
excel was using.

I have a function in a spreadsheet defined in Visual Basic. Is there a way
to get cells containg this function to be recalculated after data has been
changed? It doesn't happen automatically and F9 has no effect. So far, the
only way I can find to get the correct value calculated ...

I'm trying to tell good 'ole Excel to start at B3, then go down the
column and find the next row with the value of "Address" in column B
WITH an empty cell next to it in Column C.  In other words, I've got a
data entry userform, and I'm trying to located the next empty form

i have a file with many sheets, all protected. i want select cells in
one protected sheet, go to another protected sheet, select a cell, then
havea a macro unprotect the sheet, paste the cells, then protect the
sheet again.

i want create loop for the below.
I have excel sheets contain  data as below
HW  INF
              text39:    50

I'm creating a FORM in EXCEL. In the form, the user will select a drop down
list of 4 items, "Screen 1, Screen 2, Screen 3, Screen 4". When the select
which screen they want, I need to create a data entry field for them with
restrictions on the number of lines and characters per ...

I have several VB modules that I have tried importing into an XP/Office
2003 environment, but can't get them to stay.  In my old 98/Office 98
environment, the modules were always there, when I opened a new file
(PERSONAL.XLS), or any other file.

I want each cell right to a cell containing "I" in the column B to be
filled with a pattern. What's missing?
(The call of the pattern is also wrong...)
Dim cell As Range

I'm trying to use FOR - NEXT to cycle through the Range B:B or even
better go to the last row (which I don't know how to do successfully -
it always stops short a few rows). I would like to find each cell that
has an "X" and then lock that row or if no "X" leave it unlock.

I have a file that I need to copy the cells in the current print area so
I can paste them to another sheet. Is there a way to do this in vba?