thanks a lot for the solution can u please make it for notepad files too On Sun, Jan 10, 2010 at 3:02 PM, Alokeshwar Tiwary < [email protected]> wrote:
> Criteria or parameters aren't necessory but it may not be extracting data > in a useful format. > I have modified the macro to Select and import entire text from a word > doc. > > > > _________________________________________________________________________________________________ > "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:* Zilla <[email protected]> > *To:* Alokeshwar Tiwary <[email protected]> > *Sent:* Sun, 10 January, 2010 1:31:23 PM > > *Subject:* Re: $$Excel-Macros$$ Export from word to excel > > I thought it could be an excel sheet that imported info from any word > doc you pointed it to. So are you saying they has to be some kind of > parameters set on the code to import the data? > > On Jan 9, 1:38 pm, Alokeshwar Tiwary <[email protected]> > wrote: > > > yes, its possible. Send me example files. > > > _________________________________________________________________________________________________ > > "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: Zilla <[email protected]> > > To: Alokeshwar Tiwary <[email protected]> > > > Sent: Sun, 10 January, 2010 2:51:33 AM > > Subject: Re: $$Excel-Macros$$ Export from word to excel > > > > 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. > > > > ... > > > > read more ยป > > ------------------------------ > 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 > >
-- ---------------------------------------------------------------------------------- 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
