Is it possible to automate the importing of exporting text data?

M

MonitorOntario

Is it possible to automate the importing of exporting text data? I hav
huge files of text data that I wish to import into Excel. The task o
setting columns and declining certain columns of data is daunting an
is repeated from file to file.
I'd like to save time by automating the process from file to file
rather than doing the same tasks for each
 
H

Harlan Grove

MonitorOntario said:
Is it possible to automate the importing of exporting text data? I have
huge files of text data that I wish to import into Excel. The task of
setting columns and declining certain columns of data is daunting and
is repeated from file to file.
I'd like to save time by automating the process from file to file,
rather than doing the same tasks for each.
Click to expand...

You'd need to use VBA, but the bulk of the coding could be done by the Macro
Recorder. Turn on macro recording *just* *before* the next time you specify
how to import these files.
 
Top