Need to shorten this to add a few more possibilities at the moment it will
only handle "EI" and "EW" but I need it to handle 3 or four more. Was
thinking a table of some sort based on the piece of the lookup cell I want to
look at but have no real idea of where to start

Hello - I need some code that will open a windows exporer window with an FTP
session started.  I would like for the FTP folders to be in the explore pane
and the contents of a local folder (I:\) to be in the contents pane.
I have found documentation to shell a windows exporer ...

We have general office workers in our school district who use an
antiquated student information system to download roster information in
text format for import into Excel. A user recently asked me if there is
a way to globally change the outputted date format 20011028 to 10282001

I open a lot of Comma limited files in Excel using the “Text Import Wizard”.
I need a hack that will pre-set some of the selections in three Wizard steps.
In Step 1, I want to default to “Delimited”. In Step 2, Default to “Comma”,
and in Step 3 I want the “Date” format to ...

How can I assign the defined name of a cell (the name assigned manuall
by Insert-->Name-->Define) to a variable in VBA
--
jsw4

Here is my spreadsheet
     369   Medical Authorization/Utilization
     370  Apportionment
     370  Settlement

In an add-in I have created, a custom menu item is created, it is
disabled at the end of the macro that created it with:
CommandBars(1).Controls("blah blah").Enabled = False
I did this because not all workbooks should be able to use it.  The

I have some pretty simple code that is trying to move the "value" from
one range to another.....each range happens to be a single cell. Each
cell has been formatted in the worksheets to be number format
$#,##0.000000 (i.e. six decimals - yes I am dealing with fractions of a

I am having an issue with figuring out how to close a workbook. I know
how to close a workbook when the filename is constant/known but not
when it is dynamic. The scenario is that my Main macro reads in a text
file causing a temporary workbook to be created. It then copies data

I have a macro that does a bunch of stuff, but before it does that
stuff I want it to format a column which holds a date value, I want it
to format the columns cells so that the date format is m/d/yyyy h:mm
Does any one know how I would go about this?

First question,
Is there any way to get a listing of system and/or user data sources
from a VBA app?
Second question,

Is there something like GetOpenFileName that would open a dialog box
and allow me to browse to a folder and pick it as the new Current
Directory?
I can use GetOpenFileName and pick a file in the correct directory and

Hi i am not very good at excel and was hoping somone here could help me.
I am making a league table and it has 4 sheets (League, Next matches,
Profile's, Admin) What i would like to do is to go on to the "Admin"
section and have some options such as new player, results. I would like

I have 2 excel sheets
username sheet
---------------
it contains just usernames in one column

Is it possible to group sheets ending with a certain name and move them
to a new workbook in my documents named by the name i am grouping by?
Lets say i have 20 sheets each named "**** Today" where **** is a
variable, is it possible in VBA to group all the sheets with name