importing text file into excel file using macro

  • Thread starter Thread starter annsmjarm
  • Start date Start date
Hi,
How to import text file into excel file using Macro? Can this process
run on form menu button? Please help and give me some ideas of doing
it. I have attached a text file for your reference.
Click to expand...
You can easily import text file into excel using macro by
first start recording a macro, then setting a IMPORT
EXTERNAL DATE option from the DATA menu. Then you find the
file you wanna import, you put the forms you want in it (
like FIXED WIDTH and colomn separation and remember that
the macro will only ask you which file you wanna import
and not the set up again, so you might wanna set it up
right the first time )and then you click finish and if
you'd like the macro to perform some other action (like
putting in the columns name or format) just continue with
the macro then press stop. As easy as that !
 
Back
Top