I like the the first excel file you created that just imported the numbers beside (M). Is there a way to alter the excel spreadsheet to import everything from a word doc you point at and not just what is beside (M)? This would be very helpful for me.
On Jan 6, 8:40 pm, Alokeshwar Tiwary <[email protected]> wrote: > 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 athttp://www.excel-macros.blogspot.com > >>>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >>>> 5. Excel Tips and Tricks athttp://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 athttp://www.excel-macros.blogspot.com > >>>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >>>> 5. Excel Tips and Tricks athttp://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 athttp://www.excel-macros.blogspot.com > >>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >>> 5. Excel Tips and Tricks athttp://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/> > > ... > > read more »
-- ---------------------------------------------------------------------------------- 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
