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.
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 !
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top