import text file
To open a text file:
ChDrive "c"
ChDir "c:\Mydata"
fileToOpen = Application.GetOpenFilename(filefilter:="Text Files
(*.txt),*.txt")
Workbooks.Open FiletoOpen
--
Regards,
Tom Ogilvy
"Lynn" wrote in message
oups.com...
hi,
i have a macro as follows
ChDrive "c"
ChDir "c:\Mydata"
fileToOpen = Application.GetOpenFilename(filefilter:="Text Files
(*.txt),*.txt")
how can i use the above to import a text file ?
|