Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I know Excel pretty well, but am just getting to grips with VBA, and am
stuck on this problem. I am receiving enquiries from a web form which are ending up in my email inbox. I then copy these details (the usual stuff: name, address, telephone etc) into cells in a spreadsheet. I've been doing this by manually copying and pasting but I'm looking for a way to speed this up, and learn some VBA in the process. My thought was to copy and paste the email text/data into a text box in a userform, then hit a button to parse the data into a spreadsheet (or perhaps as a halfway house, just split the data up and insert it into text boxes on the same form. I know how to update a worksheet from individual textbox/fields). The block of text to be parsed contains the labels like "name:" , "address:" , "email:" etc to preface the user data, though not all of these are compulsory, so they don't always appear. Each lump of data is separated from the next label with 3 carriage returns. Could someone suggest an approach to this please, or even a pointer to a web page that might help? I've done some general searching but nothing quite answers the question. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text parsing HELP | Excel Discussion (Misc queries) | |||
Parsing text | Excel Worksheet Functions | |||
parsing text | New Users to Excel | |||
parsing text | Excel Discussion (Misc queries) | |||
Parsing text | Excel Discussion (Misc queries) |