View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HappyDevil24 HappyDevil24 is offline
external usenet poster
 
Posts: 1
Default Modify text file before import to Excel

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.


&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

--
Message posted from http://www.ExcelForum.com