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
