I have a workbook with all worksheets protected, located on a network.  When
the user closes, Excel puts up a message, “Do you want to save…”  giving the
user the option to save.  I do not want the user to have this option.  How do
I do this?  Below is existing Auto_Close()

I am a loan officer. Every week my boss gives me 80 to 100 or so name
and numbers to call. I put them in excel. What I want to do is create
sheet that next to each name is a sort of an up down button. If I pus
it up it add a number. Down takes away a number. This will show ho

i am trying to use this macro for delete from my data every second ROW , but
couldn't use there is some error plz help me.
thanks in advance.
Sub abc()

I am writing Excel automation using Visual basic 6.
The application is supposed to read the excel file created by the
Office 2003 version.  I also have Office 2003 on my machine so I set my
reference to "Microsoft Excel 11.0 Object Library"

I want to open a file which has a filename ABC followed by anything. I
thought this should have worked, but it is not.
Set Wkb2 = Workbooks.Open(Filename:=foldername & "\ABC*")
Can someone please correct it? Thanks in advance

I have made an Excel-VBA Project using a User Form with the DTPicker
Control.
Unfortunately this program does not work on the machines of the persons
who have to work with this program.

I have a userform that allows a person to type info into some textboxes and
then they can press a button and enter the data onto a worksheet.  I want to
be able to check a column for one of the numbers entered to make sure there
are no duplicates.  If they try to enter the same ...

I need to try to open a text file that is 500 bytes per record, that is each
record is a dump from a mainframe and is 500 spaces long with no delimiters.
I know where each position of data will be, for instance in position 30 thru
34 is the zip code, 35 thru 38 is the 4 zip code ...

For the code below, I get an error the first time through but after that it
then runs without error:
Sub GetWFiles(Wpath As String, WhichWfile As Integer)
Dim  qt As QueryTable, Wdat As String

I am trying to select cells in a row that are not contiguous. Example
in row 15 i want select C, E, J, I, and K. I used the record macro
function to get
Range("C15,E15,G15,I15,K15").Select

I use the German IDE, but it should be similar:
(will try to translate)
Default is "Search in -> active Module"
Most of the time I need  / (one needs)  to search in -> active project

Hi all i have some code below that opens Word adds a document and pastes
the contents of a range in to it, my problem is that i would like the
contents to be pasted on the right hand side if the document, thats
what the vbTab's are for below but it doesnt work it just hangs after

I need to my macro to be able to Find certain words and delete the rows
wherever these words occur.
If I use the Cells.Find(????) to locate the words, the macro doesn't
work ifthe word to find isn't in the spreadsheet.

You can't call this function as a procedure because it comes back wit
'argument not optional'.
I've managed to place it in module1, I'm deleting the code above i
using:

I am trying to programatically loop through all of the programs currently
open in windows and get a hook to it. I can look through the explorer windows
but can't seem to find things like media player or the like. Any suggestions?