Anyone can teach me how I can trigger e.g. SpreadSheet A -> Module B ->
Function C from Windows Command Line ? Is there such an
option/partameter ?

The routine below is used to import the contents of several files and paste
those contents into a worksheet. All worked fine until the source files
changed from tab delimited to CSV (nothing I can do about the change).
I changed two lines of code to recognize .csv file instead of ...

I found this Progress Bar on this board here, and would like to incorporate
it into my current code, but can't figure out how to do it.  I am thinking
the Max value would have to be LastRow.
Any help is greatly appriciated

I have a lot of Excel (Microsoft office XP) files that are all linked to a
main source document.  I need to open that source document each time I open
one of the files so they can update.  I hide the source document when it
opens.  I have a functional code in VBA, but I am not ...

I have read that windows can be configured to always automatically
unload all inactive DLL's from memory, using the command prompt. Is
there a way to unload all inactive DLL's from memory for the current
session only in Windows 2000?

Hi I have a maro w/ a named range from which I  need to select 2 Nonadjacent
rows based on variables but can't seem to get the code right.  I need to
select row$1, col_x and row_y, col_x of named_rng_z.  
any help w/ the syntax would be appriciated

In Properties set limit Scroll area, Save, Reopen, Properties goes into
default.
Is there any code to set it, at open etc.
Thank you

Hello all. I have been searching high and low and have not found what I
am desperatly looking for. I can find a ton of info on how to add menus
but I will be honest and say I am completely lost. Is there a site that
dumbs it down so i can work with it?

When using built-in functions in excel, the formula palette displays a
description for each of the functions arguments. I would like to create such
a description for my custom functions, is there a way of doing so? (I know
how to provide a FUNCTION description...)

i have a list of data and column I contain name. i want to cut records that
contains certain name and paste it after all the rest of the data on the same
worksheet.how can i do that??

H!!
Is it possible to name the below code extract and recall it by the name?
Rows("5:5").Select
   Selection.Insert Shift:=xlDown

I need to get a UDF to sometimes return its existing value rather than
recalc.  I am happy for the function to be called but need some way of 1)
bypassing the full calc - (clearly trivial) and then 2) returning the value
that was already there before the calculation attempt (much ...

I used this code I found on MrExcel.com however, if my Excel
spreadsheet has a null value in the field, it stops.  Can someone
assist in modifying the code below to account for a null value in a
field?

Hi, I am just basically sorting through a huge dataset and grabbing unique
codes and storing them in an array for later use.  Some of the codes are
numeric and some are alphanumeric therefore I am storing them as strings.
However, when a code is for example 000578 - once a recall ...

What I am trying to do is use the data entered in one inputbox with the data
entered from a 2nd input box.  I an trying to make a macro so that the user
can make consecutively numbered labels with the push of a button, so the
button would bring up the 1st inputbox asking what ...