Excel VBA - Importing Text File to Excel using VB

  • Thread starter Thread starter annsmjarm
  • Start date Start date
A

annsmjarm

Hi,
How to import text file to Excel worksheet using VB? Can I use a for
menu to execute this process? Please give me some ideas of doing it.
have attached a text file for your reference.
Thanks!
AN
 
How to import text file to Excel worksheet using VB?

Record a macro as you do it manually with File, Open. Pick the appropriate
file type from the drop down. That will give you a good start.

form menu? No such thing.

--
Jim Rech
Excel MVP
| Hi,
| How to import text file to Excel worksheet using VB? Can I use a form
| menu to execute this process? Please give me some ideas of doing it. I
| have attached a text file for your reference.
| Thanks!
| ANN
|
|
| ---
| Message posted
|
 
Back
Top