i m glad that u liked it On Wed, 06 Jan 2010 17:19 IST Ashish Pradhan wrote:
>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 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 [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
