-
Excel question
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.
-
Re: Excel question
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
-
Re: Excel question
It works great!
Thanks a lot.
Jaime.