View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Import Text file

After you get the file's name with GetOpenFilename use the OpenText method
to open it.

--
Jim Rech
Excel MVP
"Robert Christie" wrote in message
...
| Hi
|
| I'm trying to couple "GetOpenFilname" with "Import" Text file wizard.
| i.e.
| Open a folder, select a text file, and import into an ActiveSheet in tab
| delimited form, Treating consecutive delimiters as one.
|
| --
| Thank you
|
| Regards
| Aussie Bob C.
| Using Windows XP Home + Office 2003 Pro