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

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

William

Thanks for the lead. I have found some info on xlDialogExternalData, however
cannot find any detail on ot's application.

Thanks again


--
Al@n
"William Benson" wrote in message
...
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

Al@n
I am trying to initiate the Import External Data Wizard using code. Were you
able to get this to work? If so, how? I can't find any information on
xlDialogExternalData. I'm using Excel 2003.



"Al@n" wrote:

William

Thanks for the lead. I have found some info on xlDialogExternalData, however
cannot find any detail on ot's application.

Thanks again


--
Al@n
"William Benson" wrote in message
...
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