Excel question

[jaimelopez]

Hi!
I have an excel file in which I have defined a few fields with a name (f.e. the cell A1 is called TEST).
I open this file with Excel.aplication object. Normally I would refer to A1 cell in the file like this:

xlBook.Worksheets.Application.Cells(1,1)

does anybody knows how can I refer to my cell TEST without using A1 (in this case)?
Thanks in advance.
Jaime.

[Cakkie]

You can refference it using the range object
xlBook.Worksheets.Application.Range("TEST")

Tom Cannaerts
[email protected]

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook

[jaimelopez]

It works great!
Thanks a lot.
Jaime.