View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Monte0682 Monte0682 is offline
external usenet poster
 
Posts: 15
Default how to return a file name

hello,

my question was:

I have a workbook. I would like to import a text file into one of the
worksheets...When I go Data, get external data, import text file... To
do this I use Application.Dialogs(xlDialogImportTextFile).Show

This will import a file, ask for a delimiter...

But I would like to export a file name that a opened for later
reference... Also I would like to specify into which worksheet I would
like to import...