excel 2000 and fixed width text file. text file contains over 1000 records


"Tom Ogilvy" wrote in message
...
what kind of file is the data stored in?

--
Regards,
Tom Ogilvy


Mike wrote in message
news:jvyQb.109927$Rc4.780708@attbi_s54...
Is there a site with sample code? This is a combo box on the worksheet,
not
a userform.


"Bob Phillips" wrote in message
...
Mike,

Open the file
Either copy the data to the combobox file and point the combobox at
that
data, or add them to the combobox
Close the file

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mike" wrote in message
news:g%mQb.7451$U%5.52032@attbi_s03...
What is the best way to fill a combo box when the data is stored in
an
external file?