Does anyone know how to copy an excel worksheet
to another workbook using VC++ 6?
Thanks,
MJ

I have a pivot table that contains a list off part numbers (starts A3 going
down) , the current qty in stock (start B3 going down), the the week no due
(starts c2 going left to right) and then the qty req in the corresponding
area. I also have the current week number in IR4

I've got the following to define a value on another worksheet and it works.
Sheets(Summary.Name).Cells(Sheets(Summary.Name).Cells(Rows.Count,
"A").End(xlUp).Row + 1, 1).Value = Target.Offset(0, 6 - Target.Column).Value
What I want to do is select a range including this cell up to ...

I have a spreadsheet with a MsgBox and an Ok button that takes a long
time to clear off the screen after the Ok button has been selected. In
fact another MsgBox appears over it. Is there anyway I can control the
speed with which the msgbox clears from the screen after the Ok button

How do I search the columns for a specific column name so I can
reference that column number in future code?
for ex:
happy sad mad laugh

This was posted yesterday, with an unclear subject line. Sorry.
Hopefully, this subject line will draw some helpful suggestions.
========================================
Both# 1 and # 2, below, were made by doing an actual live macro recording.

I would appreciate help with this one:
What code do I need to place in "Workbook Open" so that after 10
minutes of no activity, the file is automatically saved and closed.
TIA

I am working on a routine to send information from excel to a users
quickbooks company file. If the user has created a formula to calculate
the value of a cell when the import routine sends it to quickbooks it
sends the formula instead of the result of the formula. The line of

In Excel .5 is always rounded up when the decimal places are reduced,
ie. 3.55 becomes 3.6, 3.65 becomes 3.7 etc. I need a formula that will
"throw .5 to the odd" so that 3.55 would become 3.5, 3.65 would become
3.7 etc. I would appreciate any help on this.

A silly question perhaps.
I am a student and my worst nightmare is the syntax of VB. I would like to
be able to use C syntax in Excel functions and macro programming.
Is there any speculation that Microsoft may replace VBA by C# in the near

I was thinking of retrieving the time at the beginning of the macro, eg
in 10:31:02 converted to seconds (=37802 or sth) and then the time of
"seconds" at the end. Then subtract it and voila - convert it to
minutes and seconds (the macro runs for about 2-5 mins.

I attached a label control in a worksheet.
I change the caption of label by vba. This is my code:
sub refreshLabel()
With Activesheet

I need to save a worksheet to Adobe Writer as a PDF file format, has anybody
done this in VBA code if so I would appreciate any help given.
TIA
Charles

Could someone please enlighten me as to why I get a runtime error from this
line of code. It was generated by Excel 2003 itself using the 'record macro'
command from the 'tools menu'.  I selected 'record', then the rectangle shape
from the drawing tools menu, then dragged my ...

I DO NOT UNDERSTAND ANY OF THE FOLLOWING...PLEASE ILLUSTRATE EXAMPLES, USING,
eg. THE =IF(......) FUNCTION THE USE OF:
?
*