Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
All,
I have a very useful report I get weekly (text document) that is in a very un-useful format... It gives me information on all my personnel (hundreds of folks) in a "justified" format. I want to import the information I need from each individual into excel (CSV file) so I can manipulate the data or search, etc... In the end, I'll probably use Access - but I still have the same problem. The easiest way I know to grab the information I need is using Regular Expressions to parse through each line of the report. I "use-ta-could" in PERL, or I could teach myself using C#. I really would like to write the code using VBA because I'm starting to feel comfortable with the language and I've created about a dozen routines that I use in Word/Excel/PowerPoint. I'd like to continue becoming more proficient. Any help putting me in the right direction would be greatly appreciated. Rob F |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Get rid of with regular expressions | Excel Discussion (Misc queries) | |||
Regular expressions in VB | Excel Discussion (Misc queries) | |||
Regular Expressions & Middle Name | Excel Worksheet Functions | |||
Regular expressions in Excel | Excel Discussion (Misc queries) | |||
VBA and Regular expressions | Excel Programming |