I have data in following format in excel
IDATE       PNAME  STATUS  RL    SDATE       DIFF
13/08/2006  HOC      AT      Y    13/08/2006
13/08/2006  HOC      AG      Y    23/08/2006

I would like to copy a worksheet from FileA to FileB by using the listed
code, but it is strange that the result is just the opposite; it copies FileB
to FileA.  Could someone please help.
The codes are as follows:-

I want to move the range("A1:C8") in a working worksheet to another  excel
file by using VBA.  Could someone help.  Please show me the procedures.
Many Thanks

How can I have user form return a value when the form closes

I have this line of code.
Selection.AutoFilter Field:=Range("Note1").Column, Criteria1:="<=" &
Format(Now(), "dd/mm/yyyy")
I want to filter anything dated today or prior.

I have an userform with 60 textboxes (12 lines of 5) that which contents, if
non blank , I would like to place into a sheet in the same order and then be
able to keep doing it starting at the next available row.

I am running some macros that copies the current excel file to another
based on a certain condition.  I would like to also delete the VBA
code from the copied file.
Can anyone point me to the correct call?

I'm created a new Excel file on the fly and copying a specific
worksheet into that new file.  This part is fine, until I try to close
that new file (see last file of code) and get the error msg:
Run time error 9

This is one of those question where the answer is so obvious I cannot see it!!
The following is part of a larger macro:-
filedate=Range("F115".Value      'value is date in format dd/mm/yyyy
fileyear=Right(filedate,4)

Is there a way to get and set the content of a cell such that you also
get the formatting characters used?  For example, if I have the string
"Test this out" and I manually set "this" to bold (using ctrl-b with
"this" selected) is there a property that would return something like

I am working in analysis company and I need help in this regard
B1  Startup
B2  Excess Idle
B3  Excess Idle

I have the following Macros (Thanks to Joel in this forum who have been a
great help to this site!) for my spreadsheet to record my audit ratings for
10 different employees that I have listed in the drop down list.
Problem I have is that it will record 1 entry per employee. If I ...

I am working in analysis company and I need help in this regard
B1  Startup
B2  Excess Idle
B3  Excess Idle

Hi every1
I sure am in a need to package an excel application of mine and distribute
the same to my branch managers. However, I can't find any AddIn present in
the AddIns manager in VBA.

I inherited a macro that sorts in descending order (the first key, actually,
I am happy to eliminate the 2nd key if that helps), but seems to put any
blank entries (first key and 2nd key are either both blank or non-blank, I
think) at the top, whereas I would prefer they be ...