Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify text file before import to Excel
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 "HappyDevil24 " wrote in message ... 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 before 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 importing it. Any guideline? My text file only contain one line, if you notice, this is actually the ATT file return by HTML form. Thanks in advance. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify text file before import to Excel
It might be easier to import the line and then do the replace using the
built in replace command. -- Regards, Tom Ogilvy "HappyDevil24 " wrote in message ... 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 before 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 importing it. Any guideline? My text file only contain one line, if you notice, this is actually the ATT file return by HTML form. Thanks in advance. --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify text file before import to Excel
Thanks for the advise. But I am new to excel, any example, where can
get this replace and change command? Thanks -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify text file before import to Excel
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. Thanks guys for the help -- Message posted from http://www.ExcelForum.com |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify text file before import to Excel
Edit|Replace
(or ctrl-H) "HappyDevil24 <" wrote: Thanks for the advise. But I am new to excel, any example, where can I get this replace and change command? Thanks. --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify text file before import to Excel
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I import text file of cash flow to excel file then use formula | Excel Discussion (Misc queries) | |||
how to import more than 1 text file into the same Excel worksheet. | Excel Discussion (Misc queries) | |||
How to import Text file to Excel | Excel Programming | |||
How to import more than one text file into Excel ? | Excel Programming |