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.