ANOTHER IMPORT TXT ?

[kmorgan2004]

NEED SOME HELP.

I AM MAKING A COST ESTIMATE ON DIFFERENT ROADS IN MY CITY. I HAVE A TEMPELE EXCEL FILE THAT I HAS A MACRO IN IT TO CALCULATE THE COST FOR REPAIRS. HOWEVER I NEED TO COPY IN THE GIS DATA FOR THE ROAD I AM EVALUATING (TXT FILE) INTO MY SHEET CALLED DATA.


I AM TRYING TO COPY IN A TXT FILE INTO A SHEET CALLED DATA IN A FILE CALLED 12THAVECOST.XLS NEXT TIME IT COULD BE CALLED CANALSTREETCOST.XLS

THE PROBLEM:
I NEED TO BE ABLE TO COPY IN DIFFERENT TXT FILES DEPENDING ON WHICH ROAD I AM DOING COST ESTIMATE ON AND SOMETIMES THE TXT FILE DOES NOT MATCH THE FILENAME FOR THE .XLS. SO I NEED TO BE ABLE TO BROWSE AND CLICK ON THE FILE TO COPY INTO THE DATA SHEET.

THANKS

 

[gedi]

Why not just use Data -- Import External Data -- Import Data from the menu, and Select All Files for Files of Type

 

[kmorgan2004]

I COULD BUT I WANTED A WAY THAT THE MACRO WOULD LOOK IN A LOCATION, WHERE ALL I HAD TO DO I CLICK ON THE FILE TO IMPORT

THANKS FOR THE REPLY