Have you tried selecting the data in Word, copying it to the clipboard, then
going to Excel and select cell A1 on a new sheet and do Edit =Paste. Then
select column 1 and do Data = Text to Columns and walk through the wizard?

You can turn on the macro recorder in Word while you do this manually to get
the word syntax.

Then repeat again with the macro recorder turned on in Excel.



--
Regards,
Tom Ogilvy


"Chill1 " wrote in message
...
I'll start this off by saying that I've worked with C++, C, Java, and a
number of UNIX scripting languages but have little or no knowledge of
VBA. Working with VBA is somewhat essential to the project I'm working
on at the moment so I came here for help. Just thought I'd present this
so that any reply includes everything, down to the little details that
may seem second nature to someone who has experience with VBA. Thanks,
and now, onto the question

The company I'm working for needs a program that takes output from
their Provantis storage system (which gives the most ass-backwards file
formatting I've ever seen) and put it into an Excel spreadsheet in a
usable format. I need help with opening and parsing the Word file.
Anything relevant is welcome, but particularly information on setting
delimiters VBA will read between, any functions that get lines or
words, and how to then put any of this into a spreadsheet.

I know it's a lot (or maybe it's very simple and I just dont know
jack), and my thanks to anyone that take the time to reply


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