Hi, i have written this peace of code for my project. i have just
started to learn VBA. This code saves my file with the given name to
the correct folder and then the cursor is busy for 10 seconds and then
gives me that "recover my file and open again..." error and then the

hi everyone, it's me again buggin off with me little project that's driving
me insane.
this time is somthing i just like to call a nice feature in my  VBA based
app.

I am trying to paste search results into my 'Main' tab in an Excel
Book.  I perform the search ok but every time I try to paste results,
they end up all pasting in the same cell, thus overwriting one another.
Here is part of mu code:

I have created a List in Excel 2003.  Is it possible to bring up the Form for
the List (Data -> Form) programmatically?  I want to add a menu item for the
user to push to display the form for data entry into the List.
Thanks...

I'm trying to Auto-Filter in Excel 2007.  It's terrible! What did they do to
it?
In previous versions of excel, you would autofilter a column, then when
selecting the dropdown you just choose what you want to filter.  Now it

is there an easy way of disabling all shortcut combinations as well as all
the keys on the keyboard. I am aware of Application.interactive. I need the
user to be able to click various buttons on the worksheet as well as type
text and numbers in a userform. Apart from that, how do ...

I have a dropdown, let's say on row 4, and it's cell link is cell A4. When I
insert a row before row 4 (via macro), then the dropdown moves with all rows
one row below and is located now on row 5, as it's cell link (cell A5). The
thing is, that the cell link value does not move ...

I'm looking to change the background color of cells in my
multiplication table, if the value in the cell is a square root.
Following is a portion of the code that a responder here provided on
my original post.

Folks,
Is there some way to build with some combination of existing Excel 2003
functions the equivilent of a SUMIF command for two critreria.   My criteria
are Division and Statement Classification (e.g. Sum all Division 10 Sales

I've got a spreadsheet with multiple workbooks, and if I set a cell
worksheet1 to be purple, I need a corresponding cell on worksheet6 to
also turn purple, and vice versa. Is there any way to automate this?
Manual colorchanging across multiple worksheets is tedious,

I need this Auto_Open() macro to open the document listed and it works fine,
my problem is that :
1.   I do not want it to become the active document
2.   The name of the document running this routine can change. Otherwise I

with the help de Ron code, i try tou send 1 ou more file ".pdf" to one or
more people but i have a problem if i try to send 2 files in the same mail:
my 2 files are: tutu.pdf and toto.pdf and more ...
Before the change of my For/next, i send in 2 or more separate mails for the

I have a problem where I've recorded many macros within a workbook and
I am trying to consolidate them so the workbook wont be so large and
have so many macros.
Instead of doing it this way:

To all,
I  have a set of part numbers:
FX1999
FX2000

was wondering if someone could give me the syntax to load this into a listbox
with 5 columns
these are the values i find and want to put them on 1 row of a listbox fill the
listbox with as many rows as the find returns: