What version of Excel? Is MS Query installed on your system (you know
for a fact)?
For Excel 2003:
Data Import External Data Import Data...
File Type can be either "All Data Sources" or "Excel Files". Navigate
to Excel file, select it, click Open, and it should come up. Make sure
file is not protected. I just tried a test workbook that I protected
and that buggered the process up.
--
Air_Cooled_Nut
------------------------------------------------------------------------
Air_Cooled_Nut's Profile:
http://www.excelforum.com/member.php...o&userid=15730
View this thread:
http://www.excelforum.com/showthread...hreadid=560902