Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
import text file
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 ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I import text file of cash flow to excel file then use formula | Excel Discussion (Misc queries) | |||
Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
How do I import text file, analyze data, export results, open next file | Excel Programming | |||
Import text file into excel with preset file layout, delimeters VBA | Excel Programming | |||
Get External Data, Import Text File, File name problem | Excel Programming |