i have folder that contain one new file each day. It's a text format file.
The naming format is as follow:
The folder is located at C:\dividend. And if today's date is jan 1 2008 then
the file is dividend.yester.Jan012008.txt. So the next day, the new file

I have one table to put in one scpreadsheet.
Because it has 3 different categories, for visual purpose, I put one empty
columns between them.
After I put empty columns to seperate them the auto filter dropdown box

Hmmm.  I have posted this two times now and they do not show up in this NG
(1-10+ hours past)!?  "Alpha Numeric Help" and "Alpha/Numeric help"???
I retrieve cell addresses and manipulate them to create ranges, I have run
into a problem when the cell address has double alpha ...

This a part from may UDF, my question if I want to put the same serial
number regardless the order eg.( "D10604" And rng <> "D11201" And rng <>
"D11202" And rng <> "D11203" And rng <> "D11204") I want to put in any order
there is any code to do that, because if I’m not put in ...

I need to be able to Select a number of different cells and copy them.
They are non sequential.
BUT
I need to select them relative to another cell.

yesterday I asked:
Hi, I'm trying to figure out how to accomplish somehting:
I have an add-in and I would like it to chek the computer's name when
installed, if the computer's name does not match the default registered

I am trying to enable a macro to take the string from a cell in an open
workbook called fxRM_update.xls whcih includes the path and filename of
another openworkbook.  Below is my attempt, but I get a "subscript out of
range" error.  An example of the string in the cell in the ...

Other than remove Key3 logic -
This will only be used by me.
Sub ExportCashValues()
   Dim Filename As String

I have created my own custom form that I need placed on sheet2 once the
submit button (form control) is pressed.  There are 8 fields that I need to
pass.  Any ideas?  Using Excel 07.
Thanks

I have a user form.  it loads a combo box , with a list of patients,
1 of the options is print a single sheet.  I don't know how to save
the selected value in a global and get that to the module from the
userform.  I tried a public global varible in the userform.  I tried

ich bin wohl nicht 100%ig hier richtig. Aber viel. könnt ihr mich dennoch in
die richtige Richtung bringen.
Ich programmiere einige Makros für Excel und habe eine Vergleichsabfrage.
Wenn mehrere Benutzer mit dem selben Nachnamen gefunden werden, sollen diese

In Excel 2007 I am trying to change the Fill color of a cell from a macro. I
am fairly adept with excel macros. So here is the problem with a simple
example.
Sub FormatResult()

I'm retrieving data from  Excel from my asp.net page
The WorkSheet name is StatusPasPorts.
When i remove the column [Account Reference No.]  it does work fine but if i
use it  i get error :

How can I know which Excel files in an directory and its sub-directories are
linked to myFile.xls (some specific Excel file).
Thanks.
Fabian

I am trying to wirte a sheet that will plot position vs time for two different time intervals, but I need to capture a value when it changes from interval 1 to interval 2. In the case below, I need to capture the 5, but it won't always be in that cell.
I'd really apprecitate any ...