Open txt file using vba code

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

In MS-excel2003, when we click on a button we have to open a txt file which
we already assigned.Please suggest vba code for this.
 
If you're opening a text file, you'll probably want to parse each field
according to rules that only you know.

I'd suggest that you record a macro when you do it manually and you'll have code
that works ok.
 
Hi Tom,

You should be able to record a macro to open the file. If you need further
help to modify the recorded code to make it more dynamic to say match a
filename in an existing worksheet or something then post the code you
recorded and describe how you want to make the code more dynamic.
 
You must log in or register to reply here.

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

Good way to open a .txt file, copy/paste all text into Excel? 3
Open txt file without changing date 1
opening an existing text file useing code 3
Date format error with CSV file 6
Open Folder Help required 2
Macro for write a txt file 7
Open a folder 1
Macro that will insert a simple text string in top cell of text file 1

Back
Top