Dear Alokeshwar You were right. This is indeed Magic --- created by you. You have no idea how easy this has become for me now. :) :) Exactly what I was looking for.
However, apologize for the additional trouble for forgetting to mention the Excel Version I was using. Thanks a lot. Many Many Many times over. You are a lifesaver :) Thanks once again. Ashish On Wed, Jan 6, 2010 at 4:52 AM, Alokeshwar Tiwary < [email protected]> wrote: > > There was a typo. Please read step 6 as following: > > 6. Scroll and look for Microsoft 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 <[email protected]> > > *To:* [email protected] > *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 <[email protected]> > *To:* [email protected] > *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 < > [email protected]> 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 <[email protected]> >> *To:* [email protected] >> *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 < >> [email protected]> 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 <[email protected]> >>> *To:* [email protected] >>> *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 [email protected] >>> If you find any spam message in the group, please send an email to: >>> Ayush Jain @ [email protected] >>> <><><><><><><><><><><><><><><><><><><><><><> >>> 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.rd.yahoo.com/tagline_yyi_1/*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 [email protected] >>> If you find any spam message in the group, please send an email to: >>> Ayush Jain @ [email protected] >>> <><><><><><><><><><><><><><><><><><><><><><> >>> 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 [email protected] >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ [email protected] >> <><><><><><><><><><><><><><><><><><><><><><> >> 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.rd.yahoo.com/tagline_yyi_1/*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 [email protected] >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ [email protected] >> <><><><><><><><><><><><><><><><><><><><><><> >> 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 [email protected] > If you find any spam message in the group, please send an email to: > Ayush Jain @ [email protected] > <><><><><><><><><><><><><><><><><><><><><><> > 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.rd.yahoo.com/tagline_yyi_1/*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 [email protected] > If you find any spam message in the group, please send an email to: > Ayush Jain @ [email protected] > <><><><><><><><><><><><><><><><><><><><><><> > 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.rd.yahoo.com/tagline_yyi_1/*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 [email protected] > If you find any spam message in the group, please send an email to: > Ayush Jain @ [email protected] > <><><><><><><><><><><><><><><><><><><><><><> > 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 [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] <><><><><><><><><><><><><><><><><><><><><><> 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
