470,870 Members | 992 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,870 developers. It's quick & easy.

Open MS Word file in VB, read lines and save it in MS Excel

I am new to this forum. Thanks in advance for and help. The following is what I am looking for:

1. I need help with VB code to open a MS Word (.doc) file.
2. Read lines from the MS Word (.doc) file [ and do whatever I need to do (parse the line/string, etc.) ... which I should be able to ... :-) ]
3. Save the specific/parsed data on one of the sheets in MS Excel spread sheet.
4. Close up the MS Word (.doc) file.

The VB part is based on the MS Excel spreadsheet file [Alt-F11]. One of the sheet on spreedsheet will have the path name [ C;\database\C2K] and file name [Audio_test_data.doc]. If someone could show me the code to open the Audio_test_data.doc file from the path, read each line, [I will be able to parse the line/string and save the necessary data on the specific sheet of the Excel spread sheet] and finally close the Audio_test_data.doc file.
Jun 6 '07 #1
0 2124

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Andras Gilicz | last post: by
1 post views Thread by Eager-Learner | last post: by
6 posts views Thread by Michael Groeger | last post: by
7 posts views Thread by Peter | last post: by
15 posts views Thread by pakerly | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.