A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Programming
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

convert unformated text from word to excel



 
 
Thread Tools Display Modes
  #1  
Old May 1st 11, 03:12 AM posted to microsoft.public.excel.programming
john-lau
external usenet poster
 
Posts: 10
Default convert unformated text from word to excel

Hello,

I have a very harsh task at office. I can get the report from company system
in
the format of word file. Its regarding new customer and their account
information. Most important part is account number's, the format of account
number is xxx-xxxxxx-xxx, x means number, example, 123-456789-399

I search the macro in the internet for 4 hours. I know that there is a macro
for
convert tables in word documents to excel.

If there is unformated text in word file (As I get the report from system and
convert to word file, all text will changed to unformated (no table) , can I
use
macro to do this task. For example, in word documents, there are fiften
account
numbers, use macro to copy account numbers from word to excel.
Ads
  #2  
Old May 1st 11, 05:40 PM posted to microsoft.public.excel.programming
GS[_2_]
external usenet poster
 
Posts: 2,251
Default convert unformated text from word to excel

john-lau laid this down on his screen :
> Hello,
>
> I have a very harsh task at office. I can get the report from company system
> in
> the format of word file. Its regarding new customer and their account
> information. Most important part is account number's, the format of account
> number is xxx-xxxxxx-xxx, x means number, example, 123-456789-399
>
> I search the macro in the internet for 4 hours. I know that there is a macro
> for
> convert tables in word documents to excel.
>
> If there is unformated text in word file (As I get the report from system
> and convert to word file, all text will changed to unformated (no table) ,
> can I use
> macro to do this task. For example, in word documents, there are fiften
> account
> numbers, use macro to copy account numbers from word to excel.


How does it 'convert to Word file' from system report? Can system nat
also convert to Excel file?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert any number in text or word in excel? formula New Users to Excel 1 April 1st 09 09:56 PM
Convert Text in Excel To Word Doc sunny1 Excel Discussion (Misc queries) 1 August 31st 05 10:18 PM
Download existing file from floppy disk excel but said unformated DG Excel Discussion (Misc queries) 2 August 14th 05 02:57 AM
convert number to word (text) ROHIT Excel Discussion (Misc queries) 3 July 20th 05 01:27 PM


All times are GMT +1. The time now is 04:10 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2004-2013 ExcelBanter.
The comments are property of their posters.