I think you will need to browse for a file, store the file name in a
variable, and use the variable in some code that imports.

There is some code from Ken Getz to browse for files, with filetype filter
he It is for Access but remove Option Compare Database and it should
work.

http://www.hammerdata.com/Newsgrp/1.html

"Al@n" <al@n@g@wsi wrote in message
...
Please

I am trying to code the showing/opening of the Excel built-in dialog box
for
importing external data. I can code importing the data from a specific
location on a C:\ drive, however the user may need to access other data
than
that coded as a default.

Is what I require possible....and if so......how?
(I'm using Office 2000)
Any assistance will be greatly appreciated.

Cheers

Al@n