I have a macro that deactivates the paste function in excel.
The re-activation of the paste function occurs before the file is
close (beforeclose), see below.
I have applied this to multiple workbooks, but I noticed that when I

Please help me out with this. I have a worksheet that needs to be
uploaded into an IBM AS/400 system. Cells that will be uploaded are
marked with yes to tell the AS/400 to accept this data. Once
uploaded,

I've got 30+ .xls files in a folder (eg: E:\Max\Excel) that I would like to
protect, ie Lock vbaproject for viewing using a common password, eg:
vbapaswrd. Is there a sub which can do this? Thanks.

I have an Access database (MIP_MCC_Review.mdb) with two tables (MCC and MIP)
that contain data submitted by users using forms of the same names. I have a
query that I built in Excel Microsoft Query that will get specific data
(rows) from the tables in Access and import that data ...

I'm using the bit of code to save my workbook base on the value in a
cell.
ActiveWorkbook.SaveAs FileName:=FiName
But it always savse in the my doc folder. Can I force it to save in

I'm currently using the following code:
   Dim lastRow9 As Long
   lastRow9 = Worksheets("Working Sheet").Cells(Rows.Count,
"B").End(xlUp).Row

I have a problem with the code below.
I cant understand why Im not allowed to pass on the frame object for
later use in the code.
I am using this because I have several comboboxes in different frames

I have read lots of good info in the NG on how to import CSV files
into current workbook, worksheet etc. With these methods, if I import
5 files for example, I'll end up with 5+1=6 sheets, the 5 imported
files plus the original sheet.

I am trying to rank a list of 10 numbers and I know how to rank using
the RANK function. I have a problem though. When there are two (or
more) values that are the same, i want them to show .5 instead of
multiple 4s. i.e.

I have a list of contracts with daily volumes and dates which start and end
at various points over months/years organized in rows. Next to the this I
have columns for every calendar month moving years into the future. What I
need to do is have a formula to return the average ...

I have this code that someone helped me with and it works great except the
message "The selection contains multiple data values. Merging into one celll
will keep the upper left most data only" message. I have to answer "OK" in
order for the code to continue to loop. Does anyone know ...

Is it possible to expand the NameBox in Excel 2003?
I have some programmatic names on a worksheet that are too long to be seen,
the only way to see what they are is to select them and put the cursor in the
NameBox and select to the end.

is there a way to enter a function in a cell to run a macro?
Thanks

Hi, I'm looking for a solution for the following problem:
I have data in more or less the following form:
    A           B
1/1/08    Alex

I want to basically create a macro that takes the final information entered
from the main workbook and then insert them or Append to the workbook. Just
like if you would go into an Excel Workbook and it would ask you to Update,
probably from the internet or from a database, I ...