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
|
 

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

Similar Threads

How to import text file into excel file using VB 1
importing text file into excel file using macro 1
Import 4 Different Excel Files from One Folder 0
Browse button for access form 1
Excel VBA - Problem with Closing Print Preview 0
Excel How to Fix Damaged Excel File That Won't Open? 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Word to Excel: Export comments with text and line number 0

Back
Top