Modify text file before import to Excel

H

HappyDevil24

Hi,



New to this Excel programming. Any help would be highly appreciated.

For my case, I want to modified a line of text in a text file befor
import to excel. Example, a text file contain this line.


Name=Ricky&[email protected]&Age=20&Address=1%20Earl%20Street&Country=Australia

Now I want to remove these words, "Name=", "Email=", "Age=", "Address=
and "Country=", from this text file using macro (VB) before importin
it. Any guideline?

My text file only contain one line, if you notice, this is actually th
ATT file return by HTML form.

Thanks in advance
 
B

Bob Flanagan

Why not just import the file and use the change command in Excel? You can
record the macro of those actions and it is a lot simplier.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
T

Tom Ogilvy

It might be easier to import the line and then do the replace using the
built in replace command.
 
H

HappyDevil24

Thanks for the advise. But I am new to excel, any example, where can
get this replace and change command? :confused:

Thanks
 
H

HappyDevil24

Hi, btw, my excel file might need to update daily so every line in th
text file will be one new row in this excel file. :rolleyes:

Thanks guys for the help
 
D

Dave Peterson

Edit|Replace
(or ctrl-H)



HappyDevil24 < said:
Thanks for the advise. But I am new to excel, any example, where can I
get this replace and change command? :confused:

Thanks.
Click to expand...
 
Top