I'm having problems coming up with a macro that will allow me to
import a text file of choice from my default file location that I have
set up with Excel which contains several text files.  I want the macro
to open a "Open" file dialog window where I can then choose the text

(office 2000 version)
In which way can I paste Pics in a cell, I've already
tried to copy, paste/ but they are not locked in the Cell.
Even have I tried to Lock the cell, When I give the (cell)

I have datafiles in text format (Notepad) that have one
field per row and a pipe delimeter (|) after each record.
I want to import this data into Excel but it doesn't
recognize a carriage return as a delimiter.

Does anyone know how I can highlight the last selection of a list box when
the form initializes?
I made a 4 item listbox with a For Next (i) loop that reads the items from a
range in  Sheet2.

I need a help on data extracting...
I have a data abt 12 col and 40 rows with header in each col.
the header like --- Inv no, Inv Dt, Customer Name, amount, chq no, Ch
date etc....

Is it there a formula, that if you click on a Cell,
   you automatically go to another Cell in that worksheet?
(without using a macro?)
Ruud

Out of the blue today when I try to run Excel for Office97, I got
"Required file MSO97.dll missing".
So I looked at the PATH and copied MSO97.dll to a place in the path -
"C:\windows\".

I create a list box inside a column. It works ok.
However, the arrow appears at the next column, not inside
the main column.
Ex: list of text, which I can choose from, at F column,

I am doing a mail merge using number fields from an excel pread sheet.  How
can I format them like currency i.e. $1,287.22.  Can the execl format be
passed to word?
Can this be done or must I use the field edit and use the \# switch ?

I want to insert watermark COPY on filed invoices

I have cells that are linked to other spreadsheets. These other
spreadsheets have values to 7 or 8 decimal places.
Can anyone tell me how I can import to my cells and only go to 2 decimal
places?

I need to cound the number of entries in a cell that contain a file nam
that starts with BE.  All of the names in the cells start with BE an
then contain file specific information ie date and time.  Was thinkin
of using CountIf but unsure how to limit the criteria so that cell

Ok, I have a spreadsheet with multiple columns, for example:
Date |       spanning header1     |        spanner header2     |
spanning header3      | Average   header      |
       |  subhead1a | subhead1b |  subhead2a | subhead2b |  subhead3a |

I have a spreadsheet which contains employee information including job
skills. My problem is that each skill (cook,candlemaker, etc.)creates a new
row for that employee, duplicating fields that don't change, name, ss#,etc
with the only new info in the row being the skill

Any advice?  CTRL+PAGE UP and CTRL+PAGE DOWN don?t move me from on
worksheet to another on my computer.  I?ve searched the ExcelTip.co
forums for solutions already given for this problem and haven?t found
solution that works on my machine yet.