How to import text file into excel file using VB

A

annsmjarm

Hi,
How do I create a form with import button in excel file? The impor
button can perform the function of import the text file into
worksheet. Please give me some ideas of doing it.
I have attached a text file for your reference.

Thanks !
Ann :

Attachment filename: rdata.txt
Download attachment: http://www.excelforum.com/attachment.php?postid=66226
 
D

Dave Peterson

How about recording a macro when you do it manually the first time.

Post back with followup questions.
 

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

importing text file into excel file using macro 1
importing cvs file!! 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Word macro that can call cells out of Excel for a find and replace 0
Complicated Match Formula with conditions 2
Look UP and then caluclation with IS ERROR 3
Formual to lookup sumtotal from data with spaces 3
macro to print report 0

Top