How can I overwrite an existing file with the same name with the procedure
SaveAs in Visual Basic for Applications without the program asking me for
overwriting ("Yes, No, Annuleren").
Thanks

I have set up a number of combo boxes and am running some _change macros
from them (see code below)
Private Sub Q2_Combo_Change()
Application.EnableEvents = False

This may sound easy, and I thought it would be easy, but after som thought I
realize that what I'm trying to do probably requires a bit of hard-thinking.
I have got a table that I exported from my database (Access) and it has 3
columns (call this list1)

Hello from Poland!
I am building a module with VBA, where sub's names are defined in
worksheet's cells. I need to determine if a string entered into cell can be
a proper VBA function name. I don't want to iterate and check each character

In Excel 2003 it was easy to record a macro to modify the properties of a
picture.
It was enought to push "Record Macro" button, and execute all steps we
wanted the macro would do later.

Excel XP and Win XP
   I have used code furnished by Chip Pearson to copy a module from one
file to another.  I believe, maybe I'm wrong, that this code deals with
regular modules only.  My question now is:  Can this be done with a sheet or

I'm trying to make a nice user interface on one worksheet.  When I access
cells in other worksheets using select or activate, the view automatically
switches to the other worksheet.  Is there any way for me to get the values
in cells on other sheets, but keep the view on my one ...

I have been looking every where for answers, still learning!!
I have numbers in column A and need to lookup a certain value, from a
userform the number that needs to be looked up should be entered in textbox1
and on the same userform another number is entered in textbox2. When

Excel XP & Win XP
I got some code from VBAExpress.com to create a floating toolbar on file
opening and it works well.
My problem is that the sheet that is on the screen is a busy sheet and the

I'd like my wb on opening to close all other excel files that are open
(prompting them to save first).
I'd also like to prevent the user opening any other excel files whilst
my wb is open.

I have added check boxes to an Excel 2003 spread sheet. I used the Forms
Toolbar. There is an existing Clear button that clears selected cells. I want
to modify the Clear button macro so that the check boxes are cleared also. I
tried to use the code from a previous post (Kyla ...

I need to test my application om different versions of Office. Is
there some way to download a trial version of Office xp (2002)
version?
Thanks

I need code that will prompt the user (via browse window) to choose a file.  
I then want to import the contents of the specified file into a sheet.  The
files will all be text files, but do not have a .txt extension.  I don't want
the user to have to Data->Import External Data

I really feel stupid on this one, but it's 4am here, so maybe you'll cut me
some slack.
Code:
   Dim CrntA As String

I have a workbook that has upwards of 50 worksheets. Is there a simple way
of generating a list of those worksheets names?  I don't fancy having to do
it manually?
TIA