I have a file that imports data from .xml's and .csv files.  If button
1 is pressed, I only want to look for .csv and .xls files, if button 2
is pushed, in only want to look for .xml files. I am using the
following code when 1 is pressed

I have tried the macros from John Walkenbach and others and they work fine
as long as the Excel file is not password protected.
Is it possible to specify the password as the connection get oppened?
' **************************************************

What VB script is needed to, say, change the colour of a control button  say
from gray to red when it is clicked.
I've tried using the scripts given in:
http://www.mrexcel.com/archive/Controls/5034.html

I have a 6 comboboxes(control toolbox) on a worksheet. All of these
boxes have a KeyDown event associated with them used to navigate
around the sheet with the TAB and ENTER keys. 4 of them also have a
LostFocus event. When I navigate from one particular

Hi All. I want to backup a file when it opens. I've seen threads that tell
how to backup on close, but not on open. The problem I'm having is that when
I "FileSaveAs" the SaveAs workbook becomes the active workbook. After I
SaveAs I want to close the SaveAs and re-activate the ...

Currently I have an IF statement determining if a cell is populated. I would
like to provide formatting to that cell if it is populated. Can anyone help
figure out how to do both.
Here is the current If statement:

Would anyone have some idea why this don't work - please ?
Private Sub App_WorkbookBeforePrint(ByVal Wb As Workbook, Cancel As Boolean)
   For Each wk In Wb.Worksheets
       If wk.Name = "DATA - ALL" Then

Hi,
this should be fairly easy. I'd like a macro that copies a function (any
function for example a vlookup() function) down in a list. So lets say I have
a list of data and I insert a column (column A), then i put a function (or

I have VBA code that uses a list of tasks from one sheet to populate a
calendar type view on another sheet.  Each calendar day (cell) shows that
corresponding tasks for that date, each separated by a CR/LF.  For example,
one cell may have 5 lines representing a mix of open and ...

I preparing a French revision spreadsheet and trying to set up the
following, without much success.
In ColA I have English sentences.  In Col B I have the correct French
translation of these sentences. (The sentences vary in length)

This is the code I'm working with.  Cell A4 will contain text (cells
formatted to text), January 2007 for example.  I'd like that to appear on the
footer.  It inserts it but formats it as 1/1/2007.  I'd like it to just have
the whole month and year.  Thanks

Been racking my brain for a long time, now trying to find some guidence...
                           A                    B                    C      
             D
1                        Date               Score              Name          

Is there a way how to disable (e.g.) Delete button on Data Form calling by
ActiveSheet.ShowDataForm ?
Thanks for answer in advance !
Vlado

I get the error - Run-time error '1004': Select method of Sheets class
failed
When I go to debug I get 1st and 2nd line highlighted in yellow
Sheets(Array(" Summary", "Transaction Register", "Investrep",