There was a typo. Please read step 6 as following:
6. Scroll and look forMicrosoft Word 10.0 Object Library. Check the box to add
it to VBA project.
_________________________________________________________________________________________________
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
________________________________
From: Alokeshwar Tiwary <alokeshwar.tiw...@yahoo.com>
To: excel-macros@googlegroups.com
Sent: Wed, 6 January, 2010 4:49:18 AM
Subject: Re: $$Excel-Macros$$ Export from word to excel
I wrote this code in Excel 2003 and used Microsoft Word 11.0 Object Library.
Excel 2000 supports Microsoft Word 10.0 Object Library. Please follow these
instuctions:
1. Open the excel spreadsheet.
2. Do Alt+F11
3. VBA project will open. Go to Tools -> References in VBA Project
4. References - VBA Project box will open.
5. There must be a missing object library reference. Uncheck the box to remove
it.
6. Scroll and look for Microsoft Word 11.0 Object Library. Check the box to add
it to VBA project.
7. Click on Ok and save the file.
8. Try to run the macro again. It should be working fine now.
Let me know if you have any questions.
Regards,
Alokeshwar
9891442001
_________________________________________________________________________________________________
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
________________________________
From: Ashish Pradhan <ashlyprad...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Tue, 5 January, 2010 3:48:45 PM
Subject: Re: $$Excel-Macros$$ Export from word to excel
Hi Alokeshwar
Tried the command button. Got an error "Compile error: Cant find project or
library" line highlighted was .Wrap = wFindStop
The excel version I am using is Excel 2000 incase its required.
Also, thanks for the effort. Looking forward to hearing from you again.
Thanks
Ashish
On Tue, Jan 5, 2010 at 12:42 PM, Alokeshwar Tiwary
<alokeshwar.tiw...@yahoo.com> wrote:
See attached. Download the file on your desktop and open the excel spreadsheet.
>There is a command button on sheet1. Click on it and select the word files you
>want to import mobile nos from. Click ok and wait. It should do the magic.
>
>***IMPORTANT***: if you have to export the code to some other workbook, please
>remember to add 'Microsoft Word 11.0 Object Library' in VBA.
>
>Regards,
>Alokeshwar
>09891442001
>
>_________________________________________________________________________________________________
>"There are known knowns. These are things we know that we know. There are
>known unknowns. That is to say, there are things that we know we don't know.
>But there are also unknown unknowns. There are things we don't know we don't
>know."
>
>
>
>
>
________________________________
From: Ashish Pradhan <ashlyprad...@gmail.com>
>To: excel-macros@googlegroups.com
>Sent: Mon, 4 January, 2010 2:03:44 PM
>Subject: Re: $$Excel-Macros$$ Export from word to excel
>
>
>Hello Alokeshwar
>
>Thanks a lot for looking into my query. Sorry for not replying earlier as I
>was travelling over the weekend.
>
>Am attaching two files.
>
>sample_word.doc : This file is the 'input' file. Data is input in the manner
>shown in this word file.
>sample_excel.xls : This file is the manner in which I want the output based on
>the data in the word file. (In this excel file, only data after '(M)' is
>captured and not data after '(Tel)'. If there is a blank after (M), the output
>in the excel file should have a blank
>
>
>Any help is deeply appreciated.
>
>Thanks again
>
>
>Ashish
>
>On Sat, Jan 2, 2010 at 8:03 PM, Alokeshwar Tiwary
><alokeshwar.tiw...@yahoo.com> wrote:
>
>Ashish,
>>
>>It's absoulutely possible. Can you attach a few word files for example.
>>
>>Regards,
>>Alokeshwar
>>09891442001
>>
>>
>>_________________________________________________________________________________________________
>>"There are known knowns. These are things we know that we know. There are
>>known unknowns. That is to say, there are things that we know we don't know.
>>But there are also unknown unknowns. There are things we don't know we don't
>>know."
>>
>>
>>
>>
>>
________________________________
From: Ashish Pradhan <ashlyprad...@gmail.com>
>>To: excel-macros@googlegroups.com
>>Sent: Sat, 2 January, 2010 6:52:01 PM
>>Subject: $$Excel-Macros$$ Export from word to excel
>>
>>
>>Dear All,
>>
>>This may possibly not be the correct forum to ask my question. My
>>problem is as follows:
>>
>>I have a word document file in the following format;
>>
>>Name
>>Address1
>>Address2
>>Area
>>City - Pincode
>>(M)
>>
>>I now need to extract only the number which is mentioned after the
>>field (M) into an excel file. There are many word document files from
>>which I need to extract the numbers and each file has many pages. It
>>is cumbersome to extract them manually. Also, if this is possible, I
>>need only the mobile number or blanks after (M). I.e. I do not want
>>(M).
>>
>>Please help if possible.
>>
>>Thanks
>>
>>Ashish
>>
>>--
>>Ashish
>>
>>--
>>----------------------------------------------------------------------------------
>>Some important links for excel users:
>>1. Follow us in TWITTER for tips tricks and links :
>>http://twitter.com/exceldailytip
>>2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>>http://www.excelitems.com
>>3. Excel tutorials at http://www.excel-macros.blogspot.com
>>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>>To post to this group, send email to excel-macros@googlegroups.com
>>If you find any spam message in the group, please send an email to:
>>Ayush Jain @ jainayus...@gmail.com
>><><><><><><><><><><><><><><><><><><><><><><>
>>HELP US GROW !!
>>
>>We reach over 6,500 subscribers worldwide and receive many nice notes about
>>the learning and support from the group.Let friends and co-workers know they
>>can subscribe to group at
>>http://groups.google.com/group/excel-macros/subscribe
>>
>>
>>________________________________
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
>>--
>>----------------------------------------------------------------------------------
>>Some important links for excel users:
>>1. Follow us in TWITTER for tips tricks and links :
>>http://twitter.com/exceldailytip
>>2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>>http://www.excelitems.com
>>3. Excel tutorials at http://www.excel-macros.blogspot.com
>>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>>To post to this group, send email to excel-macros@googlegroups.com
>>If you find any spam message in the group, please send an email to:
>>Ayush Jain @ jainayus...@gmail.com
>><><><><><><><><><><><><><><><><><><><><><><>
>>HELP US GROW !!
>>
>>We reach over 6,500 subscribers worldwide and receive many nice notes about
>>the learning and support from the group.Let friends and co-workers know they
>>can subscribe to group at
>>http://groups.google.com/group/excel-macros/subscribe
>>
>
>
>--
>Ashish
>
>
>
>--
>----------------------------------------------------------------------------------
>Some important links for excel users:
>1. Follow us in TWITTER for tips tricks and links :
>http://twitter.com/exceldailytip
>2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>http://www.excelitems.com
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
>To post to this group, send email to excel-macros@googlegroups.com
>If you find any spam message in the group, please send an email to:
>Ayush Jain @ jainayus...@gmail.com
><><><><><><><><><><><><><><><><><><><><><><>
>HELP US GROW !!
>
>We reach over 6,500 subscribers worldwide and receive many nice notes about
>the learning and support from the group.Let friends and co-workers know they
>can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
>
>
>________________________________
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
>--
>----------------------------------------------------------------------------------
>Some important links for excel users:
>1. Follow us in TWITTER for tips tricks and links :
>http://twitter.com/exceldailytip
>2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>http://www.excelitems.com
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
>To post to this group, send email to excel-macros@googlegroups.com
>If you find any spam message in the group, please send an email to:
>Ayush Jain @ jainayus...@gmail.com
><><><><><><><><><><><><><><><><><><><><><><>
>HELP US GROW !!
>
>We reach over 6,500 subscribers worldwide and receive many nice notes about
>the learning and support from the group.Let friends and co-workers know they
>can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
>
--
Ashish
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
________________________________
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
http://in.yahoo.com/--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
